Byron Employment

Byron Employment. Over 156,498 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $900.00

Course Overview

In this course, student will extend their knowledge into some of the more specialized and advanced capabilities.

Delivery

Classroom

Duration

2 Days

Locations

  • Public Schedule - Brisbane, Melbourne, Newcastle, Perth and Sydney
  • Group Bookings - All States and Territories across Australia

Course Outline

Lesson 1: Structuring Existing Data

  • Import Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure

Lesson 2: Writing Advanced Queries

  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

  • Require Data Entry with a Macro
  • Display a Message Box with a Macro
  • Automate Data Entry

Lesson 5: Making Forms more Effective

  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

  • Cancel Printing of a Blank Report
  • Include a Chart in a Report
  • Arrange Data in Columns
  • Create a Report Snapshot

Lesson 7: Maintaining an Access Database

  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
     
CLICK HERE TO BOOK THIS COURSE NOW!

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

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

Search Courses

Quick Job Search