About Access Database BlogThe About Access Database blog is a journal of topics that explain how Access databases are created, managed and deployed. --Any new content added to my web site will appear here informing you of any new hints 'n' tips for certain features that Access has to offer. --There are plenty of examples, good techniques and code snippets to help improve the power in such a database application. --As new example files are added namely templates, ready made forms and reports, users will have the opportunity to hear about them on my web site. --I will also offer e-books that can be downloaded and would be happy to allow users to compile there own user guides should visitors wish to incorporate my material in their processes. Please click the orange 'RSS' button to join and I look forward to getting to know you. Ben Beitler
PS: Check out my other
Access Database Tutorial Blog
PPS: Find me on Facebook:
Access Database (Facebook) Learn About Access Databases - Mastering Microsoft Access databaseLearn about Access Databases from an expert with over 17 years experience. What's new in Access 2010, good design techniques, Access database tutorials, access templates and useful resources. About Access Database - File DownloadsAbout Access Databases files can be downloaded here including data files to support the techniques and methods shown on this website. Permalink -- click for full blog post "About Access Database - File Downloads" Understanding Access Relationships between Tables and types of JoinsSetting Access Relationships and utilising the Primary Key will improve functionality and the flexibility of creating and running queries and reports. Using Access Relational Database tools to join Tables togetherUsing the Access Relational Database tool to create joins between two or more Tables. Optionally learn about and apply the referential integrity setting to data entry processing. Understanding what Primary Key, Foreign Key and Indexes is KEY!Why set a Primary Key? Indexing in an Access Database is essential and limits functionality. Learn about Primary and Foreign keys along with indexes and how to set them up. Learn about Access Report design techniques from a blank canvas approachLearn how to create an Access Report starting from a blank canvas mastering the controls and their properties that a simple Report wizard can not do. Create an Access Database Report using the wizard toolProducing an Access Database Report is simple step by step process using the powerful wizard tool available. Different ways to group and display presentable rich formated reports. Permalink -- click for full blog post "Create an Access Database Report using the wizard tool" Using the SQL DISTINCT statement to list unique records or valuesThe SQL DISTINCT keyword statement suppresses duplicate data infomation either by record or value. The DELETE Query is one of the ACTION queries that will delete recordsThe DELETE Query is a useful way to delete record information with optional criteria. The UPDATE Query is one of the ACTION queries that updates data with criteriaThe UPDATE Query is a useful way to change data of existing values via setting optional criteria. The APPEND Query is one of the ACTION queries that adds data to other tablesThe APPEND Query is a useful way to copy data, appending to existing data tables elsewhere sometimes with criteria. MAKE TABLE Query is one of the ACTION queries that 'makes a table'!A MAKE TABLE Query does exactly what is says 'makes a table'. Useful for archiving and backing up data with criteria. Microsoft Access Switchboard Form - creating a menu driven interface systemCreating an Access switchboard form or a menu screen gives your database a simple to use system allowing users to navigate around the system and run quick reports Microsoft Access Dialog Box Form - to allows users to interact with the databaseAn Access dialog box form is a communication portal between users and the system passing data and values to interact with Access. Microsoft Access Read Only Form - protecting users from editing recordsCreating and using and Access read only form protects users from editing and deleting records making this a screen enquiry only interface. Microsoft Access Data Entry Form - maintain records in a simple to use layoutAccess an data entry form will give users an easy to use interface to add, modify and delete records in a controlled environment protecting users and your data. Mastering Microsoft Access Forms to create a user friendly databaseCreating Microsoft Access forms will provide a rich look and feel to a database that will help users navigate and control how their manage data more effectively. Form Design techniques in an Access Database - starting from a blank canvasLearn how to create an Access Database Form design from a blank canvas mastering the controls and their properties that a simple Form wizard can not do. Access 2010 / 2007 - What's new?What's new in Microsoft Access 2010 (and 2007)? The newer versions is worth a look! Permalink -- click for full blog post "Access 2010 / 2007 - What's new?" Master the Query Criteria principles and examples used in Microsoft AccessMastering the Query Criteria concepts and conventions across the different data types used. |
Links
Learning SEO Optimization | Finding Keyword Phrases
Reviews - Books
The following books are my personal recommendations for all levels of Access database users and developers.
Enjoy!
It covers versions from 2000 through to 2010 which has some very interesting and new powerful features. Beginner or not, there is something for everyone and Microsoft now encourages developers to use Access macros as the first choice option to automate your database.
This is a great book for beginners. It takes you through from the very beginning without too much jargon 'computer' talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology.
You’ll want to keep this soup-to-nuts Access reference close at hand!
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. Two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It's the one I use as a reference for VBA students!
(click on image below)