Access 2007: Introduction

Learning Outcomes:

• Define database concepts with 90% accuracy.
• Successfully create and edit tables using data in the Lesson Lab.
• Analyze the data to be stored and apply that analysis to create an effective table design as directed by the instructor.
• Design and customize forms to apply to specific applications using the material in the exercises.
• Choose an appropriate data validation method and implement it to the instructors’ satisfaction.

Students will design and create and modify new databases and their various objects. This one day course contributes toward the Microsoft Proficiency Guidelines for Access.

• Exploring the Access Environment
• Designing a Database
• Building a Database
• Managing Data in a Table
• Designing Forms
• Generating Reports

Access 2007: Introduction

Learn Microsoft's database management system and concepts. Explore the user interface, customize the Access environment and use an existing database. Learn the relational database design process, define database purpose, review existing data, determine fields and group fields into tables. Normalize data, designate primary and foreign keys and determine table relationships. Create a new database, create and manage tables, then create a table relationship. Modify table data, sort records and work with subdatasheets. Filter records, create a query, add criteria to a query, add a calculated field to a query and perform calculations on a record grouping. View data using an access form. Create and modify the design of a form. Create an Access report and add a custom calculated field to a report. Format the controls and apply an AutoFormat to a report.

Class targeted to: Students enrolling in this course should understand the basic concepts involved in working with a personal computer. Students should also be somewhat familiar with databases and how they are utilized.

Prerequisites: Students should be comfortable working in the Windows environment.