Byron Employment

Byron Employment. Over 71,594 Jobs Australia Wide.

Delivery Method

  • Classroom

Duration

3 half days

Prerequisite

Experience with Microsoft Windows and use of a mouse.

Objectives

To provide a thorough understanding of the comprehensive concepts and skills that will enable the participant to effectively use Microsoft Access.

Methodology

Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

Confirmation of Assessment Plan

This will be issued to the trainee at commencement of training session.

Expected Outcome

By the end of the course the participant should be able to use the following functions and features of Microsoft Access.

Content

Access Basics

  • Database overview
  • Elements of a database system
  • How other DBMS products work
  • How Access works
  • Starting Access
  • Working from startup
  • Working with Menus
  • Using the toolbar
  • Closing a Database
  • Opening a database window
  • Quick Review

Access Help

  • Online Help
  • Using the Office Assistnat
  • Customising the Office Assistant
  • Removing the Office Assistant
  • Using Help Contents
  • Using the Help index
  • Using the What's This?
  • Checking your system details
  • Quick Review

Creating a Database

  • Creating a database
  • Scoping the system
  • Creating a new database file
  • Creating a new table
  • Creating fields
  • Creating a Primary key
  • Creating field properties
  • Saving the table
  • Quick Review

Adding Records

  • Overview of data entry
  • Entering records directly into the table
  • Using the data entry facility
  • Adding records through a form
  • Quick Review

Changing Data

  • Overview changing the data
  • Changing table structures
  • Updating records
  • Finding a record to change
  • Changing several records at once
  • Deleting records
  • Quick Review

Working with a Table

  • Data overview
  • Moving about a table
  • Finding records
  • Searching and replacing
  • Filtering data
  • Filtering by form
  • Printing from a Table
  • Quick Review

Formatting a Table

  • Formatting overview
  • Widening columns
  • Selecting data
  • Changing the grid lines
  • Hiding columns
  • Freezing columns
  • Changing row heights
  • Changing fonts
  • Moving columns
  • Quick Review

Select Queries

  • Quering overview
  • Creating a query design window
  • Selecting fields for output
  • Dragging several fields
  • Double clicking fields
  • Selecting records
  • Selecting data within ranges
  • Sepcifying OR conditions
  • Using An-In-Line OR
  • Saving a query

Report Wizards

  • Reports overview
  • Creating a columnar report
  • Creating a tabular report
  • Using the report wizard
  • Using a query for a report
  • Changing a reports design
  • Running a report
  • Quick Review

Forms From Wizards

  • Forms overview
  • Creating a columnar auto-form
  • Creating a datasheet auto-form
  • Creating a tabular auto-form
  • Using the form wizard
  • Working with a form
  • Creating a form from a query
  • Quick Review

Conclusion

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (08) 8941 2344
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (08) 8941 2344 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search