Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4

Designed for new Access users who require the skills necessary to set up & use a relational database. Learn the theory involved in designing the relationships between tables; how to create &customize forms & reports from the tables, how to use filters...

Course Outline
This course is designed for new Access users who require the skills necessary to set up and use a relational database. Students will learn the theory involved in designing the relationships between tables. This course will also show students how to create and customize forms and reports from the tables, as well as introduce how to use filters and create select queries.

Course Content The Basics
  • Database Concepts
  • Getting Started
  • Creating a Database
  • Converting Access Files
  • Working with Objects
Table Data
  • Table Concepts
  • Viewing Data in a Table
  • Changing the Datasheet Appearance
  • Entering and Editing Data
  • Applying Filters
Table Design
  • The Table Wizard
  • Changing the Table Design
  • Creating a Table in Design View
Data Entry
  • Data Entry Concepts
  • Data Formats
  • Input Masks
  • Input Validation
  • Adding Records
  • 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

Prerequisites & Certificates

Good understanding of Windows and Microsoft software.

Certificates offered

Certificate of completion

Cancellation Policy
10 business days cancellation or full course fee will be charged
Map & Reviews
Technology Training Centre
[ View Provider's Profile ]

Sue is an awesome instructor!
Reviewed by 2011

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 1343 times.