Microsoft Access 2019 Advanced (2 Days) (15 hrs)

Course Code: CRS-N-0050301

This course provides the participants with an understanding of the different ways to organise data, as well as how to import, export, and link data. The participants will be able to demonstrate advanced data management skills by using the database to organise, extract, view, and report on data. They will also learn to run and record simple macros.

  • Understand different ways to organise data
  • Able to import, export, and link data
  • Demonstrate advanced data management skills
  • Learn to run and record simple macros

Designing advanced queries

  • Setting top values in a query
  • Creating a calculated field
  • Formatting a calculated field
  • Displaying a totals row in a query
  • Creating a function query
  • Creating a parameter query
  • Using multivalued fields
  • Creating a concatenation in a query
  • Filtering a query

Creating action queries

  • Creating a make-table query
  • Creating an update query
  • Creating an append query
  • Creating a delete query

Using advanced query wizards

  • Using the crosstab query wizard
  • Using the find duplicates query wizard
  • Using the find unmatched query wizard

Using advanced form design

  • Creating a combo box
  • Creating a list box
  • Creating an option group
  • Adding a logic control
  • Setting the tab order automatically
  • Setting the tab order manually
  • Adding a form header and footer
  • Creating a blank form

Using advanced report design

  • Adding report sections in design view
  • Creating a calculated control
  • Creating a running summary
  • Inserting a date / time control
  • Inserting a page break
  • Changing the report margins
  • Using the label wizard
  • Creating a report without using a wizard

Using subforms / subreports

  • Creating a subform / subreport
  • Editing the layout of a subform
  • Displaying a subform in datasheet view
  • Displaying a subform total

Using other form techniques

  • Creating a split form
  • Converting an existing form to a split form
  • Editing a split form
  • Adding a command button
  • Saving a form as a report

Creating macros

  • Working with macros
  • Creating a macro
  • Assigning an argument to an action
  • Saving a macro
  • Using single step mode for testing running a macro
  • Editing an existing macro

Using macros

  • Creating embedded macros
  • Assigning a macro to a control
  • Creating a command button
  • Adding an IF condition to a macro

Using advanced database features

  • Importing data
  • Linking data to an access table
  • Using the linked table manager
  • Exporting data
  • Converting files
  • Printing a relationship document
  • Compacting a database
  • Using name autocorrect
  • Backing up a database

Exporting data

  • Exporting data to an Excel workbook
  • Dragging and dropping data into Excel
  • Creating word mail merge documents

Exporting data to excel and word

  • Exporting data to an Excel workbook
  • Dragging and dropping data into Excel
  • Creating Excel workbooks – office links
  • Creating Word documents – office links

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for:

  • For professionals across a broad spectrum of industries looking to achieve advanced proficiency in Microsoft Access 2019, such as PA, EA, VA, Administrator, Secretary, and Customer Services Executives
  • Anyone seeking to use Microsoft Access 2019 for advanced data management and analysis at home or small businesses

Prerequisite

Participants must have knowledge of MS Access 2019 at the intermediate level.

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $450.00
Nett Fee Incl. 7% GST : $481.50
SDF Support* : $30.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Key Benefits
  • Understand different ways to organise data
  • Able to import, export, and link data
  • Demonstrate advanced data management skills
  • Learn to run and record simple macros
Course Contents

Designing advanced queries

  • Setting top values in a query
  • Creating a calculated field
  • Formatting a calculated field
  • Displaying a totals row in a query
  • Creating a function query
  • Creating a parameter query
  • Using multivalued fields
  • Creating a concatenation in a query
  • Filtering a query

Creating action queries

  • Creating a make-table query
  • Creating an update query
  • Creating an append query
  • Creating a delete query

Using advanced query wizards

  • Using the crosstab query wizard
  • Using the find duplicates query wizard
  • Using the find unmatched query wizard

Using advanced form design

  • Creating a combo box
  • Creating a list box
  • Creating an option group
  • Adding a logic control
  • Setting the tab order automatically
  • Setting the tab order manually
  • Adding a form header and footer
  • Creating a blank form

Using advanced report design

  • Adding report sections in design view
  • Creating a calculated control
  • Creating a running summary
  • Inserting a date / time control
  • Inserting a page break
  • Changing the report margins
  • Using the label wizard
  • Creating a report without using a wizard

Using subforms / subreports

  • Creating a subform / subreport
  • Editing the layout of a subform
  • Displaying a subform in datasheet view
  • Displaying a subform total

Using other form techniques

  • Creating a split form
  • Converting an existing form to a split form
  • Editing a split form
  • Adding a command button
  • Saving a form as a report

Creating macros

  • Working with macros
  • Creating a macro
  • Assigning an argument to an action
  • Saving a macro
  • Using single step mode for testing running a macro
  • Editing an existing macro

Using macros

  • Creating embedded macros
  • Assigning a macro to a control
  • Creating a command button
  • Adding an IF condition to a macro

Using advanced database features

  • Importing data
  • Linking data to an access table
  • Using the linked table manager
  • Exporting data
  • Converting files
  • Printing a relationship document
  • Compacting a database
  • Using name autocorrect
  • Backing up a database

Exporting data

  • Exporting data to an Excel workbook
  • Dragging and dropping data into Excel
  • Creating word mail merge documents

Exporting data to excel and word

  • Exporting data to an Excel workbook
  • Dragging and dropping data into Excel
  • Creating Excel workbooks – office links
  • Creating Word documents – office links
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for:

  • For professionals across a broad spectrum of industries looking to achieve advanced proficiency in Microsoft Access 2019, such as PA, EA, VA, Administrator, Secretary, and Customer Services Executives
  • Anyone seeking to use Microsoft Access 2019 for advanced data management and analysis at home or small businesses

Prerequisite

Participants must have knowledge of MS Access 2019 at the intermediate level.

Course Details

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $450.00
Nett Fee Incl. 7% GST : $481.50
SDF Support* : $30.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Course Application

Details Registration
February 6, 2020 - February 7, 2020 (9:00 am - 5:30 pm) Closed