Access
Access Level 2: Intermediate Database Concepts
CPE Eligible - visit /cpe for details.CPE page →
Scheduled dates
No public dates scheduled yet
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 outline
Controlling Data Entry
- Constrain Data Entry Using Field Properties
- Establish Data Entry Formats for Entering Field Values
- Create a List of Values for a Field
Joining Tables
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
Creating Flexible Queries
- Set the Select Query Properties
- Retrieve Records Based on Input Criteria
- Create Action Queries
Improving Forms
- 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
Customizing Reports
- Organize Report Information
- Format Reports
- Control Report Pagination
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Sharing Data across Applications
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge