Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Access 2007 Level 1 Database Design

GK# 8654

Course Overview

In this two-day instructor-led course, you will be introduced to the basics of Microsoft Access 2007. You will learn to identify and work with the components of a database, including table design and customization, and entering data. You will also create several types of queries, edit and run queries, and use action and calculation queries. Finally, you will create several types of reports, enhance them, and print preview reports.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $590 CAD

    2 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Identify the components of a database and work with those components
  • Open a table, find information stored there, and enter data
  • Create and customize a table design
  • Enter data into tables and ensure its accuracy by using input masks and input validation formulas
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity
  • Create forms for entering data into tables and change the design elements that have been placed on those forms
  • Create several query types, edit and run queries, and use action and calculation queries
  • Create several report types, enhance reports, and print preview reports
  • Import and export data to and from various sources, including text files and Excel
  • Preview and print database objects and change the page setup options

Follow-On Courses

Who Needs To Attend

Those who are new to Microsoft Access 2007