Access Chapter 1

Question 1

Datasheet view

Answer 1

view that enables you to add, edit, and delete the records of a table

Question 2

Form

Answer 2

an access object that enables you to enter, modify, or delete table data

Question 3

Compact and Repair

Answer 3

an access utility that reduces the size of the database and can repair a corrupt database.

Question 4

Object

Answer 4

a main component that is created and used to make a database function

Question 5

Filter by Form

Answer 5

a filtering method that displaces records based on multiple criteria

Question 6

Relational Database Management System (RDBMS)

Answer 6

a system that uses the relational model to manage groups of data (tables) and rules (relationships) between tables.

Question 7

Custom Web App

Answer 7

a database that can be built, used, and shared with others through the use of a host server

Question 8

Report

Answer 8

an object that contains professional-looking formatted information from underlying tables or queries.

Question 9

Table

Answer 9

an object used to store data, and the foundation of every database.

Question 10

Backup Database

Answer 10

an access utility that creates a duplicate copy of the database.

Question 11

Template

Answer 11

a predefined database that includes professionally designed tables, forms, reports, and other objects.

Question 12

Filter by Selection

Answer 12

a filtering method that displays only records that math selected criteria.

Question 13

Relationship

Answer 13

a connection between two tables using a common field

Question 14

Sort

Answer 14

a method of listing records in a specific sequence

Question 15

Design View

Answer 15

view that enables you to create tables, add and delete fields, and modify field properties.

Question 16

Navigation Pane

Answer 16

an access interface element that organizes and lists the database objects in a database.

Question 17

Query

Answer 17

a question you ask that can help you find and retrieve table data meeting conditions you specify.

Question 18

Field

Answer 18

the smallest data element in a table, such as first name, last name, address, or phone number.

Question 19

Record

Answer 19

complete set of all the fields (data elements) about one person, place, event, or concept.

Question 20

Primary Key

Answer 20

the field (or combination of fields) that uniquely identifies each record in a table.

Question 21

Which sequence represents the hierarchy of terms, from smallest to largest?

Answer 21

field, record, table, database

Question 22

You edit several records in an Access table. When should you execute the Save command?

Answer 22

Records are saved automatically; the save command is not required.

Question 23

Which of the following is not true of an Access database?

Answer 23

every table in a database contains the same number of records as every other table.

Question 24

Which of the following is true of an Access database?

Answer 24

• Short text, Number, AutoNumber, and Currency are valid data types.
• 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.

Question 25

Which of the following is true regarding the record selector box?

Answer 25

An orange border surrounds the record selector box and the active record.

Question 26

Which of the following will be accepted as valid during data entry?

Answer 26

Entering numbers into a text field.

Question 27

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 is has more than doubled in size. You should:

Answer 27

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

Question 28

Which of the following conditions is available through “Filter by Selection”?

Answer 28

Equals Condition

Question 29

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:

Answer 29

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

Question 30

Which of the following is not true when creating relationships between tables?

Answer 30

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

Question 31

Which of the following is true when creating relationships between tables?

Answer 31

• Join lines create a relationship between two tables.
• The data types of common fields must be the same.
• Enforcing referential integrity ensures that data cannot be entered into a related table unless it first exists in the primary table.

Question 32

All of the following statements are true about creating a database EXCEPT

Answer 32

the objects provided in a template cannot be modified

Question 33

All of the following statements are true about creating a database

Answer 33

• Creating a custom Web app requires that you use a host server.
• When creating a blank desktop, Access opens to a blank table in Datasheet view.
• Using a template to create a database saves time because it includes predefined objects.