Byron Employment

Byron Employment. Over 71,667 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $620.00

Course Overview

Design a database Query the information stored inside an Access database. Generate printouts from a database Modify user interface tools in a database.

Delivery

Classroom

Locations

  • Public Schedule - Canberra, Melbourne, Perth and Sydney
  • Group Bookings - all States and Territories across Australia

Duration

 2 days

At the end of this course you should be able to:

• Use the database window to rename, copy and delete objects

• Create a simple table for storing data with

• appropriate fields, data-types and properties

• Use formatting options to modify table

• appearance

• Create appropriate links between tables and understand relationship types

• Find information using the datasheet view of a table

• Ask questions of data by creating single and

• multi table queries

• Use action queries to update data or delete

• records

• Create forms to serve as a user interface using wizards and the autoform feature

• Make simple changes to the design of a form, such as moving and resizing controls

• Create reports to generate printouts using wizards and the autoreport feature

• Make simple design changes to a report

Course Outline

Fundamentals

• Define a database and a database management system

• Start and exit Access

Databases and Tables

• Open an Existing Database

• Overview of an Access Database

• Use Database and Table Wizards

Tables

• Designing a Table/Understanding Datatypes

• Entering Data

• Modify Table Layout

Field and Table Properties

• Basic Field and Table Properties

• Using a Lookup Wizard

Relationships

• Understanding the Relationship Classifications

• and Advantages of Using Them

• Using the Relationships Window

• Creating a Main/Subform

Finding and Sorting Data

• Finding Data by Value

• Replacing Values

• Sorting and Filtering

Building Simple Queries

• Use Criteria

• Sort the Results

Applied Queries

• Multiple Table Queries

• Parameter Queries

• Action Queries

Forms

• Create a Form Using a Wizard

• Entering and Filter Data on a Form

• Introductory Form Design

Reports

• Create a Report Using a Wizard

• Introductory Report Design

Pre-requisites:

Basic understanding of the Windows operating system is essential. Users should have knowledge of at least one other Windows application such as Word or Excel before attending this course.

 

 

 

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search