Access unit Quiz
SQL statements end with the ________ character.
;
Which statement about a totals query is true?
A totals query may contain several grouping fields and several aggregate fields.
Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?
AND
You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field?
Access assigns Expr1 to a calculated field without a name, and this name can be edited
Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.
Aggregate
Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:
AutoNumber
Access contains ________ that perform routine calculations.
Built-in Functions
All of the following are SQL keywords except ________.
CONDITION
________ a database rearranges data and objects in a database to make its size smaller.
Compacting
The ________ view in Access looks similar to an Excel spreadsheet.
Datasheet
You can create or modify a table's field names and data types in ________ view.
Design
Which of the following will be accepted as valid during data entry?
Entering numbers into a text field
Which sequence represents the hierarchy of terms, from smallest to largest?
Field, record, table, database
Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:
Filter by Form.
Which of the following is NOT a report view?
Format view
Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?
Irene should include the primary key in the customer information table as a foreign key in the order information table.
The main reason to enforce referential integrity in Access is to:
Keep invalid data from being entered into a table.
If you need to sort the records contained in a report, you can do so from either the Design view or the ________ of the report.
Layout View
In an SQL statement., sorting results based on field values is done using the ________ keyword.
ORDER BY
A query's specifications providing instructions about which records to include must be entered:
On the Criteria row of the query design grid.
The Builder command that opens the Expression Builder is found in the:
Query Setup group on the Design tab.
You perform several edits in a table within an Access database.When should you execute the Save command?
Records are saved automatically; the Save command is not required.
an SQL statement that chooses all fields in a Student table would begin with: ________ * FROM Student
SELECT
Which of the following would be the best choice for a primary key?
Social Security Number
The ________ data type can store text, numerals, and symbols.
Text
Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?
The birthday should be a stored field and the age should be a calculated field
When entering, deleting, or editing table data:
The table must be in Datasheet view.
When you make a change to the content of a record in an Access table, when are the changes saved?
When you move the insertion point to a different record
A(n) ________ is information that needs to be given to a macro to produce output.
argument
Text boxes, buttons, and boxes are examples of ________, which can be used to add, edit, and display data in a form or report.
controls
A(n) ________ executes a series of actions when a table event occurs.
data macro
Selecting data by means of a query:
displays only the data that matches the query selection criteria.
When you ________, you ensure that data entered into a related table first exists in the primary table.
enforce referential integrity
A(n) ________ is something that occurs when a user opens, uses, or closes a form or report.
event
A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.
foreign key
A(n) ________ is a set of commands that can be executed automatically or on demand.
macro
A primary key:
must contain a unique value for each record within a table.
Expression Builder inserts ________ that tell you where each argument belongs.
placeholders
A(n) ________ is used to change settings such as formatting and captions.
property sheet
The table or query that supplies underlying data to a form or report is called the:
record source.
Syntax can most accurately be defined as the ________.
set of language rules that Access follows when evaluating expressions.
When defining a field, the field ________ property determines how much physical storage space the field requires.
size
A(n) ________ macro is not triggered automatically by the database.
stand-alone
When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.
the Report Wizard
