Microsoft Access 2019 Basic & Intermediate (2 Days) (15 hrs)

Course Code: CRS-N-0050272

This course provides the participants with an understanding of the basic concepts of databases and demonstrates the ability to use a database on a personal computer. It is divided into two sections; the first section tests the participants’ ability to design and plan a simple database using a standard database package; the second section introduces the skills required to retrieve information from an existing database by using the query, select and sort tools available in the database. The participants will also be able to create and modify reports.

  • Understand the basic concepts of databases
  • Demonstrate the ability to use a database
  • Create and modify reports

Exploring Access 2019

  • Working with Access
  • Starting Access
  • Using the interface
  • Using the file tab
  • Opening an existing database
  • Using the ribbon
  • Using the Quick Access Toolbar
  • Using database objects
  • Using the navigation pane
  • Opening a database object
  • Using tabbed documents
  • Closing a tabbed document
  • Closing all tabbed documents
  • Using the status bar
  • Using the options dialog box
  • Closing a database
  • Exiting Access

Creating tables

  • Using the database templates
  • Creating a new database
  • Designing tables
  • Creating a table in datasheet view
  • Creating a table in design view
  • Adding field names
  • Assigning data types
  • Saving a new table
  • Adding a field description
  • Setting a primary key
  • Using multi-valued fields

Field properties

  • Using field properties
  • Limiting field size
  • Setting number formats
  • Setting date / time formats
  • Setting yes / no formats
  • Setting default values
  • Setting validation rules
  • Creating an input mask wizard
  • Creating an input mask manually
  • Creating a custom input mask
  • Typing a lookup list
  • Modifying lookup properties

Working with tables

  • Using datasheet view
  • Navigating fields in tables
  • Using field templates
  • Adding records
  • Moving through records
  • Selecting records
  • Editing records
  • Deleting records
  • Displaying totals row in a table

Editing tables

  • Changing the row height
  • Changing the column width
  • Changing a font attribute
  • Changing a cell effect
  • Using alternate background colours
  • Selecting a column
  • Moving a column
  • Hiding a column
  • Unhiding a column
  • Freezing a column

Finding, replacing and filtering data

  • Sorting records
  • Finding specific records
  • Finding records using wildcards
  • Using replace
  • Using filter by selection
  • Applying / removing a filter
  • Using filter excluding selection
  • Using the search box
  • Using quick filter
  • Using auto filter

Using simple queries

  • Using queries and record sets
  • Using the simple query wizard
  • Creating a query in design view
  • Opening a query
  • Adding a table to a query
  • Joining tables in a query
  • Running a query

Modifying query results

  • Sorting a query
  • Adding criteria to a query
  • Hiding a field in a query
  • Displaying totals row in a query
  • Adding a record using a query
  • Printing a query

Using operators in queries

  • Using comparison operators
  • Using an and condition
  • Using an or condition
  • Using the between and operator
  • Using the expression builder
  • Using a wildcard character

Relating tables

  • Using related tables
  • Creating a relationship between tables
  • Setting referential integrity
  • Viewing subdatasheets
  • Deleting a join line

Creating basic forms

  • Using forms
  • Using the forms button
  • Adding a record using a form
  • Using the calendar for date picking
  • Using the form wizard
  • Viewing records in a form
  • Printing records in a form
  • Basing a form on a query

Using design view

  • Adding a label
  • Adding an image
  • Adding a rectangle
  • Adding a line
  • Editing an unbound control
  • Using multiple undo / redo in design view

Creating basic reports

  • Using reports
  • Using the reports button
  • Using the print preview – reports
  • Printing pages of a report
  • Using the report wizard
  • Changing views in a report
  • Grouping and summarising report data
  • Basing a report on a query

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

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

This course is suitable for:

  • For individuals with none or little knowledge in Microsoft Access 2019 looking to kick-start a career as PA, EA, VA, Administrator, Secretary, Customer Services Executives and much more
  • Anyone seeking to use Microsoft Access 2019 for advanced data management, analysis and report creation in home and small businesses

Prerequisite

Participants must have a basic knowledge of Windows / MS Access 2010/2013/2016.

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

Course Fee : $430.00
Nett Fee Incl. 7% GST : $460.10
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 the basic concepts of databases
  • Demonstrate the ability to use a database
  • Create and modify reports
Course Contents

Exploring Access 2019

  • Working with Access
  • Starting Access
  • Using the interface
  • Using the file tab
  • Opening an existing database
  • Using the ribbon
  • Using the Quick Access Toolbar
  • Using database objects
  • Using the navigation pane
  • Opening a database object
  • Using tabbed documents
  • Closing a tabbed document
  • Closing all tabbed documents
  • Using the status bar
  • Using the options dialog box
  • Closing a database
  • Exiting Access

Creating tables

  • Using the database templates
  • Creating a new database
  • Designing tables
  • Creating a table in datasheet view
  • Creating a table in design view
  • Adding field names
  • Assigning data types
  • Saving a new table
  • Adding a field description
  • Setting a primary key
  • Using multi-valued fields

Field properties

  • Using field properties
  • Limiting field size
  • Setting number formats
  • Setting date / time formats
  • Setting yes / no formats
  • Setting default values
  • Setting validation rules
  • Creating an input mask wizard
  • Creating an input mask manually
  • Creating a custom input mask
  • Typing a lookup list
  • Modifying lookup properties

Working with tables

  • Using datasheet view
  • Navigating fields in tables
  • Using field templates
  • Adding records
  • Moving through records
  • Selecting records
  • Editing records
  • Deleting records
  • Displaying totals row in a table

Editing tables

  • Changing the row height
  • Changing the column width
  • Changing a font attribute
  • Changing a cell effect
  • Using alternate background colours
  • Selecting a column
  • Moving a column
  • Hiding a column
  • Unhiding a column
  • Freezing a column

Finding, replacing and filtering data

  • Sorting records
  • Finding specific records
  • Finding records using wildcards
  • Using replace
  • Using filter by selection
  • Applying / removing a filter
  • Using filter excluding selection
  • Using the search box
  • Using quick filter
  • Using auto filter

Using simple queries

  • Using queries and record sets
  • Using the simple query wizard
  • Creating a query in design view
  • Opening a query
  • Adding a table to a query
  • Joining tables in a query
  • Running a query

Modifying query results

  • Sorting a query
  • Adding criteria to a query
  • Hiding a field in a query
  • Displaying totals row in a query
  • Adding a record using a query
  • Printing a query

Using operators in queries

  • Using comparison operators
  • Using an and condition
  • Using an or condition
  • Using the between and operator
  • Using the expression builder
  • Using a wildcard character

Relating tables

  • Using related tables
  • Creating a relationship between tables
  • Setting referential integrity
  • Viewing subdatasheets
  • Deleting a join line

Creating basic forms

  • Using forms
  • Using the forms button
  • Adding a record using a form
  • Using the calendar for date picking
  • Using the form wizard
  • Viewing records in a form
  • Printing records in a form
  • Basing a form on a query

Using design view

  • Adding a label
  • Adding an image
  • Adding a rectangle
  • Adding a line
  • Editing an unbound control
  • Using multiple undo / redo in design view

Creating basic reports

  • Using reports
  • Using the reports button
  • Using the print preview – reports
  • Printing pages of a report
  • Using the report wizard
  • Changing views in a report
  • Grouping and summarising report data
  • Basing a report on a query

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
Learning Methodology

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

Who Should Attend

This course is suitable for:

  • For individuals with none or little knowledge in Microsoft Access 2019 looking to kick-start a career as PA, EA, VA, Administrator, Secretary, Customer Services Executives and much more
  • Anyone seeking to use Microsoft Access 2019 for advanced data management, analysis and report creation in home and small businesses

Prerequisite

Participants must have a basic knowledge of Windows / MS Access 2010/2013/2016.

Course Details

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

Course Fee : $430.00
Nett Fee Incl. 7% GST : $460.10
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
January 6, 2020 - January 7, 2020 (9:00 am - 5:30 pm) Closed