Access 2007 Intermediate

Request more details:

Description:
You have the basic skills needed to work with Microsoft Office Access 2007 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.
Prerequisites:
To ensure the successful completion of the Intermediate course, the completion of the Foundation course or equivalent knowledge is recommended.
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
Database Management :
Compact and Repair a Database
Backing up Your Database
Editing Database Properties
Saving Your Files :
Using the Save As Dialogue
Using the Save As Menu
Using File Properties
Using AutoRecover
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
Linking Files :
Linking to an Excel Spreadsheet
Linking to Another Database
Linking to a SharePoint Site
Other Types of Linked Documents
Creating a Hyperlink
Customizing Tables :
Understanding Field Properties
Adding a Primary Key to a Table
Indexing a Field
Inserting, Deleting, and Moving Fields
Importing a Table from another Source
Formatting Tables :
Formatting Number Fields
Formatting Text Fields
Adding Field Descriptions
Changing Field Data Types
Adding Captions
Controlling Table Data Entry :
Setting a Default Value
Setting a Required Value
Creating and Using Input Masks
Creating and Removing Table Relationships
Managing Table Data Entry:
How to Validate Data
Creating a Lookup Field
Modifying a Lookup Field
Creating a Value List
Modifying a Value List
Basic Form Controls :
Adding a Control
Using the Control Wizard
Cutting, Copying, Pasting, and Moving a Control
Formatting a Control
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
Formatting Your Form :
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Formatting Controls :
Changing the Color of a Control
Using Control Properties
Aligning Controls
Applying Special Effects
Formatting Records :
Modifying Fonts
Using AutoFormat
Using the Formatting Ribbon
Using the Arrange Ribbon
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
Formatting Reports :
Formatting Gridlines
Modifying the Font
Adding Logos
Changing the Layout
Using AutoFormat
Common Report Tasks :
Adding a Photo
Adjusting Page Properties
Adding Headers and Footers
Adding Page Numbers
Using the Label Wizard
Basic Queries :
Review of Queries
Creating a Query
Sorting a Query
Filtering a Query
Hiding Fields
Using AND OR Operators
Use of IIF Functions
Multiple Table Queries :
Creating a Multiple Table Query
Creating a Calculated Field
Using the Expression Builder
Using Queries to Summarize
Using Advanced Queries :
Creating a Parameter Query
Using Parameter Queries
Creating Crosstab Queries
Using Crosstab Queries
Using Make-Table Queries
Management Queries :
Append Queries
Delete Queries
Update Queries
Exporting Queries