Booking options
£18
£18
On-Demand course
3 hours 1 minutes
All levels
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.
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.
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.
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.
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.
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.
Introduction | |||
Introduction | FREE | 00:01:00 | |
Getting Started | |||
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 Data | |||
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 | ||
Creating Databases and Objects | |||
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 | ||
Working with Queries | |||
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 | ||
Working with Reports | |||
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 | ||
Working with Forms | |||
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 | ||
Conclusion | |||
Course Recap | 00:01:00 | ||
Resources | |||
Resources - MS Access 2016 Introduction | 00:00:00 | ||
Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |