Booking options
£25
£25
On-Demand course
2 hours 7 minutes
All levels
You have a basic knowledge on MS Access 2016, besides you want to know more about it to use in your practical life, but you don't know how to work on it and which course is effective for your learning. Don't worry. To become better at MS Access, take a look at our MS Access 2016 Intermediate course. It will assist you to reach your need.
The course designs in such a way that will assist you to learn the fundamental issues of MS Access including information gathering, data analysis, and proper management of the relevant information system. The MS Access 2016 Intermediate course helps you to make table chart for justifying the accuracy of data entry, learn automation system, and insert charts and column. The course aims at the clear understanding and functioning of Word and Excel, adding and deleting table data, reviewing the advanced searching techniques; Parameter queries, Crosstab queries and working with total and other different techniques of report and form regarding Tab controls, sub-Forms, Combo Box controls, Sub-reports, and column.
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 Intermediate 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 Intermediate 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 | |
Designing Tables for Better Data Entry | |||
Reviewing Table Design Principles | 00:04:00 | ||
Setting Field Size, Formats and Captions | 00:06:00 | ||
Setting Default Value and Required Fields | 00:03:00 | ||
Restricting Data Entry Using Data Validation | 00:02:00 | ||
Restricting Data Entry Using Input Masks | 00:06:00 | ||
Sharing Data with Other Applications | |||
Exporting Tables and Queries to Excel | 00:03:00 | ||
Importing Data from a TXT File | 00:03:00 | ||
Importing Data from Excel | 00:02:00 | ||
Exporting Data to a TXT File | 00:02:00 | ||
Linking External Data Sources | 00:03:00 | ||
Using Word Merge | 00:02:00 | ||
Working with Action Queries | |||
What are Action Queries | 00:00:00 | ||
Creating an Update Query | 00:02:00 | ||
Creating an Append Query | 00:03:00 | ||
Creating a Delete Query | 00:02:00 | ||
Creating a Make Table Query | 00:02:00 | ||
Changing the Start Number of an Auto Number Field | 00:03:00 | ||
Advanced Query Techniques | |||
Creating Query Joins | 00:05:00 | ||
Creating Find Unmatached and Find Duplicate Queries | 00:03:00 | ||
Creating Parameter Queries | 00:08:00 | ||
Using -Like- Keyword in Parameter Queries | 00:02:00 | ||
Creating a Top X Query | 00:01:00 | ||
Reviewing Calculated Query Fields | 00:03:00 | ||
Summarizing Query Data with Totals | 00:02:00 | ||
Inserting Where Statements in Summary Queries | 00:01:00 | ||
Creating a Crosstab Query | 00:03:00 | ||
Automating Processes with Macros | |||
Understanding Macro Basics | 00:06:00 | ||
Creating Macros to Open Forms by Record | 00:04:00 | ||
Validating Data Entry with Macros | 00:04:00 | ||
Creating a Macro to Automate Data Entry | 00:04:00 | ||
Advanced Data Entry Using Macros and DLOOKUP Function | 00:06:00 | ||
Advanced Form | |||
Using Conditional Formatting | 00:02:00 | ||
Organizing Form Fields with Tab Controls | 00:03:00 | ||
Creating a Combo Box Control | 00:02:00 | ||
Creating an Option Group Control | 00:03:00 | ||
Using a Subform to Show Data from a Related Table | 00:03:00 | ||
Advanced Report Techniques | |||
Inserting a Chart on a Report | 00:03:00 | ||
Showing Data in Columns | 00:02:00 | ||
Inserting a Subreport | 00:02:00 | ||
Configuring Reports with Parameter Queries | 00:04:00 | ||
Sending Reports | 00:02:00 | ||
Conclusion | |||
Course Recap | 00:00:00 | ||
Resources | |||
Resources - MS Access 2016 Intermediate | 00:00:00 | ||
Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |