Access 2007 Basics

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing this data is by using relational databases. Access is one of the most popular relational databases.

In this class you'll learn the basic skills you need to get started using Access databases and managing the data they contain. You'll also discover the advantages and benefits of using a relational database application.

On completion of this class you'll be able to:

• Understand basic database concepts and terminology and navigate the new Access 2007 interface
• Build a new database with related tables
• Create, edit and delete data in your tables
• Create queries to extract exactly the information you need using different methods
• Design useable forms for data entry and/or inquiry
• Generate reports for printing or on-screen display

Prerequisites: Familiarity with basic concepts of working with the PC, good working knowledge of the Windows operating system. Prior knowledge of databases is not necessary.