Play all

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

Description:

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

Teacher's Tech

Add to list

#Business #Business Software #Microsoft Office 365 #Microsoft Access #Computer Science #Database Management

0:00 / 0:00