Microsoft Access 2016 for Beginners

This Microsoft Access 2016 for Beginners will provide you the knowledge of how to Access is constructed and how to use the major objects within it. It allows you to create and manage database for all sorts of different purposes. It will help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases general.

If you have the general knowledge of working with windows and want to improve your knowledge more you are welcome to join this course.

Learning Outcomes:

• Get familiarized with Microsoft Access 2016, create simple databases, and use the help options
• Change table data, manage records, and create lookups
• Join data from different tables, sort and filter them, and perform calculations for queries
• Creating, adding controls, enhancing appearance and print preparation for reports
• How to utilize Access Options dialog box
• Relational database design, creating tables, managing table fields and creating table relationships
• Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets
• Data normalization and creating junction tables
• Sharing Access data with other applications and through import and export options
• Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones
• Create mailing label report and publishing reports in PDF format

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

Getting Started with Access

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access

Working with Table Data

• Modify Table Data
• Work with Records
• Sort and Filter Records
• Create Lookups

Querying a Database

• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query

Creating Advanced Queries

• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data

Generating Reports

• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• Prepare a Report for Print

Customizing the Access Environment

• The Access Options Dialog Box

Designing a Relational Database

• Relational Database Design
• Create a Table
• Modify a Table and Fields
• Create Table Relationships

Joining Tables

• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries

Organizing a Database for Efficiency

• Data Normalization
• Create a Junction Table

Sharing Data Across Applications

• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge

Advanced Reporting

• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report 12

Additional Reporting Options

• Create a Mailing Label Report
• Publish a Report as PDF

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.

Microsoft Access 2016 for Beginners is certified by CPD Qualifications Standards and IAO. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Our Microsoft Access 2016 for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

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