Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Access 2021 Beginner
Learn the fundamentals of databases and how to use Microsoft Access 2021 to design and create effective databasesPreview the first lesson free — get full access to all 50 lessons.
Beginner Provider : John Varan 10 chapters · 50 Lessons · 3h 51m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
A good database application starts with a solid understanding of database fundamentals and design. This course on Microsoft Access 2021 Beginner will teach you how a database works and how to create an efficient, industry-standard compliant database design using Microsoft Access 2021. We will explore how to customize tables with the properties offered by Microsoft Access 2021, and you will learn how to design and create the four main types of queries - select, insert, update, and delete. You will also learn how to create and modify custom forms to turn your database into a full-fledged database application.
In this Microsoft Access 2021 Beginner course, you will learn what databases are and the user interface of Microsoft Access 2021. You will also learn how to install Microsoft Access 2021 and learn the basics of using Microsoft Access 2021 to design a good database implementation, create and edit tables, and create and design your own queries, forms, and reports.
What You'll Learn
- Purchase, download, and install Microsoft Access 2021
- Create a new database, tables, and fields in Microsoft Access 2021
- Manage records, including adding, editing, and deleting them
- Design and create queries, forms, and reports
- Configure database, table, and field properties to customize tables
- Define table relationships, including one-to-one, one-to-many, and many-to-many
Key Takeaways
- A good database application starts with a solid understanding of database fundamentals and design.
- The course covers the four main types of queries: select, insert, update, and delete.
- Custom forms can be created and modified to turn a database into a full-fledged database application.
- The course explains how Microsoft Access differs from a traditional RDBMS.
- Tables can be customized using the database, table, and field properties offered by Microsoft Access 2021.
Frequently Asked Questions
Who is this course for?
This is a beginner course on Microsoft Access 2021, suited for learners who want to understand how a database works and how to create an efficient, industry-standard compliant database design using Microsoft Access 2021.
What will I learn in this course?
You will learn what databases are and the user interface of Microsoft Access 2021, how to install it, how to design a good database implementation, create and edit tables, and create and design your own queries, forms, and reports.
Does the course cover installing Microsoft Access 2021?
Yes. The course teaches you how to purchase, download, and install Microsoft Access 2021, and includes lessons on installing Access and on Microsoft 365 and Microsoft Accounts.
What types of queries does the course teach?
The course teaches how to design and create the four main types of queries: select, insert, update, and delete, and covers the Query Wizard, Query Designer, and SQL.
What skills will I gain from this course?
You will gain skills in Access Query Languages, Data Access, Database Programming, Microsoft Access, Microsoft Data Access Components, and Microsoft Forms.
