FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Access-Module 1: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

What is the purpose of the primary key?

A) to uniquely identify each record in a table
B) to uniquely identify each table in a database
C) to create a relationship between two tables in a database
D) to create a relationship for queries in a database

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

A formatted printout (or screen display)of the contents of one or more tables or queries is a  form .  _________________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

In a relational DBMS, a user may create a database structure that contains which of the following?

Each row in an Access table datasheet displays which of the following?

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet.  _________________________

The specific content of a field is referred to as the ____.

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

The default primary key for an Access database is the ID field.  _________________________

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

A single characteristic or attribute of a person, place, object, event, or idea is a  table .  _________________________

A question asked about the data stored in a database is called a primary key.  _________________________

Identify the letter of the choice that best matches the phrase or definition.

A database or a relational database is a collection of related tables.  _________________________

Which Access database object(s) might be used to enter, edit, and view records in a database?

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

What are the five primary functions of a Database Management System (DBMS)?