Join Adam Wilbert for an in-depth discussion in this video Writing queries in Access, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…I've gone ahead and filled in some data into…the tables that we created in the last movie.…Now I want to show you how the database uses what it knows…about our tables and their relationships to give us some useful information.…First, I want to take a look at this Line Items table here.…We can see that the Line Item is storing…an InvoiceID number, that's a reference to our Invoices table.…It's storing the Line Item so the number…on the invoice, it's storing the ProductID, which again…refers to a product in our Products table,…and it's storing the quantity that has been ordered.…Now, we have all of this data but…it doesn't really convey any true information to me.…
For instance I really want to know who placed the order and I'd…like to also know which products were ordered, not just some ID number.…So let's go ahead and take a look at how we can use something called a…query inside of Access to start building out…a data table that meets my specific needs here.…Let's go ahead and close the Line Items table and to create a…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.