Byron Employment

Byron Employment. Over 148,685 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $620.00

Course Overview

  • Work with the more advanced properties of tables and fields
  • Create forms that display information from more than one table or query at a time
  • Make drop down lists of options on a form
  • Add groups of options and flexible buttons
  • Have fields grow/shrink to suit data and produce
  • Ccalculated values in a report
  • Create a customised user interface for your database

Delivery

Classroom

Locations

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

Duration

2 days

Prerequisites

To gain maximum benefit from this course, participants should have completed Essentials course. Students need a solid understanding of relationships, creating tables using design view, using form and report wizards and creating select queries.

At the end of this course

You should be able to:

  • Use advanced table and field properties
  • Create main/subforms for displaying related information from different data sources
  • Add complex form controls using their associated wizards
  • Generate mailing labels and Word mail merges
  • Display calculated values in a report, form or query
  • Create action queries for deleting and updating data, making tables or appending records to another table
  • Make a customised user interface using switchboard forms
  • Understand and manipulate grouping reports

Course Content

Revision

  • Short Revision Exercise

Project Overview

  • Discussion of Course Project (Building an Asset Tracking System)

Customising Tables

  • Importing Excel Data Using a Wizard
  • Advanced Field Properties
  • Review of Relationships

Creating Complex Forms

  • Using Wizards to Create Main/Subforms and Linked Forms

Form Design

  • Elements of a Form in Design View
  • Adding Controls Using the Toolbox
  • Using the Autoformat Tool

Applied Form Design

  • Adding Advanced Controls Using Wizards
  • Property Sheets
  • Using Builders

Reports

  • Report Wizards for Mailing Labels
  • Creating a Word Mail Merge

Report Design

  • Sorting and Grouping
  • Displaying Calculated Values

Queries

  • Multi-table Queries
  • Displaying Calculated Values
  • Using Action Queries

Database Consolidation

  • Using the Switchboard Manager
  • Creating a Startup Form

 

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