VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Access: Intermediate

Course Dates:

5 June 2018

Course Specifications

Course length: 1.0 day(s)

Course Objective:

You will improve and customize tables, queries, forms and reports, and share Access data with other applications.

  • Streamline data entry and maintain data integrity
  • Join tables to retrieve data from unrelated tables
  • Create flexible queries to retrieve data and modify tables
  • Improve the functionality of Access 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 That Have 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 Calculated Field to a Report
  • 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 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list