Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.

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

Visio 2003 Course | Introduction
Visio 2003 Course | Introduction
3 sessions available starting from $350.00
Delivering Effective Presentations Course
Delivering Effective Presentations Course
4 sessions available starting from $435.00
Acrobat 9 Introduction Course
Acrobat 9 Introduction Course
4 sessions available starting from $770.00

see all listings »


Found In