WWP key in developing people
About WWP
Professional Development
Project Management
Apprenticeships
Customer Portal
Duration: 2 day(s)
Course Code: AC07FO
Add to Favourites
Dates
London Centre 9th Jul 2012 book
Windsor Centre 16th Jul 2012 book
London Centre 10th Sep 2012 book
London Centre 5th Nov 2012 book
Windsor Centre 5th Nov 2012 book
Dedicated Course Request
Price:
£480.00+VAT
print this page
email this page

Microsoft Access 2007 Foundation

Aims

This course is aimed at people who want to learn how to build a Microsoft Access database or to gain essential understanding of the construction and use of an existing database.

Prerequisites

Students who wish to attend this course need to be familiar with the use of a PC, keyboard and mouse. No previous experience of Access is required.

Objectives

On completion of this course delegates will be able to:

  • Create simple databases
  • Work with records in tables
  • Edit and modify tables
  • Manipulate data by creating and modifying queries
  • Displaying and editing data using forms and reports
  • Create smaller more efficient tables by joining or relating
  • Add graphical elements to forms

Course Content

Getting Started

  • An Overview of Access & Databases

Creating Tables

  • Creating tables using the Design View & the
    Table Wizard
  • Setting Field Names, Data Types & Primary
    Keys

Working with Table Data

  • Record Navigation
  • Adding, Editing, Saving & Deleting Records

Setting Field Properties

Modifying Datasheets

  • Inserting, Renaming & Deleting Columns
  • Adding a Lookup Column
  • Changing height & width of rows/columns
  • Changing font attributes & cell effects
  • Selecting, moving, hiding, unhiding &
    freezing a column

Organising Table Data

  • Sorting and Filtering Data
  • Finding and Replacing Data

Using Simple Queries

  • Creating Queries using the Design View
    & the Simple Query Wizard
  • Joins in Tables

Modifying Query Results

  • Sorting & Printing a Query
  • Adding Criteria to a Query

Creating Basic Forms

  • Creating a Form using the Forms Wizard
  •  “Quick” Forms
  • Adding a Field to a Form

 

Manipulating Controls        

  • Form Layout View
  • Editing Controls in Layout View

Customising Layout View Using Design View

  • Design Tools
  • Adding Fields
  • Moving and Aligning Controls
  • Spacing Controls
  • Adding Images and Graphical Elements to a
    Form

 Creating Basic Reports

  • Creating a Report using the Report Wizard
  • Printing & Grouping Reports
 Formatting Controls
  • Font Effects, Colours and Borders & Special
    Effects
  • The Format Painter
  • AutoFormat
  • Spell Checking

Working with Help

Relationships

  • Creating Table Relationships
  • Setting Referential Integrity
  • Subdatasheets

Using Operators in Queries

  • Using Comparison Operators & Wildcards

Advanced Queries

  • Creating & Formatting a Calculated Field
  • Creating Function Queries
  • Setting Top Values in a Query
  • Parameter Queries
  • Concatenation in a Query

Action Queries

  • Make Table, Append, Delete, Update

 

Click to expand...

Perfect Partners

Other courses which naturally complement this course include:

 

Next Learning Step

The next course in this series is:

Relevant accreditations include:

  • Microsoft® Certified Application Specialist:
    Using Microsoft® Office Access 2007