Microsoft Access: Introduction to Intermediate (Level 1-2)

This two-day course is designed to: Help a delegate to obtain the skills required to update records in a database and to use Microsoft Access to create a basic database. A delegate will learn to design tables and queries to to create forms using built-in tools. A delegate will also learn to create relational databases and Import & Export data.

Group Bookings Only:
Our offices – minimum of 6 delegates per group
On Site – Minimum of 8 delegates per group

Duration: 2 Day
Who should attend? Any delegate wanting to obtain skills to design basic database structures using Microsoft Access.
Course Prerequisite: Microsoft Windows: Introduction & Microsoft Excel: Intermediate

Course Outline

  • What is Microsoft Access?
  • What is a Database?
  • Database Terminology
  • The Database Foundation
  • Access Wizards
  • Ground Rules for Database Design
  • Starting Microsoft Access
  • The Microsoft Access Work Screen
  • Creating a Blank Database
  • Database Window Toolbar
  • Creating a Database — Database Wizard
  • Saving/Closing/Opening a Database
  • Working in a Database Window
  • View Operating Modes
  • Object Properties
  • Backup a Database
  • Creating a Table with the Table Wizard
  • Creating a Table from Scratch
  • Understanding Data Types & Formats
  • Primary Key
  • Editing a Table
  • Entering Data into a Table
  • Editing Data in a Table
  • Datasheet View
  • Formatting a Table / Datasheet
  • Finding Records
  • AutoCorrect
  • Spell Check
  • Find & Replace
  • Filter & Sort Tables
  • Create Hyperlinks
  • Fields & Formats
  • Edit Field Attributes
  • Set Value Limits
  • Validation Rule Expressions
  • Use Default Values
  • Create Required Fields
  • Use Input Masks
  • Defining Indexes
  • Lookup Fields
  • What are Forms?
  • Creating a Form — AutoForm
  • Creating a Form — Form Wizard
  • Creating a Form from Scratch
  • Editing a Form
  • Formatting a Form
  • Changing the Tab Order
  • Searching for Data in a Form
  • Use Calculated Fields in a Form
  • Creating a Query — Wizard
  • Query Basics
  • Printing Query Results
  • Modify a Query
  • Create a Select Query
  • Sorting Query Data
  • Use Multiple Criteria (And/Or)
  • Create a Calculation Query
  • Use an Action Query
  • Create a Parameter Query
  • Importing & Exporting Data
  • Export to Excel
  • Import from Excel
  • Export to a Text File
  • Import a Text File
  • Import a dBASE File
  • Import an Access Object
  • Data Relations
  • Primary & Foreign Keys
  • Use Analyzing Tools
  • Establish Simple Relationships
  • Establish Complex Relationships
  • Referential Integrity
  • Subdatasheets
  • Creating Reports — AutoReport
  • Creating Reports — Report Wizard
  • Layout a Report
  • Modify Display Attributes
  • Use Calculated Fields & Printing
  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire

Download Information

Click on the button to download

Course Schedule

View the available course dates

Contact Us

Contact Us now to find out more…