Course Details close

Course Details

Price:
(inc GST)
$ 990
Application:Access
Level:Advanced
Version:2016
Duration:2 days
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

   (4.74 out of 5)
275 Access advanced student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 2 days Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 990
Sale Price:
(inc GST)
$

Quick links

Access Advanced 2016 Course | Raising the Bar

Course Overview

The Access Advanced course builds on your current knowledge gained from the Access Essentials course or equivalent. This 2 day course focuses on the more advanced features of Microsoft Access such as database maintenance, importing and exporting data using other compatible applications, building and executing more advanced queries such as action and crosstab queries, changing join types to achieve a desired reporting outcome, implementing security and automating tasks with macros and VBA. Students will also gain a much deeper understanding of table relationships using cascade update and delete options as well as being able to work confidently with properties and expressions in queries forms and reports. The knowledge attained from this course will allow students to provide the additional polish to your existing databases or upcoming projects.

Who Should Attend This Course

Students should be confident in creating and designing tables, queries, forms, reports and have a basic understanding of table relationships before attending this course. This course will provide students with a much deeper knowledge and appreciation of creating, using and developing relational databases and associated tools, features and techniques.

Course Prerequisites

Microsoft Access Essentials or equivalent

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

With each course we provide you with a comprehensive course manual for you to practice post course.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status
21-Apr-22 (Thu)$990.00 0
20-Jun-22 (Mon)$990.00 0

Public Course Dates

Course Date Price Add Course Qty Status
21-Apr-22 (Thu)$990.00 0
20-Jun-22 (Mon)$990.00 0

Course Outline

Database Maintenance

  • Back Up Database
  • Analyze Performance
  • Compact and Repair
  • Database Documenter
  • Object Dependencies
  • ACCDE files Split the Database

Import and Export Data

  • Export to Excel
  • Export to Word
  • Export to PDF
  • Use a Saved Export Task
  • Import from Excel to a New Table
  • Append Data from Excel to an Existing Table
  • Normalise Imported Tables
  • Link to Excel
  • Import or Link from Another Access Database
  • Access 2013 Doesn’t Support Data Collection

Advanced Queries

  • About the Expression Builder
  • Create a Calculated Field
  • Show Top Values
  • Create Function Queries
  • Concatenations and Null Precedence
  • Using Null as a Criterion
  • Use Calculations to Impose Case
  • IIf Calculations
  • Nested IIf Functions
  • Calculating with Dates
  • Format Fields Querying Multivalue Fields

Action and SQL Queries

  • Enabling and Running Action Queries
  • Create an Update Query
  • Create an Append Query
  • Create a Delete Query
  • Automatic Archiving
  • Create a Make Table Query
  • Hide Action Queries
  • SQL
  • Outer Joins
  • Create a Union Query Other SQL-specific queries

Subforms and Calculations

  • Automatically Create Forms and Subtables
  • SubDataSheets in SubTables
  • Manually Insert a Subform
  • Default View for the Subform
  • Calculate Totals for Subforms
  • Hide a Subform
  • Hide Columns in a Combo Box
  • Linking to Combo Box Columns
  • Preventing Data Entry in Calculated Fields
  • Cascading Combo Boxes
  • Create a Second Combo Box
  • Add a Selection Criterion to the Client Box
  • Use the Refresh Macro

Charts and PivotTables

  • Create a Chart
  • Modify the Chart
  • Remove the Dummy Data
  • Conditional Formatting
  • PivotTables And PivotCharts Are Not Supported In Access 2103

Macros

  • What are Macros?
  • Create a Simple Macro
  • Collapse and Expand Action Arguments
  • Run and Edit Macros
  • Adding Comments
  • Access Macro Actions
  • Assign a Macro to an Event
  • Create a Group of SubMacros
  • Create Buttons on a Form
  • Copy and Paste a Control
  • Create a Conditional Macro
  • Error Trapping
  • Interactions - MessageBox
  • Interactions - MsgBox as a Function Interactions - InputBox and SetTempVar

Security

  • Where is User-Level Security?
  • Convert the Database
  • Enable Content
  • Encrypt with a Database Password
  • Add Trusted Locations
  • Create a Self-Signed Certificate
  • Package and Sign the Database
  • Extract the Packaged Database Remove a Trusted Publisher

Modules

  • Create a Module
  • Convert a Macro to VBA
  • Interpret the VBA Code
  • Edit the Code
  • IntelliSense
  • Standard and Class Modules
  • Add VBA to a Form Event
  • VBA Errors

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us