MS Access 2016 – Level 1 (P257)

Techniques to Work Effectively with Databases

Courses for the remainder of 2020 will be delivered as live, instructor-led sessions online. CLICK HERE TO REGISTER for the November 17-18 session.

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 workshop in Ottawa.

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


Learning Outcomes

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

CLICK HERE TO REGISTER for the November 17-18 session.


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

Online registration is currently not available for this workshop. You may still register by phone or email


CLICK HERE TO REGISTER for the November 17-18 session.

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

CLICK HERE TO REGISTER for the November 17-18 session.