Office 2010 Training Manuals – Microsoft Access 2010 Intermediate Courseware
Office 365 training materials from the Cheltenham Group Free SamplesMicrosoft Access 2010 Intermediate Training Course Teaching Materials
Computer Courseware Training Materials
Training Course Outline
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
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
- 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
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.
- Word 2010 Foundation
- Word 2010 Intermediate
- Word 2010 Advanced
- Excel 2010 Foundation
- Excel 2010 Intermediate
- Excel 2010 Advanced
- Access 2010 Foundation
- Access 2010 Intermediate
- Access 2010 Advanced
- Outlook 2010 Foundation
- PowerPoint 2010 Foundation
- PowerPoint 2010 Intermediate
- PowerPoint 2010 Advanced
- Project 2010 Foundation
- Windows 10 Foundation