Microsoft Access 2010
Please note that this page is for Non-accredited training. You will receive a Certificate of Participation upon completion of the day.
Duration: 6-8 hours*
Day times: 9.00 am - 5.00 pm (approx.) Monday to Friday
Fee: $240
Please note prices do not include GST
Class size: 12 students - Max, 4 students - Min, please contact us if you require a quote for a smaller class size or 1 on 1 training
Call now to enrol - 0456 CAREER (0456 227 337) or email - training@myhbc.com.au
Read below for course outlines for Level 1, Level 2 and Level 3
What is Access?
Microsoft Access is a database management system used to create and manage computer-based databases and combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools.
It enables you to organise, manage and store information for reference, reporting and analysis. Access can also import or link directly to data stored in other applications and databases.
Software developers and data architects can use Access to develop application software and power users can use it to build software applications to manage all areas of business.
MS Access can used for business and for personal information management..
Some business and personal uses include:
business information management
personal information management
queries - data reporting
manipulating data
custom designed programs where there is a need for database backend
create graphical user interface (GUI) front view to help users manipulate the data in the tables without accessing the tables directly which may cause confusion
the possibilities are enormous.....
* Number of hours should be used as a guide only. Actual duration will vary depending upon the skills, knowledge and aptitude of the participants. Hunter Business College are not responsible if the student enrols for a course higher than their level so if you are not sure which course/level to book into please contact us for advice. This duration also includes 1/2 hour lunch and 15 min morning and afternoon tea break.
There will be a maximum of 12 students per course and all courses require a minimum 4 students. Please contact us for a quote if you would like a class of less than 4 students at a reduced number of hours.
Hunter Business College will supply text books and working files. Students are to supply their own pens, notebooks and highlighters.
Access Introduction - Level 1
Prerequisite:
This course assumes little or no knowledge of spreadsheets or Microsoft Access 2010. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
At the completion of this course you should be able to:
- understand how Access is used and how to navigate around it
- design a database with lookup tables
- create a database structure using Access 2010
- modify the structure of an existing table
- add records to a new table
- add transactional records to a lookup database
- work with the records in a database table
- sort and filter records in a table
- create simple and effective queries
- create meaningful reports from tables
- create and use a variety of forms
If you don't know even some of these topics you should consider starting here. The tips and tricks you will learn will enhance your preparation for moving to Level 2 - Intermediate.
It is highly recommended that you complete the Introduction course before contemplating the Intermediate course.
Please contact us if you have any questions regarding which level is right for you.
Access Intermediate - Level 2
Prerequisite:
You must have completed Microsoft Access 2010 Level 1 Introduction to enrol in this course and be competent in the Windows operating system environment. If you feel that you have the necessary skills please follow the "Read more about this course" link below to the course outline and if there are any topics you don't know you should either begin at the previous level or contact our office to discuss your queries.
At the completion of this course you should be able to:
- use various data validation features in Access to protect data
- format the data in a table
- perform more advanced queries using a variety of querying techniques
- create and use parameter queries
- create calculated queries
- modify and adapt an existing form according to specific needs
- create and use macros in Access
- work with a number of macro techniques
- create macros on forms
If you don't know even some of these topics, and have completed the Level 1 - Introduction course, you should consider this course.
It is highly recommended that you complete the Level 2 - Intermediate course before contemplating the Level 3 - Advanced course.
Please contact us if you have any questions regarding which level is right for you.
Access Advanced - Level 3
Prerequisite:
You must have completed Microsoft Access 2010 Level 2 Introduction to enrol in this course and be competent in the Windows operating system environment. If you feel that you have the necessary skills please follow the "Read more about this course" link below to the course outline and if there are any topics you don't know you should either begin at the previous level or contact our office to discuss your queries.
At the completion of this course you should be able to:
- design a relational database project
- create a relational database file with multiple tables
- set table relationships and join tables together
- create queries based on one or more tables
- create and work with aggregation queries
- create and use a series of action queries
- work with a number of macro techniques
- create some simple programming code using VBA
This course is primarily designed for people who need to know how to develop relational databases and automate operations in Microsoft Access 2010.
If you don't know even some of these topics, and have completed the Level 2 - Introduction course, you should consider this course.
Please contact us if you have any questions regarding which level is right for you.