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

Microsoft Access: Basic

Course Dates:

18 Jun 2018
20 Aug 2018
29 Oct 2018

Course Specifications

Course length: 1.0 day(s)

Course Objective:

You will create and modify new databases and their various objects.

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design forms
  • Generate reports

Course Content

Lesson 1: Getting Started with Access Databases

  • Identify the Elements of the Access Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process

Lesson 2: Building the Structure of a Database

  • Create a New Database
  • Create a Table
  • Manage Tables
  • Establish Table Relationships

Lesson 3: Managing Data in a Table

  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets

Lesson 4:  Querying a Database

  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form

Lesson 6: Generating Reports

  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list