Course Information

Duration: Two-Day Course
Platform: Windows Only
Fee: $545 CDN (+GST)

This class is limited to eight people.

Course Overview

This course introduces you to a powerful database application software, Microsoft Access. During this course, you will learn to create tables, forms, queries and reports. Students will create fields and records, specify properties for fields, format forms and reports and run queries.  In this course, Excel files will be imported into an Access database and a mail merge with MS Word will be included.

Course Content

• Create and save a database file
• Design a table with various field types and properties
• Understand the primary key
• Create combo boxes to create drop-down menus in fields
• Save and name tables
• Create a columnar form based on a table
• Use the formatting tools and the Toolbox to design forms
• Understand the types of controls on forms
• Save and name forms
• Create select queries using various wildcards and operators
• Run select queries
• Save and name select queries
• Run Delete and Update queries
• Set up relationships between databases based on a key field
• Display related tables in a query
• Create reports based on tables or queries
• Place a calculated control on a report
• Save and name reports
• Create calculated fields in a query
• Create summary queries to summarize data
• Set up validations to ensure accurate data entry
• Import data from an Excel workbook
• Generate an MS Word mail merge