Support

Access 2003 Course - Introduction

2 sessions available starting from $700.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

This course has been designed to introduce new users to Access 2003 databases. Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database. Students will consolidate their knowledge by creating a simple database on day two of the course.

Duration:

2 Days

Audience:

Students who need to learn basic database techniques as well as the skills required to modify an existing database or create a new database.

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.

Course Content:

Working with Databases

• Overview of relational databases
• Spreadsheets -v- databases
• How Access 2003 stores data

Starting...

see more

This course has been designed to introduce new users to Access 2003 databases. Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database. Students will consolidate their knowledge by creating a simple database on day two of the course.

Duration:

2 Days

Audience:

Students who need to learn basic database techniques as well as the skills required to modify an existing database or create a new database.

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.

Course Content:

Working with Databases

• Overview of relational databases
• Spreadsheets -v- databases
• How Access 2003 stores data

Starting Access 2003

• Opening an existing database
• Screen components of the Access 2003 window

Working with Tables

• Opening and closing a table
• Understanding fields and records
• Moving around records in a datasheet
• Identifying records
• Adding a new Record
• Columns widths and Row heights
• Moving and Hiding/unhiding columns
• Freezing columns

Working with Forms

• Overview of forms and their use
• Opening a Form
• Moving around fields in a form
• Moving between records using a form
• Adding new records with a form
• Closing a form
• Using different Form views
• Switching between views

Working with Data

• Editing Data
• Finding and Filtering Records
• Deleting Records
• Sorting Data
• Using forms with subforms

Creating Tables

• Table structures in Access
• Planning tables
• Standard naming conventions
• Field names and descriptions
• Understanding Primary Keys
• Setting a Primary key
• Changing the Primary key

Table Properties

• Understanding and setting Field properties
• Setting Data types
• Formatting data
• Using input validation rules to control input
• Using an input mask to assist data entry
• Entering data into a table
• Using Shortcut keys for text entry
• Printing data from a table

Editing Properties

• Changing the data type of a field
• Renaming a field
• Adding a lookup field with the wizard
• Finding a record

Creating Forms

• Understanding the uses of Forms
• Using the AutoForm button
• Using the Form wizards
• Adding a new record from a form
• Finding records in a form
• Editing a record in a form

Modifying Forms Data

• Using Design view
• Selecting a control
• Moving Controls and labels independently
• Resizing and Formatting controls
• Changing colours, fonts and borders
• Using Format painter
• Adding and formatting lines
• Nudging and Aligning controls
• Changing the stack order of controls
• Adding a new control
• Changing the Tab order of controls

Queries

• Opening a Query
• Creating new Queries
• Adding Fields to the Query
• Running a query
• Sorting Data in a query
• Adding a table to a query
• Creating a manual join
• Renaming a query
• Hiding fields in a record
• Creating calculated field

Creating Reports

• Creating a report based on a query
• Adding calculated fields to a report

Designing Databases

• Creating a new Database
• Importing and Linking Data from database tables or a spreadsheet
• Linking to another Database

Table Relationship

• Types of Relationships
• Setting Relationships
• Printing a Relationship Diagram

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions



My Other Listings

Access 2010 Course -Intermediate
Access 2010 Course -Intermediate
3 sessions available starting from $700.00
Word 2007 Advanced Course
Word 2007 Advanced Course
8 sessions available starting from $770.00
Access 2003 Course - Intermediate
Access 2003 Course - Intermediate
1 session available for $700.00

see all listings »


Found In