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.
- Additional resources:
- My Access database: https://1drv.ms/u/s!AmxrofZZlZ-whKx-O…
- 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
Kevin Stratvert 
I am trying to build an Access Database and just having all types of issues with relationships between tables. It is not a straightforward database, well not to me. I am just learning Access, just watched your video.
I have a table for my employees with an employee # each, a table for all rooms and buildings by a given room #. The employees are assigned to one or many of these rooms. I have tables for computers, projectors, printers, all devices have asset tags and S/N. Most devices are assigned to the rooms, but many are assigned to the employees. Can you make an advanced video with Access, emphasizing the relationship part?
LikeLike