In this step-by-step tutorial, learn how to use Microsoft Access. We walk what Access is for, why you should use it over a spreadsheet, how to create tables, how to add a form, how to run SQL queries, and how to create a report. By the end of this video, you’ll understand the fundamentals of working with databases in Access.

⌚ Timestamps
0:00​ Introduction
1:01​ Advantages of a database over Excel
2:36​ Access alternatives
3:17​ Overview of tutorial structure
4:10​ Access start page
5:04​ Create blank database
5:22​ Tables, fields & records
14:36​ Calculated field & expression builder
15:50​ Sample order data
16:50​ Opening & closing windows
17:16​ Relationships
19:01​ Import data sources
19:25​ Forms
22:12​ Queries
27:51​ Reports
30:02​ Save Database
30:25​ Wrap up

👋 Additional resources:

• My Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-O… ​

Subscribe: https://www.youtube.com/channel/UCfJT_eYDTmDE-ovKaxVE1ig

#microsoft