30 terms

Access Chapter 1

STUDY
PLAY

Terms in this set (...)

View that enables you to add, edit, and delete the records of a table.
Datasheet view
An Access object that enables you to enter, modify, or delete table data.
Form
An Access utility that reduces the size of the database and can repair a corrupt database.
Compact and Repair
A main component that is created and used to make a database function.
Object
A filtering method that displays records based on multiple criteria
Filter by Form
A system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables.
Relational database management system (RDBMS)
A database that can be built, used, and shared with others through the use of a host server.
Custom Web app
An object that contains professional-looking formatted information from underlying tables or queries.
Report
An object used to store data, and the foundation of every database.
Table
An Access utility that creates a duplicate copy of the database.
Back Up Database
A predefined database that includes professionally designed tables, forms, reports, and other objects.
Template
A filtering method that displays only records that match selected criteria.
Filter by Selection
A connection between two tables using a common field.
Relationship
A method of listing records in a specific sequence.
Sort
View that enables you to create tables, add and delete fields, and modify field properties.
Design view
An Access interface element that organizes and lists the database objects in a database.
Navigation Pane
A question you ask that can help you find and retrieve table data meeting conditions you specify.
Query
The smallest data element in a table, such as first name, last name, address, or phone number.
Field
Complete set of all the fields (data elements) about one person, place, event, or concept.
Record
The field (or combination of fields) that uniquely identifies each record in a table.
Primary key
Which sequence represents the hierarchy of terms, from smallest to largest?

Record, field, table, database

Field, record, database, table

Field, record, table, database

Database, table, record, field
Field, record, table, database
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.

Immediately after you edit a record

When you close the table

Once at the end of the session
Records are saved automatically; the save command is not required.
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.

Every record in a table has the same fields as every other record.

Each table should contain a primary key; however, a primary key is not required.

Short Text, Number, AutoNumber, and Currency are valid data types.
Every table in a database contains the same number of records as every other table.
Which of the following is true regarding the record selector box?

An asterisk indicates the first record in the table.

An empty square indicates that the current record is selected.

A pencil symbol indicates that the current record already has been saved.

An orange border surrounds the record selector box and the active record.
An orange border surrounds the record selector box and the active record.
Which of the following will be accepted as valid during data entry?

Entering numbers into a text field

Omitting an entry in a required field

Entering text into a numeric field

Adding a record with a duplicate primary key
Entering numbers into a text field
You have finished an Access assignment and wish to turn it in to your instructor for evaluation. As you prepare to transfer the file, you discover that it has more than doubled in size. You should:

Turn it in; the size does not matter.

Zip the database file prior to sending it to your instructor.

Compact and repair the database before sending it to your instructor.

Delete extra tables or reports or fields to make the file smaller.
Compact and repair the database before sending it to your instructor.
Which of the following conditions is available through Filter by Selection?

Equals condition

Delete condition

OR condition

AND condition
Equals condition
An Employees table is open in Datasheet view. You want to sort the names alphabetically by last name and then by first name (e.g., Smith, Andrew). To do this, you must:

First sort ascending on first name and then on last name.

First sort descending on last name and then on first name.

First sort descending on first name and then on last name.

First sort ascending on last name and then on first name.
First sort ascending on first name and then on last name.
Which of the following is not true when creating relationships between tables?

The common fields used to create a relationship must both be primary keys.

Enforcing referential integrity ensures that data cannot be entered into a related table unless it first exists in the primary table.

Join lines create a relationship between two tables.

The data types of common fields must be the same.
The common fields used to create a relationship must both be primary keys.
All of the following statements are true about creating a database except:

The objects provided in a template cannot be modified.

Using a template to create a database saves time because it includes predefined objects.

Creating a custom Web app requires that you use a host server.

When creating a blank desktop database, Access opens to a blank table in Datasheet view.
The objects provided in a template cannot be modified.