Byron Employment

Byron Employment. Over 71,625 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $484.00

Course Overview

This course is designed for people who are existing users of Access databases and wish to be able to modify and enhance existing databases. The course covers the features that are used to create more advanced queries, forms and reports, and expressions to effectively manipulating data.

Duration

2 days

Delivery

Classroom

Audience

The course has been designed for participants who need to use a database for managing data.

Pre-requisites

Participants must have completed the Access Introduction course or have equivalent knowledge.

Students must be familiar with using an Access database and the basic principles of the relational databases.

Inclusions

  • Comprehensive, step-by-step training manual
  • Disk containing a duplicate set of exercises used during the course
  • Lunch & Refreshments
  • Free Telephone support

Course Content

Comparison Operators in Queries

  • And, Or, Not, Between
  • Using wild cards

Actions QueriesUpdate queries

  •  
  • Append queries
  • Delete queries
  • Make Table queries

Advanced QueriesTop Values

  •  
  • Calculated Fields
  • Joining Tables in a query
  • Join Types
  • Parameter queries
  • Function queries
  • Using Concatenation in queries
  • Find Duplicates query wizard

Customising FormsAdding bound controls

  •  
  • Creating unbound controls
  • Working with the Form sections
  • Using the Field List
  • Aligning Controls

Form Controls and PropertiesAdding lines, and images

  •  
  • Adding Checkboxes, Option Buttons and Groups
  • Command Buttons
  • Changing the Tab Order
  • Creating a Combo Box
  • Using multiple columns in a combo box.
  • Adding a List box
  • Creating a Blank Form
  • setting field sizes
  • Setting default values

Reporting

  • Using Design View
  • Using queries for Reports
  • Grouping Data in a report
  • Using Headers and Footers
  • Report Layouts – Stepped and Blocked
  • Creating a Running Summary
  • Inserting a Page Break
  • Using Columns in report
  • Using the Keep Together property
  • Formatting Text
  • Adding Lines
  • Sorting Report output
  • Using the Report wizard
  • Label Wizard
  • Creating a Blank Report
  • Adding multiple columns

SubReports

  • Uses of SubReports
  • Creating a subreport

SubForms

  • Creating a Subform
  • Uses of Subforms

Using Expressions

  • Using the Expression Builder
  • Manipulating Text and Date Values – Date(), DateDiff(), DatePart(), DateAdd()
  • Expressions using Fields
  • Conditional Express IIF()
  • Aggregate Functions – Sum(), Avg(), Count()
  • Referring to subform/subreport controls in expressions

Macros

  •  

  • Overview of macro uses
  • Creating a macro
  • Adding macro actions
  • Running a macro
  • Creating a Command button
  • Attaching a macro to a command button
  • Creating a Print macro
  • Creating a Close macro
  • Testing macros
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON 1 300 731 451
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL 1 300 731 451 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search