Creating Queries in Design View gives you complete power and flexibility in…analyzing your data.…Let's start with looking at the query that we already made.…Right-click on the Sales Reps Phone List Query and choose Design View.…The top part of the window is where you show your tables with their fields, and…the bottom is the grid where you specify the fields you want to see.…So here is our Sales Rep table, with all of its fields, and the grid below, with…just the five fields we wanted to see.…If it asks if you want to save the changes, say No.…So let's take this a step further.…

Let's make a Query to analyze our sales in Maryland.…We would need to pull our Maryland customers and look at their orders.…Here's how to do it.…Click on the Create tab and then choose Query Design.…We'll get a new blank Query.…The first thing we need to do is add our tables to the query.…Now when you're doing this, only add the tables that contain the fields that you need.…If you add extra tables here, it can distort your results.…

Resume Transcript Auto-Scroll

Author

Released

6/10/2010

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Topics include:

Understanding database concepts and terminology

Building tables with Application Parts

Defining field properties

Creating relationships between fields and tables

Sorting and filtering

Creating forms with the Form Wizard

Analyzing data with the Query Designer

Automating with macros

Formatting reports with Layout Tools

Skill Level Beginner

3h 30m

Duration

3,555,711

Views

Show MoreShow Less

Q: It seems there are movies missing in the course which should explain how to enter products in the Order table. How do I do this?

A: The lessons in this course are only somewhat cumulative. The database is built throughout the title before getting to the relationships and referential integrity, but not every step is shown. This is one of those courses where using the exercise files is recommended. The course would be very long and repetitive if I demonstrated the same technique over and over for every step in building a database.

Take a look at these videos instead.

Chapter 2: Planning and designing your database (concept)

Chapter 2: Creating and editing tables in design view (building the order table)

Chapter 2: Creating a lookup field. (This one uses Customer lookup as the example, but I believe this technique answers your actual question. You would use the same procedure to add the field that calls up the list of products.)

Q: In the
Chapter 6 video "Using Design view," we work with the Combo Box
Wizard. When I click on the Combo Box then click the location on the form, it
does not start the Combo Wizard. Please advise.

A: Click on the Data tab and make sure one of the tables or queries appears selected in the Control Source. The form needs to be bound to a table or query before you make the combo box.

Also, Access is extremely finicky. When you're looking at the Properties window, be sure to click in the little box in the upper left corner of the form, between the vertical and horizontal rulers—as noted in the screenshot—before creating the combo box.

Q: It seems there are steps missing in the course. The file I built
myself by following along doesn't match what's on screen. Why not?

A: The lessons in this course are only somewhat cumulative. Each movie
is a standalone explanation of a technique or feature. The database is
built throughout the course, but not every step between the lessons are
shown. The course would be overly long if the author repeated every step in building a realistic,
functioning database. However, the missing steps are variations on the techniques you've already
learned. Also, this is one of those courses where using the
exercise files is recommended.