From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Get to know the H+ Sport database
From the course: Access 2016: Forms and Reports
Get to know the H+ Sport database
- [Voiceover] When starting any new database project, it's really important to be familiar with the data table that we'll be working with. Throughout this course, we're gonna be taking a look at data from a company called H Sport, which manufacturers and sells a line of athletic clothing. In this database, we have various tables that store the information about the company's customers, employees, product feedback, orders, products, and the states and geographic regions that they do business. Let's take a look at the Orders table. I'm gonna double click on it to open it up. Inside the Orders table, we have columns for the OrderID. This is the primary key for the table. We also have a reference to the CustomerID for the customer that placed the order. We have a ProductID that'll link back to the product. The quantity ordered, the sales person that assisted with the order, as well as the order date and the status, whether it was completed or returned. Now, all of these ID numbers, the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.