Microsoft Office Training Materials – Access 2010 Intermediate Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft 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.
Other Microsoft Office Training Materials
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