MS Access 2016 – Level 1 (P257) - NEW

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 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
Please follow and like us:


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 for this workshop

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

Details Price Qty
Workshop - November 7-8, 2019show details +$960.50 (CAD)*  
Workshop - March 10-11, 2020show details +$960.50 (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