Microsoft Access – Level 2
Course Outline

DURATION 1 Day
PREREQUISITES Must have attended Access Level 1, or be confident with what tables, queries, forms and reports are, as well as using wizards to create each object.
DESCRIPTION This course takes you deeper into each of the Access objects. You learn about table relationships, queries that perform an action, and look a little more closely at some of the form and report functionalities.
COURSE DATES SPECIAL: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekend Sat, 25-Feb-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 7-Mar-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 26-Mar-12 and Tue, 27-Mar-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 10-Apr-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 28-Apr-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 2-May-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 26-May-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 4-Jun-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 25-Jun-12 and Tue, 26-Jun-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 3-Jul-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 28-Jul-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 2-Aug-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 25-Aug-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 12-Sep-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 24-Sep-12 and Tue, 25-Sep-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 2-Oct-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 27-Oct-12 10:00 - 16:30 £200.00 +VAT
Weekday Fri, 2-Nov-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 26-Nov-12 and Tue, 27-Nov-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 4-Dec-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 26-Dec-12 and Thu, 27-Dec-12 18:30 - 21:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

ADVANCED FILE TASKS

  • Using My Computer within Access

  • Database Management

    • Compact and Repair a Database

    • Backing up Your Database

    • Editing Database Properties

  • Saving Your Files

  • Exporting Files

  • Linking Files

WORKING WITH TABLES

  • 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

      •  

  • 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

    • 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

WORKING WITH FORMS

  • Adding Controls

  • Advanced Form Controls

  • Formatting Your Form

    • Formatting Gridlines

    • Modifying the Font

    • Adding Logos

    • Changing the Layout

  • Formatting Controls

  • Formatting Records

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

    • Adding Conditional Formatting

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 IF Functions

      •  

  • Multiple Table Queries

    • Creating a Multiple Table Query

    • Creating a Calculated Field

    • Using the Expression Builder

    • Using Queries to Summarize

      •  

  • Advanced Queries

    • Creating a Parameter Query

    • Using Parameter Queries

    • Creating Crosstab Queries

    • Using Crosstab Queries

    • Using Make-Table Queries

      •  

  • Management (Action) Queries

    • Append Queries

    • Delete Queries

    • Update Queries

    • Exporting Queries

 

 


Home | Contact | Terms and Conditions