Microsoft Access

All database information is stored in
1. tables
2. forms
3. queries
4. reports
A single piece of information such as a first name is a
1. record
2. field
3. property
4. data type
To select a record, click the
1. row number
2. row header
3. record selector
4. field selector
To display data in a custom format, use a
1. table
2. form
3. query
4. report
To make it easy to enter data, use a
1. table
2. form
3. query
4. report
To move the insertion point down to the same field in the next record, use
1. Page Down
2. Ctrl + D
3. End
4. Down arrow
To go to a specific record in a database, key its number in the
1. Previous Record box
2. Next Record box
3. Record Number box
4. Find Record box
To add a record to an existing database, first click the
1. New Record button
2. Next Record button
3. Add Record button
4. Insert Record button
To remove records, select them and then click the
1. Remove button
2. Delete key
3. Clear command
4. Subtract command
To begin creating a form, you must choose a
1. query
2. record source
3. table
4. report
To rename an Access database, you must use
1. My Computer
2. File, Save New
3. Edit, New
4. you cannot rename an Access database
When you first start Access, you have the option to
1. create a new, blank database
2. use an Access wizard
3. open an existing file
4. all of the these
The first object you need to create in a database is a
1. report
2. form
3. table
4. query
Each column in a table is labeled with a
1. column name
2. record header
3. field label
4. field name
If you define a field named Cost, the data type you would most likely use would be
1. Text
2. Number
3. AutoNumber
4. Currency
Specifications for fields that allow you to customize the field's data are
1. field formats
2. data formats
3. field properties
4. data properties
To select a column in Datasheet view, click the
1. column letter
2. column selector
3. field selector
4. record selector
The Access feature that asks you questions and then formats an object according to your answers is a(n)
1. wizard
2. template
3. assistant
4. expert
An Access table resembles a worksheet because it is set up in rows and columns.
1. true
2. false
Rows and columns in an Access table are also referred to as fields and records.
1. true
2. false
The Format field property specifies how Access will display numbers, dates, times, and text.
1. true
2. false
You can copy or move data from one location in an Access table to a new location within the table, or to a different table.
1. true
2. false
In Datasheet view, fields appear in columns.
1. true
2. false
You can create a form manually or use a wizard.
1. true
2. false
Access's standard view is Datasheet view.
1. true
2. false
A database can contain all types of information from a list of clients to a personal inventory.
1. true
2. false
All of Access's objects are contained in a single database file.
1. true
2. false
Datasheet view displays data in a row-and-column format.
1. true
2. false
If the data you key in a field does not match its data type, Access will display an error message.
1. true
2. false
Generally, once you enter data in a database, you do not have to update it.
1. true
2. false
You can use Undo to reverse changes until you begin editing another record.
1. true
2. false
You can add new records anywhere in a table.
1. true
2. false
When you delete a record, Access will display a message to warn you about the deletion.
1. true
2. false
When you use the Cut or Copy command, Access automatically stores the items in the Clipboard.
1. true
2. false
You can copy data from a location in one Access table to a different table.
1. true
2. false
After you cut a record from a table, you can use Paste to restore it to the table.
1. true
2. false
You can select multiple fields in Datasheet view by clicking a field name, holding down Ctrl, and clicking additional fields.
1. true
2. false
Creating a form adds a new object to the database.
1. true
2. false
Records you enter in Form view are automatically stored in the table used to create the form.
1. true
2. false