Скачать с ютуб Build a Microsoft Access App for tracking sales orders в хорошем качестве

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