Introduction to Microsoft Access 2016 (Self-Paced Tutorial) Online Certificate Course
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information
NOW ONLY
US$149
Save US$550 (79%)OFF RRP US$699
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information
Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
Course Fast Facts:
- Learn the fundamentals of Microsoft Access
- Comprehensive 12 module Introduction to Microsoft Access 2016 (Self-Paced Tutorial) Online Certificate Course
- Study along with simple instructions & demonstrations
- Written and developed by leading Microsoft Access experts
- Receive one-on-one online help & support
- Certificate of completion awarded with passing score for the online assessment
- Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device
Course Delivery
Courses are accessed online by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device.
Recognition & Accreditation
All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.
Lesson 1 - Getting to Know Access 2016
In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.
Lesson 2 - Controlling Your Access Table Fields
It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that only allow certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-free.
Lesson 3 - Creating Tables and Relationships
In this lesson, you'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.
Lesson 4 - Building Powerful Forms
In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and allows you to select one or more tables' fields to include. You'll also determine the form layout.
Lesson 5 - Adding Versatility to Forms
In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.
Lesson 6 - Interviewing Your Database
Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. You'll follow instructions step by step so you gain confidence with the process, and then you'll get to create a query on your own!
Lesson 7 - Taking Queries to the Next Level
A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.
Lesson 8 - Multi-Table Query Control
In this lesson, you will learn to plan, build, and use queries that pull data from multiple tables simultaneously. This gives you more power over your data and allows you to build the foundation for truly customized reports.
Lesson 9 - Reporting on Your Tables
Reports are easy to create and customize. In this lesson, you will build a simple report using the Report Wizard. Then you will change the report's appearance, using layout view and design view. These skills are foundational to creating and designing reports for any data in your database.
Lesson 10 - Creating Query-Based Reports
In this lesson, you will create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria.
Lesson 11 - Mastering Report Design
In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.
Lesson 12 - Automating Your Database With Macros
Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Minimum specifications for the computer are:
Windows:
- Microsoft Windows XP, or later
- Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome)
All systems
- Internet bandwidth of 1Mb or faster
- Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)
Students will also need access the following applications:
Adobe Acrobat Reader
Note: This course is not suitable for Macintosh users.
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.
After you have completed payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
This is a self-paced course that can be started at anytime as long as you have internet access and a computer.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.
Individual courses are very comprehensive and can take up to 24 hours to complete.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 24 hours = 48 hours
- 3 course bundle is 3 x 24 hours = 72 hours
- 5 course bundle is 5 x 24 hours = 120 hours
- 10 course bundle is 10 x 24 hours = 240 hours
Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.
The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and potential employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
 |
About this Course |
 |
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information
Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
Course Fast Facts:
- Learn the fundamentals of Microsoft Access
- Comprehensive 12 module Introduction to Microsoft Access 2016 (Self-Paced Tutorial) Online Certificate Course
- Study along with simple instructions & demonstrations
- Written and developed by leading Microsoft Access experts
- Receive one-on-one online help & support
- Certificate of completion awarded with passing score for the online assessment
- Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device
Course Delivery
Courses are accessed online by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device.
Recognition & Accreditation
All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.
Lesson 1 - Getting to Know Access 2016
In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database.
Lesson 2 - Controlling Your Access Table Fields
It's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that only allow certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-free.
Lesson 3 - Creating Tables and Relationships
In this lesson, you'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database.
Lesson 4 - Building Powerful Forms
In this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and allows you to select one or more tables' fields to include. You'll also determine the form layout.
Lesson 5 - Adding Versatility to Forms
In this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table.
Lesson 6 - Interviewing Your Database
Using queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. You'll follow instructions step by step so you gain confidence with the process, and then you'll get to create a query on your own!
Lesson 7 - Taking Queries to the Next Level
A query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database.
Lesson 8 - Multi-Table Query Control
In this lesson, you will learn to plan, build, and use queries that pull data from multiple tables simultaneously. This gives you more power over your data and allows you to build the foundation for truly customized reports.
Lesson 9 - Reporting on Your Tables
Reports are easy to create and customize. In this lesson, you will build a simple report using the Report Wizard. Then you will change the report's appearance, using layout view and design view. These skills are foundational to creating and designing reports for any data in your database.
Lesson 10 - Creating Query-Based Reports
In this lesson, you will create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria.
Lesson 11 - Mastering Report Design
In this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data.
Lesson 12 - Automating Your Database With Macros
Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Minimum specifications for the computer are:
Windows:
- Microsoft Windows XP, or later
- Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome)
All systems
- Internet bandwidth of 1Mb or faster
- Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)
Students will also need access the following applications:
Adobe Acrobat Reader
Note: This course is not suitable for Macintosh users.
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.
After you have completed payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
This is a self-paced course that can be started at anytime as long as you have internet access and a computer.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.
Individual courses are very comprehensive and can take up to 24 hours to complete.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 24 hours = 48 hours
- 3 course bundle is 3 x 24 hours = 72 hours
- 5 course bundle is 5 x 24 hours = 120 hours
- 10 course bundle is 10 x 24 hours = 240 hours
Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.
The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and potential employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
We provide a 7 Day Money Back Refund on all Courses
Special Offer
|
Training 2 Or More People?
| Empower your business with access to 500+ job & soft skills online training courses. |
|
SUCCESS PRO - For Business |
Course Summary
| Course ID: | 007IMSA16SP |
|---|---|
| Delivery Mode: |
Online |
| Access: | 3 months |
| Tutor Support: | Yes |
| Time: | 40 Hours |
| Duration: | 24 Hours |
| Assessments: | Yes |
| Qualification: | Certificate of Completion |
- Call +1 845-764-9167
- Chat to us live
- Send us an enquiry
- Print this course page
