Access Module 1,2,3, and Test
Each row in a table datasheet displays a _____.
record
The goal of building one-to-many relationships between tables is to minimize _____ data.
redundant
What Field Size should you set for a State field that stores two-character state abbreviations?
2
Database templates create tables and queries, but not forms and reports.
False
In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.
False
In a datasheet, you can find data, but not replace it.
False
Which data type is used for sequential integers controlled by Access?
AutoNumber
What data type is most appropriate for a field named PaymentAmt?
Currency
Changing the _____ property for a field does not change the actual data stored in the field.
Decimal Places
A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.
False
A subdatasheet shows the records on the "one" side of a one-to-many relationship.
False
In a datasheet, what do you click to select a record for deletion?
Record selector button
What data type should you assign to a field that stores postal codes?
Short Text
To relate two fields in a one-to-many relationship, you connect them using a _____.
common field
What might you need to do after increasing the font size in a table datasheet?
Widen the columns
To back up a database, you use the _____ command.
Back Up Database
What should you do before applying a new filter to a datasheet?
Clear all previous filters
Access adds @ signs around date criteria in Date/Time fields.
False
Before you can rename a field, you must change its data type.
False
Press ESC to remove editing changes you made to the previous record.
False
Use a Number field to store values that represent money.
False
Use the New (blank) record button to move the focus to the first record in a table.
False
When you double-click an Access database icon, you have the choice of opening a database or creating a new one.
False
When you import Excel data into an existing Access table, you relate the data to the table.
False
When you import Excel data, you create a link to the data in the Access database.
False
You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.
False
For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.
Field Size
The _____ property controls how many characters can be entered into the field.
Filed Size
To filter for comparative data, use the _____ feature.
Filter By Form
If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?
Increase the number of decimal places.
Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.
True
When a record from one table is related to several records in another table, the tables have a one-to-many relationship.
True
The Import Spreadsheet Wizard helps you import Excel data into Access.
true
Which of the following are examples of correct criteria syntax? Select all the options that apply.
<= 33.50 >= #1/1/2021# < "Anderson"
How do you display the results of a query listed in the Navigation Pane?
Double-click the query
Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.
Format = Currency Decimal Places = 0 Decimal Places = 1
You can import Access table data from which of the following Office apps? Select all the options that apply.
Outlook Access Excel
Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options that apply.
Sum Average Count
_____ is the default name for a new table in an Access database.
Table1
You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.
criteria
Which Access object contains all of the data in the database?
table
If you move the City column in a table datasheet, _____.
the City field also moves in Table Design view
To delete a field in Table Datasheet view, you click _____.
the column heading for the field
In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?
the positions offered by each employer
If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?
to the right of the City field
If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?
750
Which of the following statements describe a filter? Select all the options that apply.
A filter displays a temporary subset of records in the current datasheet. A filter is not as powerful as a query. In a datasheet, a filter displays only those records that match criteria you specify.
What is the difference between entering a record using a form and entering a record using a datasheet?
A form presents records one at a time, while a datasheet lists all records.
What should you do when you are finished working a database?
Close the database
Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options thatapply.
Count Sum Average
What data type should you assign to a WeeklySalary field?
Currency
You typically increase the decimal places from 1 to 2 for a(n) _____ field.
Currency
You can right-click the status bar to display the _____.
Customize Status Bar shortcut menu
What property do you use to set the Graduated text box in a form to display "Yes" in each new record?
Default Value
Which of the following are properties you can set for a Currency field? Select all the options that apply.
Default Value Format Decimal Places
How can you list the records in a query datasheet in A-Z order by CustomerName?
Descending order
What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?
DiscountPrice: [Price]-10
Which of the following is the fastest way to open an Access database?
Double-click the database icon
Which of the following are ways to run a query? Select all the options that apply.
Double-click the query in the Navigation Pane. Click the View button in Query Design view. Click the Run button in Query Design view.
Access provides a single database template for creating a blank database.
False
After you create a table, you must save the entire database so you do not lose the new table.
False
Before you close a query datasheet, you must save your changes to the data.
False
Compacting a database has the same result as backing up a database.
False
If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.
False
Sorting a table datasheet temporarily displays only those records that match given criteria.
False
The Alternate Background Color command changes the background color of alternate records in a selected section.
False
To navigate to the first record in a form, first switch to Form Design view.
False
You cannot modify the Field Size property of a Short Text field.
False
You use a subdatasheet to modify a field's properties.
False
Which two properties are required for every field?
Field Name and Data Type
Which of the following statements describe Query Design view? Select all the options that apply.
Field lists appear in the upper pane of Query Design view. The query design grid provides a way to sort records. Query Design view lets you modify an existing query.
A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?
Find and Replace
Which of the following are Access data types? Select all the options that apply.
Number Currency Date/Time
You can create an Access report by selecting fields from one or more tables or _____.
Queries
_____ is a set of Access rules that governs data entry and helps ensure data accuracy.
Referential integrity
Which of the following are Access objects?
Reports Forms Queries
Which of the following are views you can use to display a query? Select all the options that apply.
SQL view Query Datasheet view Query Design view
Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?
Save the table
To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.
Sum
What can you use to find information about Access commands and features and instructions about how to use them?
Tell Me box
What happens if you hide the Bonus column in the Employees table in Table Datasheet view?
The Bonus column no longer appears in the datasheet, but is still part of the Employees table.
What can you add to a query datasheet to display statistics for a group of records?
Total row
A new blank desktop database includes one table named Table1.
True
If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.
True
The linking field on the "many" side of a one-to-many relationship is called the foreign key field.
True
To add, delete, or change fields in a query, you use Query Design view.
True
To move a field in Query Design view, you drag the field by its field selector.
True
To rename a table, you must use the Navigation Pane.
True
When you delete a column from a table in Table Datasheet view, you delete the field and all of its data.
True
You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.
True
You can assign most but not all data types to a field in Table Datasheet view.
True
You can create a table in Table Datasheet view or Table Design view.
True
You can set the Field Size property for a field with a Short Text data type.
True
You use the Report tool to quickly create a report based on the selected table.
True
Which of the following statements are true about subdatasheets? Select all the options that apply.
You can use a subdatasheet to enter new records. You can click the expand button to view the records in a subdatasheet. They appear for a table on the "one" side of a one-to-many relationship.
How do you display the records in a subdatasheet?
You click the expand button in the datasheet
What happens if you delete a field from a table that contains data?
You delete all the data in the field.
Add a Number field to a table to store values that represent money.
false
One way to format a form is to set the alternate record color of the form in Form Layout view.
false
Use Query Design view to display the results of a query.
false
You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.
false
To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.
field
Which of the following are features of Access reports? Select all the options that apply.
footers headers calculations on groups of records
The _____ key field is the linking field on the "many" side of the relationship.
foreign
If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?
form highest to lowest Price
Which data type stores web addresses?
hyperlink
You use the Insert Rows button on the Query Tools Design tab to _____.
insert a row in the query design grid
Which field is always on the "one" side of a one-to-many relationship between two tables?
primary key field
In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.
query design grid
Besides reducing file size, what other benefit does compacting an Access database provide?
repairing the database
A relational database can best be described as a collection of related _____ designed to minimize redundant data.
tables
