Microsoft Office Training Materials – Access 2010 Intermediate Training Manuals

Microsoft Access 2010 Intermediate Training Materials

Courseware Training Materials

Training Course Outline

 Access 2010 Queries

•     Creating a Query
•     Adding Criteria to a Query
•     Running a Query
•     Editing Criteria In a Query
•     Saving a Query
•     Creating a Two Table Query and Sorting the results
•     Refining a Query
•     Wildcards
•     Deleting a Query
•     Hiding and Un-Hiding Query Fields

 Access 2010 Reports

•     Creating a Report
•     Using the Report Wizard
•     Modifying the Layout of a Report
•     Widening a Report Column
•     Modifying the Report Title
•     Adding a Logo to a Report
•     Formatting a Form using Themes
•     Modifying Field Names within a Report
•     Inserting and Formatting the Date & Time
•     Adding Existing Fields to a Report
•     Resizing Reports For Printing
•     Totals
•     Closing a Report
•     Deleting a Report

Exporting

•     Exporting a Table As an Excel File
•     Exporting a Table As a Text File
•     Exporting a Table As a Text CSV File
•     Exporting a Table As a PDF File
•     Exporting a Table As an XML File

Printing from  Access 2010

•     Print Previewing
•     Portrait and Landscape
•     Adjusting Layout In Print Preview
•     Margins
•     Printing a Complete Table
•     Printing Selected Records
•     Printing a Query or Reports
•     Printing Forms

Reference: the Access 2010 Interface

•     Opening a Database
•     Opening a Table
•     The Ribbon (Toolbar)
•     Ribbon Tabs
•     Groups
•     Dialog Box Launcher
•     Navigating
•     Contextual Tabs
•     Minimising the Ribbon
•     The File Tab
•     Microsoft Access Help
•     Closing Access 2010

Database Terminology & Theory

•     Database
•     Table
•     Record
•     Field
•     Field Data Types
•     Field Properties
•     Primary Key
•     Types of Database

Trusted Locations

•     Setting a trusted location

 Access 2010 Fields

•     Creating a Lookup within a Field.
•     Modifying a Lookup within a Field.
•     Deleting a Lookup within a Field.
•     Creating an Input Mask.
•     Modifying an Input Mask.
•     Deleting an Input Mask.
•     Modifying a Field to Require Data Entry.
•     Modifying a Field So That It Does Not Require Data Entry.

Relationships

•     Creating and modifying a One-To-One Relationship.
•     Creating and modifying a One-To-Many Relationship.
•     Creating and modifying a Many-To-Many Relationship using a Junction Table.
•     Enforcing Referential Integrity.
•     Automatic Updating of Related Fields.
•     Automatic Deletion of Related Records.

Joins

•     Inner Join.
•     Outer Join.
•     Subtract Join.
•     Self Join.