MS Access 2016 – Level 1

Techniques to Work Effectively with Databases

This two-day course will help you understand how to identify and work with database components; open tables to locate, edit and enter data; create and customize tables; use input masks and data validation techniques; create table relationships ensuring data integrity; create and customize table forms; work with queries to extract, edit and perform calculations with table data; create and customize reports; import and export data into tables and preview and print data objects.

This workshop is offered within organizations for groups of 5 people or more.

Course duration: 2 days

Program Topics

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 Database 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

Learning Outcomes
By the end of this workshop, you will be able to:

• Work with Tables, Forms, Queries and Reports
• Enter, edit and filter table data
• Create and set custom options for inputting table data
• Relate tables to one another using referential integrity
• Create and customize forms
• Work with different types of queries
• Create and print reports
• Import and export data to Excel and other formats

Who Should Attend?

This workshop is intended for anyone who has a good working knowledge of Microsoft Office products and is seeking to understand how to work with databases.

For more information on this workshop, please contact:
Sophie Gouédard
Tel: 613-234-2020, ext. 21
Email: sgouedard@pmctraining.com

Comments are closed