Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Access 2016 Introduction
Learn how to create and use a database, along with design fundamentals.Preview the first lesson free — get full access to all 59 lessons.
Beginner Provider : Stephanie Hutslar 10 chapters · 59 Lessons · 4h 49m in Arabic, English, Spanish
Course Description
For those in search of a reliable database management system, Microsoft Access often represented the optimal solution. This online employee training course provides an introduction to the basic fundamentals of the new, Access 2016 update. This course teaches how to create and join tables as well as how to navigate and create queries, forms, and reports. Discover why Microsoft Access endures as the go-to application for relational databases, data analysis, and reporting.
What You'll Learn
- Create and join tables and set data types in Table Design View
- Build and navigate queries, forms, and reports in Access 2016
- Establish relationships between tables and work with field properties
- Enter, sort, filter, and modify table data, including in a subdatasheet
- Prepare and apply data validation when structuring tables
- Use the Tell Me and Help features and back up the database
Key Takeaways
- Microsoft Access is presented as a reliable database management system and the go-to application for relational databases, data analysis, and reporting.
- This course introduces the basic fundamentals of the Access 2016 update.
- The course teaches how to create and join tables and how to navigate and create queries, forms, and reports.
- Lessons cover navigating the interface and objects, creating files, trust locations, and backing up the database.
- The course covers table terminology, field properties, data validation, and creating relationships between tables.
Frequently Asked Questions
What does this Access 2016 Introduction course cover?
It provides an introduction to the basic fundamentals of the Access 2016 update, teaching how to create and join tables and how to navigate and create queries, forms, and reports. It also covers the interface and objects, file creation, trust locations, backing up the database, table terminology, field properties, data validation, and creating relationships between tables.
Who is this course for?
It is an online employee training course for those in search of a reliable database management system who want an introduction to Microsoft Access 2016.
What skills will I gain from this course?
The course develops skills in Microsoft Access, Database Management, Data Access, Access Query Languages, Microsoft Data Access Components, and SQL 2016.
Why does the course recommend Microsoft Access?
It explains why Microsoft Access endures as the go-to application for relational databases, data analysis, and reporting.
