Benchmark Series: Microsoft Access 2010 Levels 1 and 2

With Paradigm's new Benchmark Series: Microsoft Access 2010 Levels 1 and 2, students build mastery skills in the Access 2010 application. Its project-based approach creates a realistic context for learning practical skills.

• Teaches key skills for using Windows 7 and Internet Explorer 8.
• Mentoring instructional style guides students step-by-step in planning, creating, and managing databases to report and analyze information.
• Case study assessments at chapter and unit levels test students' abilities to solve problems independently.
• This text aligns to the Microsoft Office Specialist objectives.

Getting Started.
Using Windows 7. Browsing the Internet Using Internet Explorer 8.0.

Level 1 Unit 1.
Creating Tables and Queries.
1. Creating Database Tables.
2. Creating Relationships between Tables.
3. Performing Queries.
4. Creating and Modifying Tables in Design View.
Level 1 Unit 1 Performance Assessment.
Unit 2. Creating Forms and Reports.
5. Creating Forms.
6. Creating Reports and Mailing Labels.
7. Modifying, Filtering, and Viewing Data.
8. Importing and Exporting Data.
Level 1 Unit 2 Performance Assessment.
Access Level 1 Index.

Level 2 Unit 1.
Advanced Tables, Relationships, Queries, and Forms.
1. Designing the Structure of Tables.
2. Designing and Building Relationships and Lookup Fields.
3. Advanced Query Techniques.
4. Creating and Using Custom Forms. Level 2 Unit 1 Performance Assessment.
Unit 2. Advanced Reports, Access Tools, and Customizing Access.
5. Creating and Using Custom Reports.
6. Using Access Tools and Managing Objects.
7. Automating, Customizing, and Securing Access.
8. Integrating Access Data. Level 2 Unit 2 Performance Assessment. Access Level 2 Index.

Nita Rutkosky has been an office technology instructor at Pierce College at Puyallup (Puyallup, WA) since 1978. She has taught a variety of courses including all levels of keyboarding, machine transcription, records management, business machines, word processing, and desktop publishing. In addition to this textbook, Ms. Rutkosky has authored and co-authored many computer application textbooks for Paradigm Publishing, Inc.

Audrey Rutkosky Roggenkamp has been teaching courses in the Business Information Technology department at Pierce College in Puyallup, including keyboarding, skill building, and Microsoft Office programs. In addition to this textbook, Ms. Roggenkamp has authored and co-authored many computer application textbooks for Paradigm Publishing, Inc.