FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

-Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

A) Find group, Go To button
B) Records group, Save button
C) Records group, New button
D) Sort & Filter group, Advanced button

E) None of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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 datasheet.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

Which data type allows field values to contain letters, digits, and other characters?

Field names may have up to 64 characters. However, one of the recommendations is to use concise field names. Which field names could be changed to be more concise?

Access reports are based on a selected ____________________ or ____________________.

-In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

This icon represents which Access 2013 object?

Main Street Catering has created a database with one table containing customer information. When creating the table, Marissa did not follow recommendations for naming fields in a table. There are a number of changes that would make the field names more useful and follow field naming recommendations. Using the accompanying figure, answer the following questions about the CustomerTable. -Which field name follows the recommendation of capitalizing the first letter of each word and also follows the no spaces recommendation?

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

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

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

Another term used for the column selector feature is ____.

-Which Access feature provides information about Access commands and features and instructions about how to use them?

Which Ribbon group allows you to add fields to an Access table with defined data types?

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

What is the purpose of the primary key?

MATCHING -A question that is asked about the data stored in a database.