Level 3 Diploma in Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. It stores data in its format based on the Access Jet Database Engine. Through this course, you will learn from beginner, intermediate, and advanced level skills, knowledge, and information about Microsoft Access 2013. You will then know the different components of the database so that you understand the structure underlying your data to know data manipulation and user control.

Why choose us?

• Study in a user-friendly, advanced online learning platform;
• All the study materials are available in your student portal including videos tutorials.
• One of the most successful online education platforms in the UK.
• Affordable, engaging & high-quality e-learning study materials;
• You will have unlimited access to online learning platform in 24 hours a day, 7 days a week in 12 Months.
• Efficient exam systems for the assessment and instant result;
• The UK & internationally recognised accredited qualification;
• Access to course content on mobile, tablet or desktop from anywhere anytime;
• The benefit of applying for NUS Extra Discount Card;
• 24/7 student support.
• Technical supports and live chat service for your inquiries. This is very helpful for international learners.
• Excellent and flexible mentor supports by our team of experienced tutors/trainers via email.

COURSE CURRICULUM

Microsoft Access Essentials

• Module One – Getting Started
• Module Two – Opening and Closing Access
• Module Three – An Introduction to Databases
• Module Four – Sharing Data Using Apps
• Module Five – Working in Your App
• Module Six – An Introduction to Desktop Databases
• Module Seven – Performing Basic Table Tasks
• Module Eight – Working with Fields
• Module Nine – Working with Table Relationships
• Module Ten – An Introduction to Queries, Forms, and Reports
• Module Eleven – Protecting Your Data
• Module Twelve – Wrapping Up
• Activities – Microsoft Access for Beginners

Microsoft Access Expert

• Module One – Getting Started
• Module Two – Creating a Custom App
• Module Three – Customizing App Actions
• Module Four – Customizing Your App Views with Macros
• Module Five – Working with Validation Rules and Messages
• Module Six – Working with Macros
• Module Seven – Advanced Query Tasks
• Module Eight – Designing Forms
• Module Nine – Advanced Reporting Tasks
• Module Ten – Advanced Database Tools
• Module Eleven – Working with the Access Environment
• Module Twelve – Wrapping Up
• Activities – Microsoft Access Intermediate Level

Microsoft Access Advanced

• Module One – Getting Started
• Module Two – Using App Views
• Module Three – Customizing Apps, Part One
• Module Four – Customizing Apps, Part Two
• Module Five – Working with More Record Tasks
• Module Six – Using Advanced Field Tasks
• Module Seven – Working in Table Design View
• Module Eight – Working with the Expression Builder
• Module Nine – Working with External Data
• Module Ten – Creating Queries
• Module Eleven – Creating Forms and Reports
• Module Twelve – Wrapping Up
• Activities – Microsoft Access Advanced Level

John Academy: A Great Place to Learn for Everyone, Forever

Expert Authors: We select authors with expertise and experience of training professionals. Our authors are industry experts, academics, authors, face-to-face trainers or online trainers; most often they have a combination of these backgrounds

Engaging Content: Our succinct, bite-sized and business-focussed course materials are designed to deliver the most effective training for you. Each course is made up of modules, manageable learning chunks of text, images, videos and tasks.

Assessment and Certification:

Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £24 for a PDF copy and £39 for an original print copy sent to you by post.

• New staff or workers who want to learn about the Microsoft Access 2013
• People who have an interest in the basics and features of the Access 2013

• This course is available to all learners, of all academic backgrounds.
• Learners should be aged 16 or over to undertake the qualification.
• Good understanding of English language, numeracy and ICT are required to attend this course.

The Level 3 Diploma in Microsoft Access course is a useful qualification to possess and would be beneficial for following careers:

• Software Engineer
• Technical Support
• Technical Sales
• Business Analyst
• Web Developer
• Software Tester.

Currently there are no Q&As for this course. Be the first to ask a question.