Microsoft Access: Intermediate

Course Dates:

Call for Dates

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

WU EDGE - Western Union Business Solutions


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy