From the course: Access 2021: Queries

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

The Red30 Tech database

The Red30 Tech database

- [Instructor] Anytime I get started in a new database, I make sure to take a moment and explore the data that's available so that I can better understand what components I have to work with and to start thinking about the types of questions that I can ask given the data that's available. For this course, we'll be examining a database for Red30 Tech, a company that sells robots, drones, and other technology toys and related products. In the navigation pane on the left hand side of the interface you'll notice that we have several data tables that have already been established and hold all of the information about Red30 Tech, their customers and the products that have been ordered. To see what these are, let's start with the databases relationships view. You can find it by going to the databases tools ribbon and then clicking relationships. This will map out all of the different data tables, show us the fields or the…

Contents