Analyze a select query in Design View to identify its source tables, join condition, and selected fields.


Creating Queries  «Prev  Next»
Lesson 5Analyze a select Query in Design View
Objective Analyze a select query in Design View to identify its source tables, join condition, and selected fields.

Analyze a select Query in Design View

The Query Design view in database software (e.g., Microsoft Access) may seem complex at first, but it shares similarities with the Advanced Filter/Sort window. This lesson introduces the key components of the Query Design window and explains their roles in building queries.

Analyze a select Query in Design View
The image displays the Query Design View in Microsoft Access, specifically for a query named “Project Hours : Select Query”.
Below is the transcription and analysis of the design:
🔶 Table Relationships (Top Pane)
  • Projects Table
    • Fields:
      • Project ID (Primary Key)
      • Company
      • Project Description
      • Start Date
  • Hours Table
    • Fields:
      • HoursID (Primary Key)
      • ProjectID (Foreign Key)
      • Date
      • Hours worked
  • Relationship:
    • A one-to-many relationship exists between Projects.Project ID and Hours.ProjectID, indicated by: 
      • Projects.Project ID (1) → Hours.ProjectID (∞)

🔶 Query Grid (Bottom Pane)
Field Table Sort Show Criteria Or
Project Description Projects ☑️
Date Hours ☑️
Hours worked Hours ☑️

🔶 Analysis
  • Tables Involved: Projects and Hours
  • Join Condition: Matching Project ID fields
  • Fields Selected:
    1. Project Description from Projects
    2. Date from Hours
    3. Hours worked from Hours
  • Sorting: None applied
  • Criteria: None specified
  • Result: The query will return a list showing the project description, date, and hours worked for each record in the Hours table, joined to the Projects table via Project ID.

SEMrush Software Target 5SEMrush Software Banner 5