Microsoft Access 2010 Courseware and Training Materials

What's included?
What’s included?
Available for delivery as a download from our web server or provided on CD, this courseware package includes the following resources to make your trainer’s life much, much easier.

This courseware package includes:

	Student Manual. Fully customisable. May be opened in any wordprocessor and changed to meet your exact needs.
	Student workbook. Fully customisable. Additional book includes series of practical tasks and review questions.
	Student workbook exercises. Fully customisable. Sample exercises to accompany the student workbook.
	Trainer manual. Fully customisable with additional information for trainers.
	Timetable and lesson plans. Fully customisable. Detailed timetable and plans ensure you deliver the best possible course.
	PowerPoint presentations. Fully customisable. Complete set of PowerPoint slides for use by the trainer.

To get started, just open this ‘Microsoft Access 2010′ training courseware in your favourite word processor. You can fully customise the materials to suit your exact learning needs and include your own branding. Your own tailor-made course, delivered ‘off-the-peg’ and saving you thousands of pounds in development time and man-hours. Just press print and the perfect learning experience is yours to deliver.

Course outline
Course outline

Course contents: Foundation Level

• Starting Out — What is Microsoft Access? — What’s New in Access 2010? — Basic Database Terminology — Opening and Closing Access — Step-By-Step — Skill Sharpener
• Interface Basics — Understanding Backstage View (File Menu) — Interface Overview — Using the Standard Tabs — Using Contextual Tabs — Step-By-Step — Skill Sharpener
• Database Security — Warnings You May See when Opening a Database — Enabling Content — About Digital Signatures — About Trusted Locations — Opening the Trust Center — Assigning a Password to your Database — Step-By-Step — Skill Sharpener
• Getting Help — Opening the Help File — Overview of the Help File — Online vs. Offline Help — Searching for Help — Step-By-Step — Skill Sharpener
• The Quick Access Toolbar — The Default QAT Commands — Adding Commands — Removing Commands — Customizing the Toolbar — Step-By-Step — Skill Sharpener
• Basics of Tabs — About Tabs — Opening Additional Dialog Boxes — Using the File (Backstage) Menu — Minimizing the Ribbon — Step-By-Step — Skill Sharpener
• The Home Tab — Views Commands — Clipboard Commands — Sort & Filter Commands — Records Commands — Find Commands — Text Formatting Commands — Step-By-Step — Skill Sharpener
• The Create Tab — Templates Commands — Tables Commands — Queries Commands — Forms Commands — Reports Commands — Macros & Code Commands — Step-By-Step — Skill Sharpener
• The External Data Tab — Import & Link Commands — Export Commands — Collect Data Commands — Step-By-Step — Skill Sharpener
• The Database Tools Tab — Tools Commands — Macro Commands — Relationships Commands — Analyze Commands — Move Data Commands — Add-Ins Commands — Step-By-Step — Skill Sharpener
• First Steps — Planning a Database — Creating a Blank Database — Creating a Database from a Template — Using Database Objects — Setting Navigation Options — Step-By-Step — Skill Sharpener
• About Records — What is a Record? — Navigation Tips — Adding Records — Editing Records — Deleting Records — Printing Records — Step-By-Step — Skill Sharpener
• Creating a Table — About Tables — Creating a Table — Using Design View — Entering Data into a Table — Formatting a Table — Step-By-Step — Skill Sharpener
• Formatting Text — Using the Zoom Box — Selecting Data — Cutting, Copying, and Pasting — Using the Format Painter — Using Undo and Redo — Checking your Spelling — Step-By-Step — Skill Sharpener
• Creating and Using Forms — What is a Form? — Bound vs. Unbound Controls — Creating a Basic Form — Creating a Form with the Wizard — Using Design View to Modify your Form — About the Form Design Tools Contextual Tabs — Using Forms — Step-By-Step — Skill Sharpener
• Creating and Using Queries — What is a Query? — Creating a Query with the Wizard — Using Design View to Modify a Query — About the Query Design Tools Contextual Tab — Using Queries — Step-By-Step — Skill Sharpener
• Creating and Using Reports — What is a Report? — Creating a Report with the Wizard — Using Design View to Modify a Report — About the Report Design Tools Contextual Tabs — Using Reports — Step-By-Step — Skill Sharpener
• Sorting and Filtering Data — Using Find and Replace — Sorting Ascending or Descending — Toggling Filter — Using Selection Sort — Using Advanced Sort — Step-By-Step — Skill Sharpener
• Viewing Data — Using the View Menu — Using the View Icons — Using the Object Tabs — Closing Individual Object Tabs — Step-By-Step — Skill Sharpener
• Printing a Database Object — Print Commands — The Print Dialog Box — Using Print Preview — Printing vs. Exporting — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

Course contents: Intermediate Level

• Using Windows Explorer within Access — Navigating with Windows Explorer — Performing Basic Tasks with Windows Explorer — Changing Views in Windows Explorer — Using the Navigation Pane — Step-By-Step — Skill Sharpener
• Database Management — Compact and Repair a Database — Backing Up your Database — Editing Database Properties — Adding or Removing Database Passwords — Step-By-Step — Skill Sharpener
• Saving Your Files — Using the Save As Dialog — An Overview of Additional Database Formats — Packaging a Database — About AutoRecover — Step-By-Step — Skill Sharpener
• Exporting Files — Exporting to PDF or XPS — Exporting to Microsoft Office Excel — Exporting to Other Destinations — Using Saved Exports — Packaging and Signing — Exporting to Older Versions of Access — Step-By-Step — Skill Sharpener
• Linking Files — Linking to a Microsoft Excel Spreadsheet — Linking to Another Database — Linking to a SharePoint Site — Other Types of Linked Documents — Creating Hyperlinks — Step-By-Step — Skill Sharpener
• Customizing Tables — Understanding Field Properties — Adding a Primary Key — Indexing a Field — Inserting, Deleting, and Moving Fields — Adding Quick Start Elements — Importing a Table from another Source — Step-By-Step — Skill Sharpener
• Formatting Tables — Formatting Number Fields — Formatting Text Fields — Adding Field Descriptions — Changing Field Data Types — Adding Captions — Step-By-Ste — p — Skill Sharpener
• Controlling Table Data Entry — Setting a Default Value — Setting a Required Value — Creating and Using Input Masks — Creating and Removing Table Relationships — Step-By-Step — Skill Sharpener
• Managing Table Data Entry — Using the Table Tools – Design Tab — Validating Data — Creating a Lookup Field — Modifying a Lookup Field — Creating a Value List — Modifying a Value List — Step-By-Step — Skill Sharpener
• Basic Form Controls — Types of Forms — Types of Form Controls — Adding a Control — Using the Control Wizard — Cutting, Copying, Pasting, and Moving a Control — Formatting a Control — Step-By-Step — Skill Sharpener
• Advanced Form Controls — Modifying a Control’s Properties — Changing a Control’s Data Source — Changing a Control’s Default Value — Creating a Calculated Control — Using Form Properties — Step-By-Step — Skill Sharpener
• Formatting Your Form — Formatting Gridlines — Modifying the Font — Adding Logos — Changing the Layout — Step-By-Step — Skill Sharpener
• Formatting Controls — Changing the Color of a Control — Using Control Properties — Aligning and Sizing Controls — Applying Special Effects — Step-By-Step — Skill Sharpener
• Using Themes — Using Themes — Modifying Fonts — Modifying Colors — Saving Customized Themes — Step-By-Step — Skill Sharpener
• Organizing Report Data — Adding and Removing Fields — Using Report Sections — Changing Section Properties — Grouping and Sorting in a Report — Doing More with Grouping and Sorting — Using Calculated Controls in a Report — Step-By-Step — Skill Sharpener
• Formatting Reports — Formatting Gridlines — Modifying the Font — Adding Logos — Changing the Layout — Using Themes — Step-By-Step — Skill Sharpener
• Common Report Tasks — Adding a Photo — Adjusting Page Properties — Adding Page Numbers — Using the Label Wizard — Adding Conditional Formatting — Step-By-Step — Skill Sharpener
• Basic Queries — Review of Queries — Creating a Query — Sorting a Query — Filtering a Query — Hiding Fields — Step-By-Step — Skill Sharpener
• Doing More with Queries — Using AND/OR Operators — About IIF Functions — Creating Multiple Table Queries — Creating a Calculated Field — About the Expression Builder — Using Queries to Summarize Data — Step-By-Step — Skill Sharpener
• Advanced Queries — Creating a Parameter Query — Using Parameter Queries — Creating Crosstab Queries — Using Crosstab Queries — Using Make-Table Queries — Step-By-Step — Skill Sharpener
• Management (Action) Queries — Append Queries — Delete Queries — Update Queries — Exporting Queries — Step-By-Step — Skill Sharpener
• Case Study
• Review Questions

Course contents: Advanced Level

• Referential Integrity — Using the Relationships View and Tab — Types of Relationships — Establishing Referential Integrity — Enforcing Referential Integrity — Testing Referential Integrity — Step-By-Step — Skill Sharpener
• Table Relationships — About Join Lines — Normalizing Tables — Using Cascade Delete and Cascade Update — Setting Fields for Indexing — Using the Index — Step-By-Step — Skill Sharpener
• An Introduction to SQL — What is SQL? — Parts of an SQL Statement — SQL Keywords — Adding Where Clauses — Step-By-Step — Skill Sharpener
• Modal Dialog Boxes — Creating a Modal Dialog Box — Adding Controls — Setting Properties — Formatting your Dialog Box — Step-By-Step — Skill Sharpener
• Using Subforms — Creating a Subform — Modifying a Subform — Working with a Subform — Synchronizing Subform Data with a Main Form — Displaying a Subform within a Main Form — Step-By-Step — Skill Sharpener
• Advanced Form Tasks — Limiting User Access to a Form — Creating Check Boxes and Command Buttons — Creating Event Procedures — Customizing Error Messages — Step-By-Step — Skill Sharpener
• Exporting Your Form — Sending a Form via E-Mail — Managing Replies — Exporting your Form to XML — Step-By-Step — Skill Sharpener
• Switchboards — Using a Switchboard vs. Using the Navigation Pane and Tab — Using the Switchboard Manager — Creating a Switchboard — Editing a Switchboard — Deleting a Switchboard — Step-By-Step — Skill Sharpener
• Creating a PivotTable — About PivotTables — Creating a PivotTable — More about PivotTable Fields — Completing your PivotTable — Step-By-Step — Skill Sharpener
• Creating a PivotChart — About PivotCharts — Creating a PivotChart — More about PivotChart Fields — Completing Your PivotChart — Step-By-Step — Skill Sharpener
• Using PivotTables and PivotCharts — Using a PivotTable — Using a PivotChart — Editing a PivotTable or a PivotChart — Common PivotTable and PivotChart Editing Commands — Creating a PivotTable and PivotChart from the Same Object — Step-By-Step — Skill Sharpener
• Access and Windows — Recovering Access — Starting Access on Windows Boot — Using Office Diagnostics — Checking for Updates — Step-By-Step — Skill Sharpener
• Using the Access Viewer — What is the Access Viewer? — Downloading the Viewer — Using the Viewer — Step-By-Step — Skill Sharpener
• Using Outlook with Access — Creating an RSS Feed for Outlook — Importing Contacts from Outlook — Step-By-Step — Skill Sharpener
• Using SharePoint 2010 with Access — Important Terminology* — Linking Tables and Lists — Publishing a Database in SharePoint — SharePoint Database Management Tasks — Step-By-Step — Skill Sharpener
• Using Macros and VBA
• Case Study
• Review Questions