Microsoft Access 2016

Microsoft Access Course
Microsoft Access Course enables learners to understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.
On completion of this module each learner will be able to:
- Understand what a database is and how it is organised and operated
- Create a simple database and view the database content in various modes
- Create a table, define and modify fields and their properties; enter and edit data in a table
- Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
- Understand what a form is and create a form to enter, modify and delete records and data in records
- Create routine reports and prepare outputs ready for distribution
Who Should Attend This Course
This course is intended for learners with little or no knowledge of running a database application and using a database.
Assumed Skills
The learner must be able to:
- operate a Personal Computer, use keyboard and mouse
- read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)
Course Features
- Course Code AC24
- Duration 2 days (16 hours of training, 1 hour of Assessment), 9:00am - 6:00pm
- Level All levels
Curriculum
-
Database Concepts
-
Managing a Database
-
Database Tables
-
Working with Data
-
Report and Export
Full | 21 - 39 yrs old or PR | 40 yrs old & above (MCES1) | WTS (Workfare2) |
---|---|---|---|
$417.30 | $145.30 | $66.30 | $46.80 |
All prices inclusive of GST
*Read more on SkillsFuture MCES1 and Workfare2
Please enquire to get the schedules. Part time classes are available.