RMD Business Access 2007 Intermediate Syllabus
This course is designed for delegates who have a working knowledge of
Microsoft Access 2007 and covers common tasks required to allow
you to work more efficiently.
If the course syllabus does not entirely match your requirements, please contact us
as we are able to customise it to your needs.
This course has a duration of 1 day.
Advanced File Tasks
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
Working with Tables
Customising 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
Working with Forms
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 Controls Properties
Changing a Controls Data Source
Changing a Controls 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 Colour 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
Working with Reports
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
Working with Queries
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
