Access allows you to manage your data and databases and the relationship between the two. In practice this means that you can save data to different tables that are interrelated. You can use forms to create a clearly-arranged interface for entering data into the tables. You can use queries to extract information from tables and present the information efficiently and clearly in reports. During this training course, you will learn how to use an existing database in Access by inputting data in the first place and then by creating queries and reports to represent the existing data in many possible ways.

Introduction to Microsoft Access

• What is a relational database? The concepts of tables and relationships. Fields, records, primary keys, etc.
• Get to know the Access interface

Manage tables

• Fill in, delete, modify data (via table view and autoform)
• Navigating a table
• Reposition columns
• Sort and Filter in a table
• Retrieving data

Querying tables via queries

• Create a simple selection query
• Using selection criteria (AND, OR, NOT)
• Combine multiple criteria into a single query
• Sorting the results
• Setting the layout of a query (e.g. column width)
• Create parameter queries with a fill-in value
• Calculations in queries
• Grouping the results
• The power of crosstab queries
• Queries based on multiple tables or other queries

Visualize your tables through forms and reports

• Understanding the difference between a form (on screen) and a report (printer)
• Using the autoform
• Creating different forms with the wizard
• Using the autoreport
• Create different reports with the wizard
• Using and printing a report
• Make small adjustments to the structure of the report: e.g. adding a logo in the header
• Working with the different parts of a report
• Group and sort in a report