Microsoft Access 2003 Intermediate

This intensive training course will help delegates to build on their basic understanding of Access 2003, in order to produce more comprehensive and robust database applications. Students will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and...

Who Should Attend?

Existing users of Microsoft Access 2003 or XP who want to get grips with some of the more advanced features of this package as quickly as possible. Note : delegates should have some experience with creating a basic database in Access (including table design and specifying field data types and properties) and be proficient in all topics covered in the Introduction course.

Database Design Basics

Database Normalisation: • The Rules of Normalization Relating Tables: • One-to-One Relationships • One-to-Many Relationships • Many-to-Many Relationships Referential Integrity: • Planning Relationships Between Tables • Orphan Records • Cascading Deletes • Cascading Updates

Advanced File Tasks

Using My Computer within Access: • Navigating with My Computer • Performing Basic Tasks with My Computer • Changing Views with My Computer • The My Places Toolbar

Database Management: • Repairing a Database • Compacting a Database • Backing up Your Database • Editing Database Properties
Saving Your Files: • Save As Dialogue • Object Properties • AutoRecover
Exporting Files: • Exporting to Word • Exporting to Excel • Exporting to Older Versions of Access • Exporting vs. Save As
Linking Files: • Linking to an Excel Spreadsheet • Linking to Another Database • Creating a Hyperlink • Inserting an OLE Object
Working with Tables

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
Working with Forms

Basic Form Controls: • Adding a Control • 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 a Form: • Formatting Gridlines • Modifying the Font • Adding Images • Using AutoFormat
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 • Adjusting the Layout of your Report • Using AutoFormat
Common Report Tasks: • Adding a Photo • Adjusting Page Properties • Adding Headers and Footers • Adding Page Numbers • The Label Wizard
Working with Queries

Basic Queries: • Review of Queries • Creating a Query • Sorting a Query • Filtering a Query • Hiding Fields • AND/OR Operators • IIF Functions

Multiple Table Queries: • Creating a Multiple Table Query • Creating a Calculated Field • The Expression Builder • Using Queries to Summarize • Make-Table Queries Management (Action) Queries: • Append Queries • Delete Queries • Update Queries • Exporting Queries