Microsoft Access 2010: Specialist 2010

Product Description

Overview

This certification class provides a complete instruction solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Access 2010 accreditation. It concentrates on getting delegates from knowledgeable to ?exam ready? in a 2 day class. The class is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills & practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.
Please note this is the only level of exam available for Microsoft Access 2010. MOS exams are also available for Word, Excel, Power Point & Outlook 2010.
Included Are
?2-days Instructor Led Instruction using MOS Official Classware
?MOS Practice Exam Voucher
?MOS Exam Voucher
? Free Exam Re-take (where required)
Class Outline
During the 2 day class you will cover the following topics to prepare you for exam 77-885: Using Microsoft Office Access 2010. During the class, you will have the opportunity to test your knowledge & complete a full practice exam before taking the final exam at the end of day two.
Managing the Access Environment
Create & manage a database
? Using Save Object As, Open, Save & Publish, Compact & Repair Database, & Encrypt with Password commands, creating a database from a template, & setting Access options
Configure the Navigation Pane
? Renaming objects, deleting objects, & setting Navigation options
Apply Application Parts
? Using Blank Forms, Quick Start, & user templates
Building Tables
Create tables
? Creating tables in Design View
Create & modify fields
? Inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, & modifying field properties
Sort & filter records
? Using Find, Sort, & Filter commands
Set relationships
? Defining Primary Keys, using Primary Keys to create Relationships, & editing Relationships
Import data from a single data file
? Importing source data into a new table, appending records to an existing table, & importing data as a linked table
Building Forms
Create forms
? Using the Form Wizard, creating a Blank Form, using Form Design Tools, & creating Navigation forms
Apply Form Design Tab options
? Using the Themes, Controls, Header/ Footer, & Tools groups
Apply Form Arrange Tab options
? Using the Table, Move, & Position groups
Apply Form Format Tab options
? Using the Background & Control Formatting groups
Creating & Managing Queries
Construct queries
? Using Select, Make Table, Append, & Crosstab query types
Manage source tables & relationships
? Using the Show Table & Remove Table commands, & creating ad hoc relationships
Manipulate fields
? Adding, removing, & rearranging fields, & using Sort & Show options
Calculate totals
? Using the Total row & using Group By
Generate calculated fields
? Performing calculations, using the Zoom box, & using Expression Builder
Designing Reports
Create reports
? Creating a Blank Report, using Report Design Tools, & using the Report Wizard
Apply Report Design Tab options
? Using the Themes, Grouping & Totals, Controls, Header/ Footer, & Tools groups
Apply Report Arrange Tab options
? Using the Table, Move, Position, & Sizing & Ordering groups
Apply Report Format Tab options
? Adding colour, background images, & conditional formatting
Apply Report Page Setup Tab options
? Using the Page Size & Page Layout groups
Sort & filter records for reporting
? Using the Find, Sort, & Filter commands, & using view types