Access Level 2: Intermediate Database Concepts

Level 2Full Day1 DayVersion 365Official CPE Provider

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.

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

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