Access 2007 - Level 1

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• design a simple database.
• build a new database with related tables.
• manage the data in a table.
• query a database using different methods.
• design forms
• generate reports.

Course Content

Lesson 1: Exploring the Access Environment

• Examine Database Concepts
• Customize the Access Environment
• Use an Existing Access Database

Lesson 2: Designing a Database

• Describe the Relational Database Design Process
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize Data
• Designate Primary and Foreign Keys
• Determine Table Relationships

Lesson 3: Building a Database

• Create a New Database
• Create and Manage a Table
• Create a Table Relationship

Lesson 4: Managing Data in a Table

• Modify Table Data
• Sort Records
• Work with Subdatasheets

Lesson 5: Querying a Database

• Filter Records
• Create a Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

• View Data Using an Access Form
• Create a Form and Using the Form Wizard
• Modify the Design of a Form

Lesson 7: Generating Reports

• Create a Report Using the Report Wizard
• Add a Custom Calculated Field to a Report
• Format the Controls in a Report
• Apply an AutoFormat to a Report
• Prepare a Report for Print

Online boot camps and courses are offered in: computer training online, online computer training, computer online training, computer class online, computer online class, online computer class, computer course online, online computer course, live computer training, computer training live, live computer class, live computer course, instructor led online training, instructor led training online, mcse online, mcse online training, mcse training online, mcse training, mcse certification, mcse boot camp, mcse boot camp online, mcse certification online, mcsa online, mcsa online training, mcsa training online, mcsa training, mcsa certification, mcsa boot camp, mcsa boot camp online, mcsa certification online, mcad online, mcad online training, mcad training online, mcsd online, mcsd training online, mcsd online training, mcsd training, mcsd certification, mcsd boot camp, mcsd boot camp online, mcsd certification online, .net online, .net training online, .net online training, .net training, .net certification, .net boot camp, .net boot camp online, .net certification online, cisco online, cisco online training, cisco training online, cisco training, cisco certification, cisco boot camp, cisco boot camp online, cisco certification online, ccna online, ccna online training, ccna training online, oracle online, oracle online training, oracle training online, word training, word training online, word online training, excel training, excel training online, excel online training, access training, access training online, access online training, powerpoint training, powerpoint training online, powerpoint online training, microsoft office specialist training, microsoft office specialist training online, microsoft office specialist online training, mos training, mos training online, mos online training, exchange training, exchange training online, exchange online training, project training, project online training, project training online, peachtree training, peachtree online training, peachtree training online, crystal reports training, crystal reports training online, crystal reports online training,