Upgrade to remove ads
Only $35.99/year

Access Module 1,2,3, and Test

Terms in this set (112)

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.
false
Which of the following are features of Access reports? Select all the options that apply.
footers
headers
calculations on groups of records
Press ESC to remove editing changes you made to the previous record.
False
You can create an Access report by selecting fields from one or more tables or _____.
Queries
To back up a database, you use the _____ command.
Back Up Database
Database templates create tables and queries, but not forms and reports.
False
What can you use to find information about Access commands and features and instructions about how to use them?
Tell Me box
Which of the following is the fastest way to open an Access database?
Double-click the database icon
_____ is the default name for a new table in an Access database.
Table1
You can assign most but not all data types to a field in Table Datasheet view.
True
What data type should you assign to a field that stores postal codes?
Short Text
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
Compacting a database has the same result as backing up a database.
False
Which data type stores web addresses?
hyperlink
Access provides a single database template for creating a blank database.
False
Before you can rename a field, you must change its data type.
False
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.
In a datasheet, what do you click to select a record for deletion?
Record selector button
Besides reducing file size, what other benefit does compacting an Access database provide?
repairing the database
Which of the following are Access data types? Select all the options that apply.
Number
Currency
Date/Time
You can create a table in Table Datasheet view or Table Design view.
True
_____ is a set of Access rules that governs data entry and helps ensure data accuracy.
Referential integrity
To relate two fields in a one-to-many relationship, you connect them using a _____.
common field
If you move the City column in a table datasheet, _____.
the City field also moves in Table Design view
You can import Access table data from which of the following Office apps? Select all the options that apply.
Outlook
Access
Excel
What Field Size should you set for a State field that stores two-character state abbreviations?
2
To move a field in Query Design view, you drag the field by its field selector.
True
What happens if you delete a field from a table that contains data?
You delete all the data in the field.
You use the Insert Rows button on the Query Tools Design tab to _____.
insert a row in the query design grid
A relational database can best be described as a collection of related _____ designed to minimize redundant data.
tables
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 set the Field Size property for a field with a Short Text data type.
True
When a record from one table is related to several records in another table, the tables have a one-to-many relationship.
True
In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.
False
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 field is always on the "one" side of a one-to-many relationship between two tables?
primary key field
To rename a table, you must use the Navigation Pane.
True
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.
What data type should you assign to a WeeklySalary field?
Currency
Which of the following are properties you can set for a Currency field? Select all the options that apply.
Default Value
Format
Decimal Places
The _____ property controls how many characters can be entered into the field.
Filed Size
You typically increase the decimal places from 1 to 2 for a(n) _____ field.
Currency
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
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 Import Spreadsheet Wizard helps you import Excel data into Access.
true
To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.
field
Before you close a query datasheet, you must save your changes to the data.
False
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
In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.
query design grid
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
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.
When you delete a column from a table in Table Datasheet view, you delete the field and all of its data.
True
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 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.
Sorting a table datasheet temporarily displays only those records that match given criteria.
False
How do you display the records in a subdatasheet?
You click the expand button in the datasheet
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
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
How can you list the records in a query datasheet in A-Z order by CustomerName?
Descending order
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.
Use Query Design view to display the results of a query.
false
You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.
criteria
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.
In a datasheet, you can find data, but not replace it.
False
One way to format a form is to set the alternate record color of the form in Form Layout view.
false
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
Add a Number field to a table to store values that represent money.
false
Access adds @ signs around date criteria in Date/Time fields.
False
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.
You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.
True
The Alternate Background Color command changes the background color of alternate records in a selected section.
False
You use the Report tool to quickly create a report based on the selected table.
True
A new blank desktop database includes one table named Table1.
True
Which data type is used for sequential integers controlled by Access?
AutoNumber
Which of the following are Access objects?
Reports
Forms
Queries
Which two properties are required for every field?
Field Name and Data Type
When you double-click an Access database icon, you have the choice of opening a database or creating a new one.
False
Which Access object contains all of the data in the database?
table
What should you do when you are finished working a database?
Close the database
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
After you create a table, you must save the entire database so you do not lose the new table.
False
Each row in a table datasheet displays a _____.
record
To navigate to the first record in a form, first switch to Form Design view.
False
Use the New (blank) record button to move the focus to the first record in a table.
False
When you import Excel data into an existing Access table, you relate the data to the table.
False
You can right-click the status bar to display the _____.
Customize Status Bar shortcut menu
When you import Excel data, you create a link to the data in the Access database.
False
What property do you use to set the Graduated text box in a form to display "Yes" in each new record?
Default Value
Changing the _____ property for a field does not change the actual data stored in the field.
Decimal Places
The goal of building one-to-many relationships between tables is to minimize _____ data.
redundant
You cannot modify the Field Size property of a Short Text field.
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
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
The linking field on the "many" side of a one-to-many relationship is called the foreign key field.
True
The _____ key field is the linking field on the "many" side of the relationship.
foreign
To delete a field in Table Datasheet view, you click _____.
the column heading for the field
What can you add to a query datasheet to display statistics for a group of records?
Total row
You use a subdatasheet to modify a field's properties.
False
A subdatasheet shows the records on the "one" side of a one-to-many relationship.
False
To add, delete, or change fields in a query, you use Query Design view.
True
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
You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.
False
To filter for comparative data, use the _____ feature.
Filter By Form
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
Use a Number field to store values that represent money.
False
Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.
True
What should you do before applying a new filter to a datasheet?
Clear all previous filters
Which of the following criteria uses the correct syntax for a Date/Time field in a query?
...
What data type is most appropriate for a field named PaymentAmt?
Currency
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
What might you need to do after increasing the font size in a table datasheet?
Widen the columns
Students also viewed