FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Access_Module_1

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) -Which field in the Employee table should be the primary key and why?

A(n) ____ contains information about a given person, product, or event.

A hard copy or ____________________ is information that exists on a physical medium such as paper.

The ____________________ data type in Access is referred to as Money in SQL Server.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

Critical Thinking Questions Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. -What data type should Joe use for the Social Security Number field? Why?

In Access, the columns in a table are called records.

Form view displays a single record at a time.

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

A field whose data type is ____ can store text that can be used as a hyperlink address.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

In Access, field names cannot contain digits.

Redundancy means storing the same fact in more than one place.

To add a record to a table, tap or click the ____ record button.