Microsoft® Access 2013 Level II

Open Enrollment Course Dates: TBA

Click here to pre-register for this course now!

Course Length: 1 day
PDUs: 6.5
PMI Activity ID# 000330
Prerequisites: Microsoft® Access 2013 Level I or equivalent knowledge
Course Level: Intermediate
Course Fee: $345
Course Hours: 8:30-4:15

Course Description: This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft® Office Word or Excel.

Course Objectives:

  • Streamline data entry and maintain data integrity.
  • Join tables to retrieve data from unrelated tables.
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  • Improve forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications

Course Content:
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
Summarize Report Information
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