Candidates who complete this course and envisage to take the Microsoft Office Specialist: Access Expert exam, demonstrate knowledge, understanding and skills in database design principles on an expert level. The exam covers the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry expert-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Access and can complete tasks independently.

What will you learn in this Microsoft Office Specialist in Access 2019: Expert course?

This course is suitable for those who want to learn about databases and how they work. You will learn about Microsoft Access’s complex inner workings:

Manage Databases
Create and Modify Tables
Create and Modify Queries
Modify Forms in Layout View
Modify Reports in Layout View

By doing this course, you will understand database design principles on an expert level and will be able to complete tasks without assistance. You will be able to demonstrate the correct application of the key features of Access 2019 and demonstrate the ability to manage databases, create and modify tables and queries and modify forms and reports in the layout view.

What is included in the course fees?

This Course Fee includes your Certiport exam voucher. You can locate your closest Certiport here: www.certiport.com/Locator#.

Please, be aware that  all course materials are only offered online. In other words, you will not be receiving any hard copies of the textbook, and you will need to access all the required content through your online classroom, where you'll be able to find the following course content:

A digital textbook (PDF) focused on all the content you'll need to pass the exam successfully
Videos and Learning material to ensure you are coveredto understand practical concepts
Learning objectives and skills covered in each lesson
A glossary of key terms for each lesson
A summary of what you will learn, as well as the important points on which to focus
Practice files OR quizzes to accompany the step-by-step exercises in your textbook
A PDF summary of everything you've covered in the textbook
A study guide and exercise files to help you with your exam prep
A set of mock exams to be covered before undertaking global exams.

Requirements

Entry Requirements

Grade 10
Learners must be 16 years or older
The ability to read and write in English
Access to a computer (PC or Mac)
Access to the internet
Computer literate (familiar with operating a computer)

Completion Requirements:

To pass this course, you must write and pass Exam 77-726: Word 2016 Core (https://www.microsoft.com/en-us/learning/exam-77-726.aspx).

Hardware Required

1 gigahertz (GHz) or faster x86-bit or x64 -bit processor with SSE2 instruction set
2 GB RAM
3.0 GB available disk space
1280 x 800 screen resolution
Graphics hardware acceleration requires a DirectX 10 graphics card

Software Required

You will need to have access to the following pieces of software depending on the pathway you're following:

Windows 10, Windows 8.1, Windows 8, Windows 7 Service Pack 1, Windows 10 Server, Windows Server 2012 R2, Windows Server 2012, or Windows Server 2008 R2. For the best experience, use the latest version of any operating system
The current or second most recent version of Internet Explorer, Safari, Chrome, Firefox, or Microsoft Edge
.NET 3.5 required. Some features may require .NET 4.0 or 4.5 CLR also to be installed
A PDF reader:
- PC/Mac - Adobe Reader or Foxit Reader are good examples
- iPhone - Reader or Adobe Reader
- Android - Xodo, Moon+ Reader, Adobe Reader, or Foxit
- An image viewer - most devices will come with a built-in image viewer
Microsoft Access 2016

The programmes in this Suite are the same as Microsoft Oﬃce 2016, but they may be updated more regularly and, therefore, have some diﬀerences.

Exam Dates

You can start studying whenever you want - there are no specific course starting dates.

All of our assessments are computer-based and, therefore, done online. You are required to book an exam appointment via our Campus Assessment Centre at least 2 weeks prior to your exam date to prepare for your assessment. Please speak to our Educational Planners about your enrolment and study options.

Accreditation

Status: Accredited course

Type & reward: Microsoft Oﬃce Specialist - Microsoft Certificate

Provided by: Microsoft

Minimum credits: N/A

Edu City Campus is a registered provider of Microsoft training programmes. Microsoft is an industry leader in technological development and sets the de facto standard worldwide. They oﬀer internationally recognised information technology certifications which provide valuable knowledge needed to begin or expand a career in information technology and development. They continuously update and develop their study programmes to keep up with technological advances, and they ensure that the exams are relevant to the IT industry. Microsoft Oﬃce certifications are sought after, trusted by employers, and validate your knowledge of computer systems, security or software development.

Assessment

You will be provided with the necessary study material so that you can prepare for your external exam. These exams are Computer-Based Assessments and are held at a registered Certiport Assessment Centres. You will need to contact any one of the Certiport Solutions Providers to purchase your exam voucher.

You can locate one closest to you here: http:// www.certiport.com/Locator#.

Once you have located the Certiport Authorised Testing Centre (CATC) closest to you, you will need to contact them to purchase your exam voucher and schedule your exam.

Please ensure that your chosen centre is set up to administer your exam. Once you have successfully completed the exam, your Certiport Testing Centre will provide you with an exam score report, which will also be available to you on your Certiport profile. You will then receive your Microsoft Certification.

Please contact us on studyonline@ecubeonline.com for assistance.

Subjects:

Subjects are the particular fields of study that are covered in a course. The subjects below make up this course and will need to be completed in order for you to complete this course.

Manage Databases
Create and Modify Tables
Create and Modify Queries
Modify Forms in Layout View
Modify Reports in Layout View

Microsoft Office Specialist Access 2019 Proficient

In this module you will learn the core concepts of Microsoft Access 2016 on an expert level; you will have knowledge, understanding and skills which include creating and managing databases, building tables, creating queries and forms. Also, you will have a good understanding of how to navigate in the Microsoft Office Access application and make proficient use of its tools.

Enquire Now

Collaborations and Partnerships

Our global online learning platform, eCube Online, has taken our education off-site to the world. We secured global partnerships with Durham University, the Entrepreneurship Institute, Genius U, as well as being a registered Microsoft Showcase School and host of the only registered annual Microsoft Marathon in the Eastern Cape. These collaborations together with cutting edge technology facilities available at the campus, and a value system aligned with the UN’s 17 self sustainable goals, are the core strength and focus which grounds our private education institution, E-Square Education.