|
Course Name |
Access 2007 Level 2 |
Contact Hours: 24 |
|
Course Description |
Strives to broaden and develop the basic database design skills that students already possess. Students will gain a more complete understanding of how to create and use the primary database objects in Microsoft Office Access 2007, including tables, queries, forms, and reports. The course also shows how to work with individual fields to ensure that overall database structure is consistent and correct. In addition, students will learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone. Finally, students will be introduced to a few methods of managing and backing up database files. |
|
Outcome |
This course will teach students how to: - broaden and develop the basic database design skills
- gain a more complete understanding of how to create and use the primary database objects
- how to work with individual fields to ensure that overall database structure is consistent and correct
- learn a variety of techniques designed to make data entry in Access databases faster, easier, and less error-prone
- how to manage and back up database files
|
|
Assessment |
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.
|
|
Outline |
This course consists of 58 lessons - Move And Delete Fields
- Modify Multiple Data Types
- Create And Use Hyperlinks In Tables
- Attach A File To A Record
- Remove A Record Attachment
- Understand The Lookup Wizard
- Create And Use Lookup Lists
- Generate And Use Value Lists
- Understand Input Masks
- Apply And Use Input Masks
- Understand Field Properties
- Add Captions To Fields
- Add Default Values
- Propagate Field Properties
- Specify Field Size And Format
- Understand Indexes
- Index Fields
- Examine Importing And Exporting
- Import Data To Existing Tables
- Export Data From Access To Other Applications
- Learn About XML
- Import XML Files To New Tables
- Export Database Data To XML Files
- Understand E-mail Data Collection
- Create A Data Collection E-mail
- Respond To A Data Collection E-mail
- Manage Data Collection E-mails
- Create Multi-table Queries
- Examine Operators And Expressions
- Specify Criteria
- Create Crosstab Queries
- Display Queries In PivotChart View
- Look At The Expression Builder
- Add Calculated Fields Using The Expression Builder
- Format Calculated Fields
- Understand Aggregate Functions
- Use Aggregate Functions In Queries
- Understand Form Sections
- Add Headers And Footers To Forms
- Understand Controls
- Add Bound Controls To Forms
- Use Layout View
- Create Calculated Controls
- Add Option Groups Using A Wizard
- Define Tab Order
- Change Form Properties
- Understand Report Sections
- Create Reports In Design View
- Add Calculated Controls To Reports
- Add Controls To Headers And Footers
- Format Controls In Reports
- Look At Reports In Layout View
- Align, Resize, And Space Controls
- View Object Dependencies
- Use The Database Documenter
- Print Database Objects
- Compact And Repair Databases
- Back Up Database Files
|
|
|
|