Byron Employment

Byron Employment. Over 71,631 Jobs Australia Wide.

Delivery Method

  • Classroom

Upon completion of our Microsoft Access 2003 level 1 training you will be able to create real-world database applications that collect data, permit data to be queried; produce reports and display information in forms.

This course assumes no prior knowledge of Microsoft Access. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

The course duration is 2 days.

Delivery Method

One on one training can be arranged.

Group bookings only - all states and territories.

Access 2003 orientation

Relational queries

Starting Access 2003
Opening an existing database
The Access 2003 screen
The database window
Working with database objects
Using menu commands
Using keyboard shortcuts
Exiting from Access 2003
How relational queries work
Queries for viewing data
Creating a query design
Selecting fields for the query grid
Different views of a query
Adding more tables to a query
Modifying fields in a query
Selecting records using a query
Running a query from the database window

Database theory

Relational select queries

Understanding databases
How Access stores data
Spreadsheets vs databases
Creating and queries
Clearing query criteria
Selecting numeric data
Selecting dates in a query
Creating or queries
Using a range expression
Selecting opposite values
Using wildcards
Problem selects

Database design

Calculated fields

Designing a relational database
Scoping the system
Determine the inputs
Normalise the table
First normal form
Second normal form
Third normal form
A series of related tables
Creating a calculated field
Formatting calculations
Calculating across two tables
Calculating dates
Using criteria in calculations
Concatenating string fields

Relational databases

Parameter queries

Creating a new database file
Access 2003 data types
Creating a new table
Changing field properties
Creating a table from a shortcut
Creating a table with numbers
and currency
Assignment – creating tables
Creating a parameter query
Displaying all records
Using parameters to display a record range
Nominating specific data types
Using parameters in expressions
 

Setting table relationships

Creating forms

Understanding table relationships
Accessing the relationships window
Table joins in the case study
Creating table joins
Assignment – creating relational joins
Editing an existing relationship
Printing table relationships
Forms – how they work
Creating a single table form
Working with a form
Creating a subform
Creating a linked form

Adding relational records

Creating reports

Adding records in a table
Adding records using an autoform
Assignment – adding records
Data entry key violations
Data integrity violations
Reports – how they work
Single table reports
Previewing a report
Creating a multi-table report
Creating a report from a query

Importing records

Using the switchboard

Importing from a spreadsheet
Importing from a text file
Backing up a table
Importing and key violations
Deleting an unwanted table
Data integrity and importing
Creating a switchboard
Creating subsidiary menus
Creating a menu item
Returning to another menu
Creating menu items
Linking the menus
Modifying the menu forms
Changing the startup

Working with records

Getting help

Navigating in a table
Editing a record
Deleting a record
Deleting several records
Finding and replacing
Undoing an error
Compacting a database
Printing records
Working with sub datasheets
Assigning a sub datasheet
Printed help sources
The help task pane
Searching for general help
Searching for specific help
Understanding a help window
Disabling online content
Enabling online content
Displaying and using the office assistant
Customising the office assistant
Disabling the office assistant
Screen tips and dialog box help

Data validation

 
Assigning default values
Marking a required field
Validation rules and text
Creating a lookup field
Working with validations
 

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9699 4940
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9699 4940 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search