ITAPP QUIZ (ACCESS)
1) When can you rename a table?
After you close the table.
1) Which data type is used for sequential integers controlled by Access?
Autonumber
1) To back up a database, you use the _____ command.
Back Up Database
1) What should you do if you want to make a copy of a database in a secure location?
Back up the database
1) Which of the following templates lets you create a database from scratch?
Blank desktop database
1) What should you do when you are finished working a database?
Close the database
1) To rename a field in Table Datasheet view, you change the text in the _____.
Column Heading
1) When you _____ a database, you reduce the size of the database by up to 75 percent.
Compact and repair
1) Each item on a form is called a _______.
Control
1) A _____ is a grid that displays fields as columns and records as rows.
Datasheet
1) ______ view is a spreadsheet-like view of the data in a table.
Datasheet
1) Which of the following is the fastest way to open an Access database?
Double-click the database icon.
1) In a datasheet, which mode do you use for changing the value of a field?
Edit Mode
1) A field with the Currency data type contains values such as quantities, measurements, and scores.
False
1) A form selects a subset of fields & records from one or more tables, & then presents selected data as a single datasheet.
False
1) A query is a temporary view of the data that is removed when you close the query in Query Design view.
False
1) After you create a table, you must save the entire database so you do not lose the new table.
False
1) Before you can rename a field, you must change its data type.
False
1) Before you close a query datasheet, you must save your changes to the data.
False
1) Compacting a database has the same result as backing up a database.
False
1) In a datasheet, you can find data, but not replace it.
False
1) Of all the database objects, a table provides the most formatting, layout, and summary options.
False
1) Press ESC to remove editing changes you made to the previous record.
False
1) Sorting a table datasheet temporarily displays only those records that match given criteria.
False
1) Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.
False
1) Table Design view shows how each table relates to other tables in the database.
False
1) To delete a field from a query, drag the field out of its field list.
False
1) To display data, it needs to be in Table Design.
False
1) To navigate to a record in a table, switch to Table Design view.
False
1) To rename a form, open the form, and then use the Rename command on the Home tab.
False
1) When you add a field to a table in Table Design view, entering the field name is optional.
False
1) When you double-click an Access database icon, you have the choice of opening a database or creating a new one.
False
1) When you enter a record in a table, you are working in navigation mode.
False
1) When you import Excel data into an existing Access table, you relate the data to the table.
False
1) You can enter, edit, and navigate data in a query datasheet just like a report datasheet.
False
Before you close a database, you must save any changes you made to the data.
False
Use the New (blank) record button to move the focus to the first record in the table.
False
When you import Excel data, you create a link to the data in the Access database.
False
1) A category of data such as a customer's name, city, state, or phone number is called a ______.
Field
1) Which two properties are required for every field?
Field Name and Field Size
1) The _______ refers to the data you would edit if you started typing.
Focus
1) Which data type stores web addresses?
Hyperlink
1) In the _____, Access lists each object in the open database.
Navigation Pane
1) In what part of the Access window do you rename a form?
Navigation Pane
1) Tables, queries, and forms are examples of Access _____.
Objects
1) You can create an Access report by selecting fields from one or more tables or _____.
Queries
1) A group of related fields, such as all the demographic information for one customer, is called a ______.
Record
1) Each row in a table datasheet displays a ____.
Record
1) If you want to manage lists of data about customers and the products they order, use _____ software.
Relational Database
1) The first step in the Form Wizard is to _____.
Select the fields to include in the form
1) Which of the following tools can you use to create a query?
Simple Query Wizard
1) Which Access object contains all of the data in the database?
Table
1) The upper pane of _____ view shows field names and data types.
Table Design
1) To view that provides the most options for defining fields.
Table Design
1) For a Comments field that contains many words, set a Long data type.
True
1) In Query Design view, the query grid shows the names of the fields and tables involved in the query.
True
1) The linking field on the "many" side of a one-to-many relationship is called the foreign key field.
True
1) To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.
True
1) To add, delete, or change fields in a query, you use Query Design view.
True
1) To enter data in a table, open it in Table Datasheet view.
True
1) To move a field in Query Design view, you drag the field by its field selector.
True
1) Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.
True
1) You can create a table in Table Datasheet view or Table Design view.
True
1) You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.
True
A new blank desktop database includes one table named Table1.
True
1) What is the most efficient way to navigate to the last record in a table containing 100 records?
Use the Last record button on the navigation bar.
1) At what point does Access save the data in a database?
When you finish entering or editing a record
1) Which data type stores only one of two values?
Yes/No