MS Access 2016 Introduction
Description As a beginner, do you want to learn about MS Access? Are you interested to know its various function …
344 Students
Get access to 3000+ courses including this for a year only at £49. GET NOW
Save 0.00 % - Offer ENDS SOON
Access All Courses for Only £49
14-Day Money-Back Guarantee
-
1 Year
Access -
Level 2 - CertificateSkill Level -
3 hours, 1 minuteDuration
Access
Skill Level
DurationMS Access 2016 Introduction
Join thousands of learners building a successful career
Description
As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course.
The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the basic equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store date smoothly. It introduces you to numeric and index field with a plenty of practical exercises so that you can learn the basic of MS Access 2016 effectively.
Assessment:
This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.
Certification:
After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
MS Access 2016 Introduction is certified by CPD Qualifications Standards and CiQ. 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.
Requirements
Our MS Access 2016 Introduction 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.
Career Path
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.
Course Curriculum
-
Introduction 00:01:00
Introduction -
What is a Database? 00:03:00
-
Understanding Database terminology 00:05:00
-
Navigating the Access Interface 00:06:00
-
What is a flat file database 00:04:00
-
What is a relational database 00:09:00
-
Relating Tables 00:06:00
-
Reviewing the Access Ribbon 00:04:00
-
Working with Tables 00:04:00
-
Navigating Tables 00:02:00
-
Editing Data 00:03:00
-
Adding New Records 00:02:00
-
Using Subdatasheets 00:04:00
-
Understanding Database and Table Design Principles 00:10:00
-
Using Table Data Sheet View 00:04:00
-
Working with Field Data Types 00:04:00
-
Using Table Design View 00:04:00
-
Using Calculated Fields 00:04:00
-
Calculating Numbers 00:03:00
-
Calculating Dates 00:01:00
-
Calculating Strings 00:02:00
-
Using the Lookup Wizard 00:05:00
-
Editing Lookups 00:04:00
-
Using Indexes 00:02:00
-
What are Queries 00:03:00
-
Creating Simple Queries 00:05:00
-
Understanding the Dynaset 00:02:00
-
Entering Criteria: Exact Match and Range Operators 00:04:00
-
Understanding AND versus OR 00:03:00
-
Using Wild Cards 00:02:00
-
Using Keywords 00:03:00
-
Sorting and Hiding Fields 00:02:00
-
Creating Multi-Table Queries 00:03:00
-
Additional Tips 00:03:00
-
What are Reports 00:03:00
-
Understanding Report Types 00:03:00
-
Building Effective Reports 00:02:00
-
Using AutoReport 00:04:00
-
Understanding the Report Wizard 00:04:00
-
Using the Report Design View 00:08:00
-
Creating Labels 00:02:00
-
What are Forms 00:04:00
-
Understanding Form Types 00:02:00
-
Creating Forms 00:02:00
-
Navigating Forms 00:02:00
-
Editing Data in Forms 00:03:00
-
Understanding the Form Wizard 00:03:00
-
Using the Form Design View 00:04:00
-
Working with Controls 00:03:00
-
Using Form Layout View 00:02:00
-
Additional Tips 00:03:00
-
Course Recap 00:01:00
-
Resources – MS Access 2016 Introduction
-
Order Your Certificates and Transcripts
Frequently Asked Questions
Most courses do not require prior qualifications unless stated otherwise on the course page. Please check the individual course description for any specific entry requirements.
Learners must usually be 16 years or older to enrol. However, learners under 16 may join with parental or guardian consent.
Yes, if you do not pass the exam on your first attempt, you may retake the exam up to 3 times, depending on the course terms.
You will normally have 1 year of access to your course from the date of enrolment. Course duration may vary, and the estimated study time is mentioned on the relevant course page.
Yes, our courses are available worldwide. You can enrol and study from any country as long as you have an internet-connected device.
