01. What is an important consideration when setting default values for fields in a database?
a) It should be a value the field's validation rule would reject
b) It should be chosen knowing it fills the records already stored
c) It should be treated as a requirement the user cannot change
d) It should be the value most new records would genuinely start with
You open the Open Invoices query in Datasheet view and select the rows for the disputed invoices. On the External Data tab, you start the export to an Excel workbook.
Which export options meet the accountant workbook requirements?
a) Select Export data with formatting and layout, and select Open the destination file after the export operation is complete
b) Clear Export data with formatting and layout, and save the export steps so the export can be run again
c) Select Export data with formatting and layout, and then select Export only the selected records
d) Clear Export data with formatting and layout, and select Export only the selected records
03. When modifying labels on reports, what should be considered to enhance report clarity and effectiveness?
(Choose two.)
a) The label should accurately describe the data or the control it names
b) The label should carry the Control Source of the field it names
c) The label should sit in the Detail section so it repeats with every record
d) The label should use a font size and weight that stay readable in print
You create the Deposit Chase query in Design view from the Bookings table and add the Room and Status fields to the design grid.
Which criteria entries meet the Deposit Chase query requirements?
Each correct answer presents a complete solution. (Choose two.)
a) In the Criteria row, enter "Beech Suite" Or "Cedar Suite" under Room and "Provisional" under Status
b) In the Criteria row, enter "Beech Suite" And "Cedar Suite" under Room and "Provisional" under Status
c) In the Criteria row, enter "Beech Suite" under Room and "Provisional" under Status; in the Or row, enter "Cedar Suite" under Room and "Provisional" under Status
d) In the Criteria row, enter "Beech Suite" under Room and "Provisional" under Status; in the Or row, enter "Cedar Suite" under Room
05. Why is it important to carefully consider the placement of new controls in a report layout?
a) To keep controls aligned and in the section that prints them at the right point
b) To make sure the Detail section prints only one time
c) To let Access work out the tab order for the finished report
d) To stop the report's record source changing when the layout moves
You create a select query named Order Values based on the Orders table and add OrderID, OrderDate and GoodsValue to the design grid. In the next empty column, you add a calculated field.
Which expression should you enter in the Field row to meet the Order Values query requirements?
a) OrderTotal: [GoodsValue] & [DeliveryCharge]
b) OrderTotal: [GoodsValue]+[DeliveryCharge]
c) OrderTotal: [GoodsValue]+Nz([DeliveryCharge],0)
d) OrderTotal: Nz([GoodsValue]+[DeliveryCharge],0)
For the board, you build a query in Design view from the Courses, Sessions and Enrolments tables and display the Total row. CourseTitle is set to Group By and EnrolmentID is set to Count. You add StartDate to the grid with the criterion Between #1/1/2026# And #12/31/2026#.
Which Total row setting for StartDate meets the board reporting requirement?
a) Group By
b) Where
c) Max
d) Min
08. In a database, setting primary keys serves which primary purpose?
a) To supply a starting value in the field whenever a new record is added to the table
b) To control the format of what is typed into the field
c) To make the field mandatory without also making it unique
d) To ensure each record within a table can be uniquely identified
You create an update query based on the Treatments table and add the Category and Fee fields to the design grid.
Which entries should you make in the design grid to meet the fees requirement?
(Choose two.)
a) In the Update To row for Fee, enter [Fee]*1.05
b) In the Criteria row for Category, enter "Dental"
c) In the Update To row for Category, enter "Dental"
d) In the Update To row for Fee, enter [Fee]*0.05
10. Which actions are crucial when adding report controls?
(Choose two.)
a) Choosing a control type that suits the value being displayed
b) Placing every control in the Detail section regardless of its purpose
c) Aligning each control with the structure of the data the report returns
d) Binding each label to the field it describes through a Control Source