Microsoft® Office Access 2007 Level 1

Why you should attend: You will learn the basic skills necessary to begin using Access. You will design and create databases, with emphasis on the construction of tables. In addition, you will be introduced to queries, forms, and reports. This course contributes toward the Microsoft Proficiency Guidelines for Access.

Suggested Prerequisites:  Windows 95: Introduction; or Windows 95: Transition or equivalent knowledge; or, Windows 98: Introduction; or Windows 98: Making the Transition, or equivalent knowledge.

Attend and You Will Learn

Lesson 1: An Overview of Access    

• Introduction to database concepts and terminology
• An introduction to Access
• Database planning and design

Lesson 2: Creating Tables    

• Examining a table
• Creating a table with the table wizard
• Creating a table in design view
• Types of primary keys

Lesson 3: Working with Tables    

• Adding records
• Modifying the table design
• Finding and editing records
• Deleting, adding, and copying records and values
• Filtering and sorting records

Lesson 4: Using Select Queries 

• Selecting fields and sorting records
• Refining the results of a query
• Using queries to perform calculations
• Joining tables in a query

Lesson 5: Creating and Using Forms    

• Creating a form with the form wizard
• Modifying the form design
• Using a form to locate and organize information
• Multiple-table forms

Lesson 6: Creating and Using Reports    

• Creating a report 
• Creating a report that contains totals

Lesson 7: Creating and Maintaining a Database    

• Creating a database
• Managing a database and its objects
• Database maintenance