Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Access 2021 Intermediate
Learn to use Microsoft Access to design and work with more advanced queries, forms, and reports.Preview the first lesson free — get full access to all 50 lessons.
Intermediate Provider : John Varan 10 chapters · 50 Lessons · 3h 58m in English
Course Description
An optimal database application requires a more refined and optimized design that goes beyond the basics. This course will teach you how to design better databases by accounting for elements such as calculated values and how to use the different normal forms of database normalization. Going beyond simple database design, you will learn how to build more efficient and useful database applications. Understanding the various types of database maintenance and how to use them will keep your database application running smoothly with peak performance.
In this course, you will learn about more advanced database design, including the various stages of database normalization, how to organize records, and different types and uses of field properties. You will explore how to use built-in functions, and get an overview of the various database maintenance tasks. We will cover more advanced features and designs in forms, queries, and reports, including how to work with external data sources.
What You'll Learn
- Design normalized databases using the first, second, and third normal forms of database normalization
- Organize records efficiently, including splitting records into tables and choosing the correct data type
- Work with external data sources and query external data
- Build advanced forms, queries, and reports using inner, outer, full, and cross joins and subqueries
- Apply built-in functions such as conversion, date and time, math, text, and financial functions
- Perform database maintenance to keep your database application running smoothly
Key Takeaways
- An optimal database application requires a refined, optimized design that goes beyond the basics, accounting for elements such as calculated values and the different normal forms of database normalization.
- The course covers advanced database design, including the stages of database normalization, organizing records, and the types and uses of field properties.
- Understanding the various types of database maintenance and how to use them keeps a database application running with peak performance.
- Learners explore advanced features and designs in forms, queries, and reports, including how to work with external data sources.
- The course introduces built-in functions, including conversion, date and time, general and financial, inspection, math, and text functions.
Frequently Asked Questions
Who is this course for?
This course is for learners who want to go beyond the basics of Microsoft Access and design better, more efficient, and more useful database applications using more refined and optimized design.
What will I learn in this course?
You will learn advanced database design including the stages of database normalization, how to organize records, types and uses of field properties, built-in functions, database maintenance tasks, and more advanced forms, queries, and reports, including working with external data sources.
What topics on database normalization does the course cover?
The course covers normalization including First Normal Form, Second Normal Form, and Third Normal Form, as well as splitting records into tables.
What types of joins and queries are taught?
The course covers querying with calculated values, subqueries, inner joins, outer joins, full joins, cross joins, and querying external data.
What skills does this course help develop?
It helps develop skills in Microsoft Access, database development, database management, database programming, Access query languages, and Microsoft Data Access Components.
