Access 2003 Level 1

Progressive Training & Development

Short course

In Southwark

Price on request

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports are introduced mostly using the inbuilt wizards.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

Must be confident in
at least one other Microsoft Application, preferably Excel.

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

DESCRIPTION
This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports are introduced mostly using the inbuilt wizards.

PREREQUISITES
Must be confident in at least one other Microsoft Application, preferably Excel.



INTRODUCTION
  • Database Basic Concepts
  • Database Object Overview

USING TABLES
  • Field Names vs Records
  • Navigating around a table
  • Entering Data
  • Deleting Records
  • Modifying the datasheet
    • Moving Columns (Fields)
    • Hiding/Unhiding Fields
  • Understanding Table Relationships

CREATING TABLES
  • Defining Field Names
  • Selecting Data Types
  • Using Descriptions
  • Modifying Field Properties
  • Using Primary Keys
  • Attaching a photo or file to a record

SELECT QUERIES
  • What is a query
  • Designing a Query
  • Using Criteria
  • Sorting Results
  • Creating a Calculation
  • Setting the format property of a calculated column

SIMPLE FORMS
  • What is a Form
  • Why use a Form
  • Creating a Form using the wizard
  • Making simple formatting changes
  • Adding a Form Header
  • Adding a Calculation
  • Moving and Resizing Objects
  • Understanding Properties of a Form

SIMPLE REPORTS
  • What is a Report
  • Why use a Report
  • Creating a Report using the wizard
  • Making simple formatting changes
  • Moving and Resizing Objects
  • Understanding Properties of a Form






See related categories

Access 2003 Level 1

Price on request

The best Access courses

See all

See all