Learn how to use Microsoft Access effectively in this beginner's course. By the end of the course, you will be able to set up and customize fields in tables, import data from Excel, create relationships between tables, design forms with various elements, execute specific queries, generate reports, and export data. The course employs a tutorial-style approach with practical examples and hands-on exercises. This course is designed for beginners who want to enhance their skills in Microsoft Access.
How to Use Microsoft Access - Beginners Course Deep Dive
Overview
Syllabus
Introduction.
Why use Microsoft Access .
Create a blank database.
Create a table and add fields for students.
Add a record to the student table.
Import data from excel spreadsheet into a created table.
Import data from excel spreadsheet into a new table.
Create a relationship between tables (one to many).
Customize table fields in Microsoft Access.
Create a form.
Create a form with the form wizard.
Customize the look of your form.
Add a combo box to your form.
Add an image to your form.
Add command buttons to your form in Microsoft Access.
Add a record with your form.
Using Sort in your tables.
Creating queries in Microsoft Access.
Adding criteria to your query.
How to use parameters and wildcards in your queries.
Using the greater, less than or equal in the criteria .
Create a report form a query.
Export tables, forms queries, and reports.
Taught by
Teacher's Tech
