Microsoft Access
Learn to Create Databases and Reports
0h 0m8 lectures1 sections
What you'll learn
- Understand Microsoft Access interface
- Create tables and their properties
- Design relationships between tables
- Prepare queries and forms
- Manage report settings
- Use databases effectively
About this course
This course takes you step by step to learn how to manage databases using Microsoft Access, one of the most popular relational database design and management programs. You will learn to design tables and create relationships between them, as well as how to create queries, perform calculations, and build data entry forms and various reports. Additionally, you will discover how to link different database elements using macros and navigation forms.
Expected outcomes
- Ability to create and manage databases using Access.
- Design professional forms and reports.
- Analyze data using queries and table relationships.
- Create an interactive main menu to facilitate database use.
Course content
1Learning Microsoft Access
8 lectures
- Adjusting the Program Interface19:48
- Creating Tables21:13
- Adjusting Field Properties20:33
- Creating Relationships22:01
- Creating Queries30:50
- Creating Forms21:55
- Creating Reports12:58
- Creating the Main Menu13:05
Instructor
Ahmed Hassan Khamis
26K students39 courses
This course is part of the diploma
