Access Level 2: Intermediate Database Concepts
Take Access past the basics with tighter data and smarter queries. Control what gets entered, join tables for flexible reporting, sharpen your forms and reports, and move data cleanly in and out of Excel and other document types.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
Students will build on core Access skills to control data entry with field properties and validation, join tables and create flexible queries, improve forms and reports, and share data with other applications.
Prerequisites
To ensure your success, we recommend that you have experience with creating tables, queries, forms, and reports in Access. Students can obtain this level of skill through our Access Level 1 course.
Course outline
- Constrain Data Entry Using Field Properties
- Establish Data Entry Formats for Entering Field Values
- Create a List of Values for a Field
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Set the Select Query Properties
- Retrieve Records Based on Input Criteria
- Create Action Queries
- Restrict Data Entry in Forms
- Organize Information with Tab Pages
- Add a Command Button to a Form
- Create a Subform
- Display a Summary of Data in a Form
- Change the Display of Data Conditionally
- Organize Report Information
- Format Reports
- Control Report Pagination
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge