Join author and database expert Adam Wilbert on a tour of the essential features of Microsoft Access 2013 and discover how to build a database and store your data more efficiently. First, Adam explains the concepts behind relational databases, before moving onto building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. The course also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.

ContentsIntroduction1. Getting Started2. Creating Tables3. Setting Field Properties4. Organizing Records5. Using Queries6. Working with Specialty Queries7. Creating Forms8. Designing Forms9. Creating Reports10. Working with Macros11. Integrating Access with the Office Suite12. Maintaining the DatabaseConclusion