Microsoft Office – Access 2016 is an online professional development course that will introduce you to database design and development concepts (including queries, forms and reports) using existing data.
In this online Microsoft Access course, you will learn the fundamentals of creating core objects of a database, data manipulation and extraction at an introductory level.
Throughout the course, you will learn how to design databases to meet organisational and task requirements. You will also learn how to test and finalise databases and analyse the effectiveness of data relationships.
This course is ideal for those employed in a range of work environments who create databases to store and retrieve data using Microsoft Access 2016.
Course Structure
Unit 1 - Design databases Using 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
Unit 2 - Operate database applications Using Access 2016
- 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
Assessment
Assessment Information
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.
Course FAQs
Why Choose Australian Online Courses?
- 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.
How long will it take to complete this course?
The approximate study hours for this course is 30 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).
Can I purchase optional printed materials?
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.
When can I start this course?
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.
Will I receive a certificate upon completion of this course?
Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.
Do I need to attend classes or undertake any work placements?
No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.
What support can I expect from Australian Online Courses?
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.
I am an international student. Can I enrol into this course?
Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.
Career Pathways
Future growth
Strong
Unemployment
Low
Professional development for:-
Individuals working in small, medium and large organisations who need to produce professional documents and work with spreadsheets and databases.