MS Access 2016 – Level 1 – 2 Day Online Workshop (PV257)

Techniques to Work Effectively with Databases

All our courses from September to December 2020 will be delivered as live, instructor-led sessions online. To register online please scroll down to the Register Online section.

We recommend having the software MS Access 2016 installed on your computer in order to attend the online session. However, if you are willing to attend the session as a training demo type of seminar, you are welcome to do so as well.

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 is a two-day virtual live workshop.

Space is still available for all course dates listed, unless otherwise noted.


Learning Outcomes

By the end of this virtual 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


Print Friendly

Workshop 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

Register Online

To begin please select your organization's billing address province from the drop down list. (Note: If you are not with an organization, or you are registering personally, please select your own mailing address province.) If you are from out of Canada, please select ‘Out of Canada’ in the drop down.

Once you register the first attendee, you’ll have the ability to add additional attendees or purchase other workshops.

Details Price Qty
Online Workshop - November 17-18, 2020 [TXON]show details +$960.50 (CAD)*  
Online Workshop - November 17-18, 2020 [TXQC]show details +$977.25 (CAD)  
Online Workshop - November 17-18, 2020 [TX5%]show details +$892.50 (CAD)  
Online Workshop - November 17-18, 2020 [TX15%]show details +$977.50 (CAD)  
Online Workshop - November 17-18, 2020 [TX-NoTax]show details +$850.00 (CAD)  

* price includes taxes



Online event registration and ticketing powered by Event Espresso


Who Should Attend This Course?

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.


Does This Course Address Your Competency Development Needs?

This training workshop addresses:

• Achievement / Results Orientation
• Computer and Digital Technology
• Document Use
• Planning / Organizing
• Working with Data and Numbers