Overview
Microsoft Office Specialist (MOS) Access 2010 teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data. Students will use the Expression Builder to create expressions and insert identifiers as property settings, use advanced form controls to locate information and restrict data entry, and will set form properties that respond to events.
Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for MOS Access 2010 Exam #77-885.
Prerequisites
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.
- start and run Windows
- use the taskbar
- use the Start button
- use the Help feature
- use Minimize, Restore Down/Maximize, or Close
- use the left and right mouse buttons appropriately
- understand file management techniques
- navigate between files, folders, or drives
Course Outline
- An Introduction to Databases
- What is Access?
- Database Objects
- Components of the Access 2010 User Interface
- Looking at the Screen
- The Access Startup Screen
- Managing Database Files
- Using the Navigation Pane
- Setting Access Options
- Lesson Summary
- Review Questions
- Table Basics
- Data Types
- Creating Tables in Design View
- Modifying Tables in Design View
- Primary Keys
- Creating Tables in Datasheet View
- Reusing Design Elements
- Entering Records in Datasheet View
- Importing Data
- Working with Records
- Table Relationships
- Viewing Related Data
- Lesson Summary
- Review Questions
- Retrieving Data
- Finding Records
- Sorting Records
- Filtering Records
- Creating Queries
- Modifying Queries
- Adding Query Criteria
- Working with Joined Tables
- Performing Calculations in Queries
- Creating Action Queries
- Creating Crosstab Queries
- Lesson Summary
- Review Questions
- Why Use Forms?
- Form Types
- Form Views
- Creating Forms Using Automated Form Tools
- Subforms
- Using the Form Wizard
- Creating Forms from Scratch
- Modifying Forms
- Adding Controls from the Ribbon
- Applying Formatting and Design Options
- Navigation Forms
- Lesson Summary
- Review Questions
- What is a Report?
- Report Views
- Creating Reports
- Creating a Report Using the Report Wizard
- Creating a Blank Report
- Working with Reports in Layout View
- Working with Reports in Design View
- Adding Finishing Touches to Reports
- Sorting and Filtering Records for Reporting
- Previewing and Printing Reports
- Lesson Summary
- Review Questions
