Skip to main content

CWD: Courses: Computer Training

Print this page

Introduction to Access 2010

Session Format:

4 Hours Total (One 4–Hour Session)


This course addresses the design and maintenance of a database system. Topics of emphasis are writing of data queries, data redundancy and validation, sorting, reporting, and database programming. The student will design, create and manipulate several databases and also write database programs.


The participant will learn: (1) introductory relational database design concepts, (2) to create database tables and define primary keys, (3) to create forms for entering, displaying and printing data, (4) to design select queries that will enable the user to choose records, sort records, and combine records from multiple tables, (5) to generate reports from the database, (6) to backup the database, and (7) the benefits of the Access wizards and help topics.

Content Outline

  • Clarify the terminology associated with relational databases
  • Explain the steps necessary to design a database
  • Learn how to create and manipulate a table
  • Comprehend referential integrity conditions and explain how to enforce them
  • Clarify the usage of forms

Who Should Attend

This seminar is intended for individuals with little prior database experience but some with the Microsoft Office products.

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 Last Modified 9/24/14