Course Content
CONTROLLING DATA ENTRY
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
JOINING TABLES
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
CREATING FLEXIBLE QUERIES
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
IMPROVING FORMS
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
CUSTOMIZING REPORTS
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
SHARING DATA ACROSS APPLICATIONS
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document