Microsoft Access 2007 – 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	Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Thu, 2-Sep-10 09:30 - 16:30 £200 Evening Wed, 8-Sep-10 and Thu, 9-Sep-10 18:30 - 21:30 £200 Evening Mon, 18-Oct-10 and Tue, 19-Oct-10 18:30 - 21:30 £200 Weekday Tue, 19-Oct-10 09:30 - 16:30 £135 Weekday Fri, 19-Nov-10 09:30 - 16:30 £200 Weekend Sat, 20-Nov-10 10:00 - 16:30 £200 Evening Wed, 15-Dec-10 and Thu, 16-Dec-10 18:30 - 21:30 £200 Weekday Tue, 21-Dec-10 09:30 - 16:30 £200 Weekend Sat, 22-Jan-11 10:00 - 16:30 £200 Weekday Mon, 24-Jan-11 09:30 - 16:30 £200 Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £375 Levels 1-4 Specials: Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 18-Oct-10 - Thu, 21-Oct-10 09:30 - 16:30 £540

ADVANCED FILE TASKS

• Using My Computer within Access

• Database Management

• Saving Your Files

• 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

• 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
  

  • 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

• Basic Form 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

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

   

• 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