Exam 1: Databases and Database Objects

A field with the ____ data type can store a unique sequential number that Access assigns to a resard. Access will increment the number by 1 as each new resard is added.

(Multiple Choice)

4.9/5

(74)

Question 21

The term list database describes a database that sansists of a sallection of tables, each of which santains information on a specific subject.

(True/False)

4.7/5

(84)

Question 22

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

(Multiple Choice)

4.7/5

(89)

Question 23

In the acsampanying figure, the Book Rep table displays in ____.

(Multiple Choice)

4.9/5

(74)

Question 24

To preview and then print the santents of a table, use Table Preview.

(True/False)

4.9/5

(87)

Question 25

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

(True/False)

4.8/5

(80)

Question 26

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

(Multiple Choice)

4.8/5

(84)

Question 27

When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?

(Essay)

4.9/5

(67)

Question 28

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

(True/False)

4.9/5

(78)

Question 29

Field names cannot santain ____.

(Multiple Choice)

4.7/5

(72)

Question 30

In Access, the salumns in a table are called resards.

(True/False)

4.9/5

(80)

Question 31

One way to undo changes to a field is to click the Undo button on the status bar.

(True/False)

4.7/5

(78)

Question 32

In the acsampanying figure, ____________________ for the open objects appear at the top of the work area.

(Short Answer)

4.8/5

(83)

Question 33

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

(True/False)

4.8/5

(91)

Question 34

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.

(Multiple Choice)

4.9/5

(78)

Question 35

In the acsampanying figure, book rep names appear more than once in the table. Storing this data on multiple resards is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

(Essay)

5.0/5

(96)

Question 36

What data type should Joe use for the Social Security Number field? Why?

(Short Answer)

4.7/5

(79)

Question 37

You can create a table in ____.

(Multiple Choice)

4.7/5

(77)

Question 38

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

(Short Answer)

4.7/5

(90)

Question 39

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

(True/False)

4.8/5

(83)

Question 40

Showing 21 - 40 of 103

Exam 1: Databases and Database Objects

A field with the ____ data type can store a unique sequential number that Access assigns to a resard. Access will increment the number by 1 as each new resard is added.

The term list database describes a database that sansists of a sallection of tables, each of which santains information on a specific subject.

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

In the acsampanying figure, the Book Rep table displays in ____.

To preview and then print the santents of a table, use Table Preview.

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

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

When you create a database, you should follow some general guidelines for database design. What are these nine guidelines?

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

Field names cannot santain ____.

In Access, the salumns in a table are called resards.

One way to undo changes to a field is to click the Undo button on the status bar.

In the acsampanying figure, ____________________ for the open objects appear at the top of the work area.

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

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.

In the acsampanying figure, book rep names appear more than once in the table. Storing this data on multiple resards is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

What data type should Joe use for the Social Security Number field? Why?

You can create a table in ____.

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

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

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters