How to Use Microsoft Access - Beginners Course Deep Dive

This beginner course teaches how to build and manage a small Microsoft Access database. Learners create related tables, import spreadsheet data, customize fields and forms, query records, generate reports, and export database objects.

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.