Access 2010 Intermediate

You have the basic skills needed to work with Microsoft Office Access 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

To ensure the successful completion of the Intermediate course, the completion of the Foundation course or equivalent knowledge is recommended.

1.1: Using My Computer within Access
• Navigating with My Computer
• Performing Basic Tasks with My Computer
• Changing Views with my Computer
• Using the My Places Toolbar
1.2: Database Management
• Compact and Repair a Database
• Backing up Your Database
• Editing Database Properties
1.3: Saving Your Files
• Using the Save As Dialog
• Using the Save As Menu
• Using File Properties
• Using AutoRecover
1.4: Exporting Files
• Exporting to PDF or XPS
• Exporting to Word or Excel
• Exporting to Other Destinations
• Using Saved Exports
• Exporting to a CAB File
• Exporting to Older Versions of Access
1.5: Linking Files
• Linking to an Excel Spreadsheet
• Linking to Another Database
• Linking to a SharePoint Site
• Other Types of Linked Documents
• Creating a Hyperlink

2.1: Customizing Tables
• Understanding Field Properties
• Adding a Primary Key to a Table
• Indexing a Field
• Inserting, Deleting, and Moving Fields
• Adding Quick Start fields
• Importing a Table from another Source
2.2: Formatting Tables
• Formatting Number Fields
• Formatting Text Fields
• Adding Field Descriptions
• Changing Field Data Types
• Adding Captions
2.3: Controlling Table Data Entry
• Setting a Default Value
• Setting a Required Value
• Creating and Using Input Masks
• Creating and Removing Table Relationships
2.4: Managing Table Data Entry
• Using the Table Design Tab
• How to Validate Data
• Creating a Lookup Field
• Modifying a Lookup Field
• Creating a Value List
• Modifying a Value List

3.1: Basic Form Controls
• Adding a Control
• Using the Control Wizard
• Cutting, Copying, Pasting, and Moving a Control
• Formatting a Control
3.2: 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
3.3: Formatting Your Form
• Formatting Gridlines
• Modifying the Font
• Adding Logos
• Changing the Layout
3.4: Formatting Controls
• Changing the Color of a Control
• Using Control Properties
• Aligning Controls
• Applying Special Effects
3.5: Formatting Records
• Modifying Fonts
• Using Themes
• Using the Format Tab
• Using the Arrange Tab

4.1: Organizing Report Data
• Adding and Removing Fields
• Using Report Sections
• Changing Section Properties
• Grouping and Sorting in a Report
• Changing Group Properties
• Using Calculated Controls in a Report
Lesson 4.2: Formatting Reports
• Formatting Gridlines
• Modifying the Font
• Adding Logos
• Changing the Layout
• Using Themes
4.3: Common Report Tasks
• Adding a Photo
• Adjusting Page Properties
• Adding Headers and Footers
• Adding Page Numbers
• Using the Label Wizard
• Adding Conditional Formatting

5.1: Basic Queries
• Review of Queries
• Creating a Query
• Sorting a Query
• Filtering a Query
• Hiding Fields
• Using AND OR Operators
• Use of IIF Functions
5.2: Multiple Table Queries
• Creating a Multiple Table Query
• Creating a Calculated Field
• Using the Expression Builder
• Using Queries to Summarize
5.3: Advanced Queries
• Creating a Parameter Query
• Using Parameter Queries
• Creating Crosstab Queries
• Using Crosstab Queries
• Using Make-Table Queries
5.4: Management (Action) Queries
• Append Queries
• Delete Queries
• Update Queries
• Exporting Queries