Dreamweaver course in north London

Microsoft Access: Intermediate (Level 2)

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 reports.

Existing users of Microsoft Access 2003 who want to get grips with some of the more advanced features of this package as quickly as possible.

Delegates on this course should have a good working knowledge of the topics covered in the Introduction course.

Course outline

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 
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 
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
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 
Organising 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   
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 

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

We recommend the following courses that relate to this class: Microsoft Access Advanced and Microsoft Excel Introduction

Course Duration 1 Day
Scheduled Course Price £99 +VAT
Private Course Price This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates
Course Times 10:00 till 16:00