Microsoft Office – Access 2016

• Design database
• Task requirements
• Relational databases
• Normalisaton of data
• Forms
• Logical data model
• Data types
• Functionality of databases
• Using Microsoft Access
• Basic operations
• Set field attributes
• Linking databases
• Creating a database
• Creating tables
• Database tools
• Naming conventions
• Primary key
• Foreign keys
• Software functions
• Formulae
• Develop queries
• SQL statements
• Input screens
• Custom buttons
• Macros
• Reports
• Sample data set for testing
• Data effectiveness

• Create database
• Basic design principles
• Saving databases
• Database types
• Access data types
• Modify tables
• Fields
• Creating primary keys
• Establish index
• Table relationships
• Customise basic settings
• Adjusting page layouts
• Toolbars
• Format painter
• Text formatting
• Create tab
• External Data tab
• Database Tools tab
• Create reports
• Report Wizards
• Create forms
• Form Wizard
• Rearrange objects
• Retrieve information
• Filter records

When you study with Australian Online Courses, you will be assessed using a competency-based training method.

Competency-based training focuses on the achievement of skills and knowledge against set criteria to meet industry-standard and is not benchmarked against other students’ work.

In this course, the assessment will be comprised of written assignments and exercises, which may include short answer questions, reports, essays, research projects and reflective tasks.

If you do not achieve a competency result on your first attempt, you have two more attempts to pass your assessment. So, you have three attempts in total to obtain a competency result.

In this way, you can complete your course in your own time and at your own pace with the assistance of unlimited tutor support.

• Professional development that is widely recognised and respected;
• Improve your employment opportunities;
• Study online, anywhere via our elearning system;
• High-quality professional development programs written by industry experts;
• No entry requirements;
• All course materials provided online – no textbooks to buy;
• Unlimited tutor support;
• Easy to understand course content;
• We offer twelve (12) months’ access, with extensions available upon application (fees apply);
• Certificate of Attainment/Completion issued for your CV (hard copy provided); and
• Course may be tax deductible; see your tax advisor.

The approximate study hours for this course is 30 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).

Yes! The cost for printed materials for this course is $50 per unit. Total cost for optional printed materials is: $100.00. Printed materials are optional and not required to complete the course. Everything you need to complete the course is provided online via our e-learning system.

You can start within 60 minutes during business hours when you enrol and pay in full with a credit card!

Credit card: Within 60 mins during business hours.

BPAY: Within 1-2 working days.

Internet Banking: Within 1-2 working days.

Cheque/Money Order: Upon receipt of mailed cheque.

Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.

No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.

Unlimited tutor support is available throughout your studies via email during business hours Monday to Friday. Our Administrative team are available Monday to Friday via email, live chat and telephone.

Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.