Microsoft Office Access 2007 Beginning Training
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
MCSEClasses.com is your best choice for MS Access,
MS Access training,
MS Access certification,
MS Access certification boot camp,
MS Access boot camp,
MS Access certification training,
MS Access boot camp training,
MS Access boot camp certification,
MS Access certification course,
MS Access course,
training MS Access,
certification MS Access,
boot camp MS Access,
certification MS Access boot camp,
certification MS Access training,
boot camp MS Access training,
certification MS Access course.
|
