Microsoft ACCESS Database Hands-on Training with Exercises

Quick Learn MS ACCESS for beginners from scratch to design and develop real-world Database applications.

Created by: Dr. Mazhar Hussain
Deep Learning, Computer Vision, AI & Python | CS Lecturer

What Will I Learn?

• At the end of this Course, you will be able to create real-world DATABASE Applications in MS Access from scratch.
• You will learn how to import data from Excel to Access.
• You will learn how to define Tables, Attributes and Datatypes.
• You will learn the use of Lookup wizard, Validation rule and Input mask.
• You will learn how to establish Relationships between tables.
• You will learn how to create customized Forms for data entry into tables.
• You will learn how to write Queries to retrieve data as you want from tables.
• You will learn how to generate Reports from tables and queries to present the data in attractive and informative layout.
• You will learn how to export data from Access to PDF, Excel, Word etc.

Requirements

• You are required to install Microsoft Access on your computer.
• You do not need prior knowledge of Microsoft Access.

Target audience

• This Course is specifically designed for beginners who are passionate to learn Microsoft Access , so it can be an excellent starting point for anyone who wants to learn how to manage data effectively and efficiently
• Students and educators who want to learn how to manage student data, track attendance, and generate reports
• Researchers and analysts who need to manage large amounts of data and generate reports to inform their work
• Anyone who is interested in developing skills in database management and wants to enhance their employability in a variety of industries