Microsoft Access
Database Queries & Operations
Database Applications | Undergraduate CS
Questions & Verified Answers
, Q1. How do you create a new query in MS Access that shows Nickname, WorkshopName, and
WorkshopDate from the Participants and Workshops tables, saved as 'ParticipantList'?
Answer: Open Query Design → Add Participants and Workshops tables → double-click
Nickname, WorkshopName, WorkshopDate in order → click Run → save as ParticipantList.
Go to Create → Query Design. In the Show Table dialog, add both tables.
Double-click the fields in the correct order to add them to the grid.
Click the Run button (red !), then save the query as ParticipantList.
Q2. How do you format a calculated Revenue field in the WorkshopsByType query to display as
Currency?
Answer: Open WorkshopsByType in Design View → click inside the Revenue field column
→ press F4 to open Property Sheet → set the Format property to Currency → save.
The Property Sheet appears on the right side of the screen when you press F4.
Changing Format to Currency adds a currency symbol and two decimal places.
Q3. How do you add a parameter query criterion '[Enter room]' to the WorkshopType field and test
it with 'Kitchen'?
Answer: Open WorkshopAttendanceByType in Design View → in the Criteria row of
WorkshopType, type [Enter room] → click Run → type Kitchen in the dialog → click OK →
save.
Square brackets [ ] tell Access to show a prompt dialog when the query runs.
The text inside the brackets becomes the prompt message.
Q4. How do you copy all records from NewSponsors and append them to the Sponsors table?
Answer: Open NewSponsors → select all records (Ctrl+A) → copy (Ctrl+C) → open
Sponsors → click the empty row at the bottom (*) → paste (Ctrl+V) → confirm.
Both tables must have the same structure (same columns and data types).
Access will warn you before pasting — click Yes to confirm the append.
Q5. How do you delete the MaxCapacity field from the WorkshopsByType query in Design View?
Answer: Open WorkshopsByType in Design View → hover over the top of the MaxCapacity
column until you see a black arrow → click to select the column → press Delete → save.
You can also right-click the selected column header and choose Delete Columns.
Q6. How do you move the ID field to the fifth column in the AlphaListOfCustomers query?
Answer: Open AlphaListOfCustomers in Design View → click the gray bar at the top of the
ID column to select it → drag it to the right until it becomes the fifth column → save.
After moving ID, the State field will become the fourth column.
You drag a column by clicking and holding the selected column header bar, then sliding it.
Q7. How do you add a criterion of >=25 to the MaxCapacity field in WorkshopsByType so only
records with 25 or more capacity are shown?
Answer: Open WorkshopsByType in Design View → find the MaxCapacity column → in the
Criteria row, type >=25 → click Run → save.
The >= operator means 'greater than or equal to'.
You can use any comparison operator: =, <>, <, >, <=, >= in the criteria row.
Q8. How do you filter WorkshopAttendanceByType to show only records where WorkshopDate is
April 8, 2017?
Database Queries & Operations
Database Applications | Undergraduate CS
Questions & Verified Answers
, Q1. How do you create a new query in MS Access that shows Nickname, WorkshopName, and
WorkshopDate from the Participants and Workshops tables, saved as 'ParticipantList'?
Answer: Open Query Design → Add Participants and Workshops tables → double-click
Nickname, WorkshopName, WorkshopDate in order → click Run → save as ParticipantList.
Go to Create → Query Design. In the Show Table dialog, add both tables.
Double-click the fields in the correct order to add them to the grid.
Click the Run button (red !), then save the query as ParticipantList.
Q2. How do you format a calculated Revenue field in the WorkshopsByType query to display as
Currency?
Answer: Open WorkshopsByType in Design View → click inside the Revenue field column
→ press F4 to open Property Sheet → set the Format property to Currency → save.
The Property Sheet appears on the right side of the screen when you press F4.
Changing Format to Currency adds a currency symbol and two decimal places.
Q3. How do you add a parameter query criterion '[Enter room]' to the WorkshopType field and test
it with 'Kitchen'?
Answer: Open WorkshopAttendanceByType in Design View → in the Criteria row of
WorkshopType, type [Enter room] → click Run → type Kitchen in the dialog → click OK →
save.
Square brackets [ ] tell Access to show a prompt dialog when the query runs.
The text inside the brackets becomes the prompt message.
Q4. How do you copy all records from NewSponsors and append them to the Sponsors table?
Answer: Open NewSponsors → select all records (Ctrl+A) → copy (Ctrl+C) → open
Sponsors → click the empty row at the bottom (*) → paste (Ctrl+V) → confirm.
Both tables must have the same structure (same columns and data types).
Access will warn you before pasting — click Yes to confirm the append.
Q5. How do you delete the MaxCapacity field from the WorkshopsByType query in Design View?
Answer: Open WorkshopsByType in Design View → hover over the top of the MaxCapacity
column until you see a black arrow → click to select the column → press Delete → save.
You can also right-click the selected column header and choose Delete Columns.
Q6. How do you move the ID field to the fifth column in the AlphaListOfCustomers query?
Answer: Open AlphaListOfCustomers in Design View → click the gray bar at the top of the
ID column to select it → drag it to the right until it becomes the fifth column → save.
After moving ID, the State field will become the fourth column.
You drag a column by clicking and holding the selected column header bar, then sliding it.
Q7. How do you add a criterion of >=25 to the MaxCapacity field in WorkshopsByType so only
records with 25 or more capacity are shown?
Answer: Open WorkshopsByType in Design View → find the MaxCapacity column → in the
Criteria row, type >=25 → click Run → save.
The >= operator means 'greater than or equal to'.
You can use any comparison operator: =, <>, <, >, <=, >= in the criteria row.
Q8. How do you filter WorkshopAttendanceByType to show only records where WorkshopDate is
April 8, 2017?
