Access Ch. 1-5 Key Terms Matching
A set of common Access components that can be added to an existing database.
Application Part
What is the result of the following expression? 2 * 5 + 8 − 6 / 2
15
Which of the following statements about the Round function is false?
A Round function with a precision of 1 rounds to the nearest integer.
An illustration of a one-to-many relationship would be:
A customer may have more than one account in an accounts table.
When is it generally useful to run a delete query?
A delete query is usually run after an append or make-table query.
Which of the following statements is true?
A last name is an example of a common field to group by
When creating a calculation, which of the following would be identified as an error by Access?
A missing colon in the expression (for example: TotalHours [OTHours]+[RegHours]).
Which of the following statements is false?
A null value means that the value is zero for any type of field.
Which statement about a totals query is true?
A totals query may contain several grouping fields and several aggregate fields
Which of the following can be added to a totals query?
All of the above can be added to a totals query
Which of the following cannot be used in a calculated field?
All of these can be used in a calculated field
Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?
Ann, ANN, and ann
To add a predefined table to an existing database, you should use which of the following?
Application part
All of the following are suggested guidelines for table design except:
Avoid date arithmetic
Which of the following utilities is used to recover in the event of loss or damage?
Back Up Database
Which of the following is not a valid condition for an IIf function?
Between 10 and 22
Which of the following could not be done using an aggregate function?
Calculating the payment amount of a loan
Which of the following determines how the field names can be made more readable in table and query datasheets?
Caption Property
Which of the following is true regarding table views?
Changes made in Datasheet view are automatically saved when you more the insertion point to a different record.
What is the best way to find students who have not handed in a certain assignment?
Create a find unmatched query using the student and assignment tables.
Which of the following views provides you with the most flexibility in modifying forms and reports?
Design View
Which of the following conditions is available through a Selection filter?
Equal condition
Which of the following is not true of an Access database?
Every table in a database contains the same number of records as every other table.
A filtering method that displays records based on multiple criteria.
Filter By Form
Which one of the following tasks cannot be completed with an action query?
Finding duplicate values in a table
An Access object that simplifies entering, modifying, and deleting table data.
Form
The string of characters !\(999") "000\-0000;0;_ represents which of the following?
Input mask
The simplest view you can use to modify control widths in a form is:
Layout view
Which of the following statements is false?
Layouts for forms and reports are the pre-defined sets of colors, fonts, and graphics.
The main reason to set a field size in Access is to:
Limit the length of values in a table.
Which of the following enables users to choose from a list of options while entering data?
Lookup field
Which of the following cannot be adjusted in the Property Sheet?
Mathematical expression
Which of the following is true for the Query Wizard?
No criteria can be added as you step through the Wizard
A main component that is created and used to make a database function, such as a table or form
Object
When adding date criteria to the Query Design view, the dates you enter must be delimited by:
Pound signs (#).
A question you ask about the data in your database.
Query
Complete set of all the fields about one person, place, event, or concept
Record
A report can be made from one or more tables or a query. The object(s) that a report is based on is known as the:
Record source
You edit several records in an Access table. When should you execute the Save command?
Records are saved automatically; the save command is not required
An object that contains professional-looking formatted information from underlying tables or queries.
Report
Which of the following statements about reports is false?
Reports are primarily used to modify data.
Which type of query would you run as a method of previewing the results of the other three?
Select Query
A filtering method that displays only records that match selected criteria.
Selection Filter
If you want to calculate aggregate statistics about graduation rates for students in a college database, which of the following would provide the least useful information if you were to group by it?
Social Security Number
A method of listing records in a specific sequence (such as alphabetically).
Sort
A parameter query enables you to:
Specify criteria for a field when you run the query.
Which of the following statements is false?
Stacked layouts are more common for reports because they use less paper when printed.
An object used to store data, organizing data into columns and rows
Table
Where is data in a database stored?
Table
A query's specifications as to which tables to include must be entered on the:
Table row of the query design grid
A predefined database that includes professionally designed tables, forms, reports, and other objects.
Template
In order to summarize data in a report and override the sort order of the record source you would use:
The Group, Sort, and Total Pane
Which of the following is not a data validation technique?
The Round function
Which of the following about the Total row in Query design is false?
The Total row applies only to non-numeric fields
When entering, deleting, or editing input masks:
The table must be in design view
Why would you use an append query?
To copy records from one table to another based on criteria that you specify.
Why is it important to monitor how many times an update query is executed?
Update queries are capable of changing values (such as prices) more than one time.
Which statement is true about update queries?
Update queries should be executed with caution because you cannot undo their changes.
In a large products table that you have acquired from an external source, you find that there are repeating product IDs. You need to set ProductID as the primary key field in this table. What is the best way to resolve this problem?
Use a find duplicates query to locate duplicate product IDs. Delete the duplicates and associate all orders for that product to the remaining product ID.
What is the easiest way to create a crosstab query?
Use the Crosstab Query Wizard
With respect to importing data into Access, which of the following statements is true?
You can assign a primary key while you are importing Excel data
What is an unmatched record?
A record in one table without a related record in another table
A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.
Database
Which of the following is an example of an Access object?
Form
An Access interface element that organizes and lists database objects in a database
Navigation Pane
It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?
The existing query and the new query use the same tables and fields
Which of the following fields is least likely to be set to required?
The name of an emergency contact for a patient in a doctor's database
All of the following statements are true about creating a database except:
The objects provided in a template cannot be modified.
When would you use the Date function?
To display the current date
Which of the following cannot be extracted by the DatePart function?
a. Weekday b. Month c. Year d. All of the above can be extracted.
