Byron Employment

Byron Employment. Over 145,636 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $700.00

Course Overview

This course has been designed to introduce new users to Access 2007 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.

Delivery

Classroom

Duration

2 days

Locations

  • Public Schedule - Brisbane
  • Group Bookings - All States and Territories across Australia

Course Content

Overview of the Window

  • Navigating Through the Window
  • Creating a Database from a Template
  • Creating a Blank Database

Opening the Help Screen

  • Overview of the Help Screen
  • Online Help vs. Offline Help
  • Searching for Help

Warnings You May See when Opening a Database

  • Enabling Content
  • About Digital Signatures
  • About Trusted Locations
  • Opening the Trust Centre
  • Assigning a Password to your Database

Opening the Help Screen

  • Overview of the Help Screen
  • Online Help vs. Offline Help
  • Searching for Help

Using the Quick Access Toolbar

  • About the Default Buttons
  • Adding Buttons
  • Removing Buttons
  • Customizing the Toolbar
  • Basics of Ribbons
  • Opening Dialog Boxes from the Ribbon
  • About the Office Menu
  • Reviewing the Ribbon Tabs

Planning a Database

  • Creating a Database from a Template
  • Creating a Blank Database
  • Using Database Objects
  • Setting Navigation Options

What is a Record?

  • Navigation Tips
  • Adding Records
  • Editing Records
  • Deleting Records
  • E-Mailing Records
  • Printing Records

About Tables

  • Creating a Table
  • Entering Data into a Table
  • Formatting a Table

What is a Form?

  • Bound vs. Unbound Controls
  • Creating a Form with the Wizard
  • Using Design View to Modify Your Form
  • Using Forms

What is a Query?

  • Creating a Query with the Wizard
  • Using Design View to Modify a Query
  • Using Queries

What is a Report?

  • Creating a Report with the Wizard
  • Using Design View to Modify a Report
  • Using Reports

Using the View Menu

  • Using the View Icons
  • Using the Tabs
  • Closing Individual Tabs Using Find and Replace
  • Sort Ascending or Descending
  • Toggling Filter
  • Using Selection Sort
  • Using Advanced Sort

Using the Quick Print Icon

  • Using the Print Menu
  • Using Print Preview
  • Using the Print Preview Ribbon
  • Printing vs. Exporting

 

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (07) 3210 0002
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (07) 3210 0002 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search