Microsoft Office Access

Microsoft Access can be one of the most confusing software platforms in the Microsoft Office Suite as it is the most mis-understood. Simply put, Microsoft Access is an information management tool that provides users with the ability to store information for: referencing, reporting, and analysis.

Microsoft Access gives users with the ability to analyze large amounts of information and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. It does this by enabling the user to run queries, and set up Graphical User Interfaces (GUI) to simplify tasks by performing them at the click of a button. Reports can be generated easily and efficiently.

Microsoft Access is widely used among Government, Crown Corporations and Non-Profits due to its relatively reasonable cost, and less complicated learning curve as compared to SQL databases.

We offer courses in Access Level 1, Access Level 2, and Custom Access courses. Courses can be delivered in 3-hour blocks, and scheduled in the morning, afternoon, or early evenings. Yes, we also provide weekend training classes.

Microsoft Access - Introduction to Data Entry and Reports

Who should attend?         This course is intended for new Microsoft Access users.
Prerequisites:                     Windows 7, Windows 8, or Windows 10.

Duration:                             6 Hours

Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:

  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Preview and print database objects, and change the page setup options.

Course Content

The Basics:

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access Files
  • Working with Objects
  • Using Access Help

Table Data:

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters

Queries:

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries

Reports:

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes

Printing:

  • Printing Objects
  • Print Preview

 

Microsoft Access - Level 1 Database Design (2 Days)

Who should attend?         This course is intended for new Microsoft Access users.
Prerequisites:                     Windows 7, Windows 8, or Windows 10.

Duration:                             12 Hours (2 Days)

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create and customize a table design.
  • Enter data into tables, and ensure its accuracy by using input masks and input validation formulas.
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity.
  • Create forms for entering data into tables, and change the design elements that have been placed on those forms.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Import and export data to and from various sources, including text files and Excel.
  • Preview and print database objects, and change the page setup options.

Course Content

The Basics:

  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access Files
  • Working with Objects
  • Using Access Help

Table Data:

  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters

Table Design:

  • Creating a Table
  • Changing the Table Design

Data Entry:

  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records

Relationships:

  • Relationships Between Tables
  • Creating a Relationship
  • Referential Integrity
  • Removing a Relationship
  • Printing Relationships

Creating and Using Forms:

  • Creating a Form Using AutoForm
  • Creating a Form Using the Form Wizard
  • Creating a Form in Design View
  • Opening a Form; Changing a Form Design
  • Adding Controls; Placing Controls
  • Multiple-Choice Controls
  • Error Checking

Queries:

  • Using the Query Wizard
  • Creating a Query in Design View
  • Selecting and Sorting in a Query
  • Calculations
  • Action Queries
  • Parameter Queries

Reports:

  • Creating Reports
  • Using the Report Wizard
  • Previewing Reports
  • Creating Reports in Design View
  • Changing Report Design
  • Control Operations
  • Control Attributes

Importing and Exporting Data:

  • Importing and Exporting
  • Importing a Text File
  • Importing Data from an Access Database
  • Exporting Data
  • Troubleshooting Importing and Exporting Problems

Printing:

  • Printing Objects
  • Print Preview

 

Microsoft Access - Level 2 Database Design

Who should attend?        This course is intended for participants who are familiar with Microsoft Access.
Prerequisites:                    Microsoft Access – Level 1 or Equivalent.

Duration:                            6 Hours

Course Objectives
Upon completion of the course, participants will be able to accomplish the following:

  • Understand the databases that will be used during the course.
  • Enhance tables by creating lookups.
  • Create various types of advanced queries.
  • Create advanced forms by adding controls, subforms, calculations, and graphic images.
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts.
  • Work with and create web-based objects.

Course Content

Database Overview:

  • Review

Enhancing Tables:

  • Copying a Database Object
  • Lookup Fields
  • Creating a Lookup

Advanced Queries:

  • Query Overview
  • The Query Wizard
  • Nested Queries
  • Query Joins
  • Make Table Queries
  • Append Queries
  • Summary Queries
  • Crosstab Queries

Advanced Forms:

  • Form Design
  • Controls
  • Form Properties
  • Subforms
  • Advanced Calculations
  • Customizing Forms

Advanced Reports:

  • Designing Reports
  • Sorting and Grouping
  • Layout Properties
  • Calculations
  • Subreports
  • Graphic Reports
  • Chart Wizard

Supplemental Topics:

  • Working with Web Tools
  • Working with Web Pages
  • Hyperlinks