MS Access 2003 Introduction

Training

Inhouse

Price on request

Description

  • Type

    Training

  • Methodology

    Inhouse

  • Duration

    2 Days

To build a strong foundation in Access to provide new users with a good understanding of the basic concepts of Microsoft Access. Suitable for: New Access users, or self taught users.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Contents

Database Overview / Terms / Planning
  • An overview of databases, database objects and terminolgy
  • Tables, Queries, Forms, Reports, Macros, Pages and Modules
  • Planning a database structure and tables
  • Creating a new database

Working with Tables

  • Designing a Table, Rules for entering Field Names
  • Enter data types, field descriptions
  • Setting a Primary Key and Setting Multiple Primary Keys
  • Removing a Primary Key
  • Defining Field Properties(Default values, Input masks, Validation rules and text,
  • Insert, Delete, Move and Rename Fields
  • Table Wizards

Entering and Editing Data

  • Switching Views in Access
  • Entering and Editing Data
  • Working in Data Entry Mode
  • Sorting Data, Finding & Replacing Data
  • Hiding and Unhiding Fields

Importing & Linking Data

  • Importing from Access and Excel
  • Linking to an external Access Database Table
  • Linking to an Excel Workbook using the Wizard
  • Renaming and Copying Tables

Quries and Filters

  • Create a filter by selection
  • Create a filter by form
  • Save a filter by form as a select query
  • Running a Select Query
  • The Query Design Window
  • Creating a query from the query window
  • Adding fields to a query, Display/Suppress the display of a field
  • Removing fields from a query
  • Specifying Text, numeric, date, and logic criteria
  • Specifying sub string searches using wild Card Characters
  • Working with Conditions - BETWEEN, AND, OR, NOT, NULL
  • Calculated fields

Relationships

  • Why create relationships between tables?
  • Different types of relationships
  • Conditions for setting up a relationship
  • Referential Integrity
  • Cascade Update
  • Cascade Delete
  • Relationships Report
  • Inserting Subdatasheets
  • Removing Subdatasheets
  • Expanding and Contracting Subdatasheets

Mutli Table Queries

  • Multiple Table Queries
  • Joining Tables for a query
  • Join Properties - Inner and Outer Joins
  • Find Unmatched Query Wizard
  • Find Duplicates Query Wizard

Creating Forms

  • Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
  • Creating Forms Using the Form Wizard
  • Data Entry in Forms
  • Resizing and Moving Controls
  • Changing Text Attributes
  • Resizing Forms
  • The Field List Box
  • Selecting Controls
  • Formatting Controls
  • Format Painter and AutoFormat
  • Resizing and Moving Controls
  • Properties of an item

Reports

  • Standard Reports using Wizard
  • Inserting, Moving, Sizing, deleting controls
  • Customising Reports
  • Grouping Data
  • Using Expressions
  • Mailing Labels
  • Page setup
Time: The course starts at 09:30 and runs until 16:30.

The course is run on a date that suits you! We do not run public scheduled courses.

Additional information

Payment options: All our courses are charged at a flat rate per day. One to One - Charged at £450 per day Group Onsite Training - Charged at £595 per day. Thats for up to 8 delegates costing less than £75 per person! All prices are excluding VAT and per day. Travel cost outside the M25 applies.
Students per class: 8

MS Access 2003 Introduction

Price on request