Build a Microsoft Access App for tracking sales orders

Microsoft Access Crash course will show you how to build a database with forms, queries, tables and reports. See http://studycoding.org for all tutorials by Shad Sluiter.
Create a sales application that tracks products, customers and orders. This course will help you learn MS Access in about one hour.

Index
0:00 Preview of the app
1:50 Start Access and create a customers table
3:20 Create columns in a table
5:08 Enter data into a table
7:00 Delete data from a table
7:30 Create a data entry form
10:10 Create a table for vendors
11:55 Create form for vendors
12:20 Create a products table
15:45 Create a foreign key relationship
17:25 View table relationships
18:30 Add products to the table. Show supplier foreign key relation
20:00 Create a form for vendors
20:40 Create form with subforms
22:00 Create invoices
23:20 Create an invoice table with foreign key relationships
25:30 Show table relationships with invoices
26:40 Create invoice details table
29:10 Show many to many relationship between tables
30:10 Create invoice form with order details subform
32:00 Create a new purchase event
33:30 Create a calculated field
37:00 Show subtotal of an order
44:20 Create a SQL query
47:00 Create a report
47:50 Create a main menu navigation form