Dive deep into Microsoft Access with this comprehensive beginners course. Learn to set up and customize table fields, import Excel data, create one-to-many relationships, design forms with controllers and drop-downs, craft specific queries, generate reports based on queries, and export data. Master essential skills like creating blank databases, adding records, customizing form appearances, implementing combo boxes and command buttons, sorting tables, and utilizing parameters and wildcards in queries. Gain practical experience with provided Excel practice files and explore Microsoft query examples to enhance your database management capabilities.
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
