Applications  Supported

 

Notify us if you have any questions.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Microsoft Access 2010 Level 2
 
You have the basic skills needed to work with Microsoft® Office Access™ 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

 
 

Related Links: Access 2010 Level 1, Database Classes

Course Length: 1 Day 

 
 

Course Description:

Lesson 1: 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

Lesson 2: Joining Tables
 Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table

Lesson 3: Creating Flexible Queries
 Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

Lesson 4: 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

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

Lesson 6: Sharing Data Across Applications
 Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge