Access Level 2: Intermediate Database Concepts

Level 2Full Day1 DayVersion 365Official CPE Provider

Course Outline

6 lessons · 24 topics

1Controlling Data Entry

Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field

2Joining Tables

Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table

3Creating Flexible Queries

Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

4Improving 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

5Customizing Reports

Organize Report Information
Format Reports
Control Report Pagination
Add a Subreport to an Existing Report
Create a Mailing Label Report

6Sharing Data across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals