Exam 7: Enhancing Table Design

The default placeholder is the ____.

(Multiple Choice)

4.7/5

(31)

Question 41

When a(n) validation rule is created, data entered into the field must meet the rule requirements.

(True/False)

4.8/5

(31)

Question 42

Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. Which of the following expressions can Ed define as a valid expression meaning the date entered needs to be after June 30, 2014?

(Multiple Choice)

4.9/5

(37)

Question 43

Case Access 7-2 Andrew is an accountant with a large investment firm in New York. He keeps an Access database of travel expenditures for all of the auditors within the Oversight and Supervision Division. His database is updated nightly as part of the Computer Operations critical path runtime workload. For Andrew to compute the multiplication and division operations on two fields in his table, he would use the ____ operators.

(Multiple Choice)

4.8/5

(29)

Question 44

To create an input mask, you must be in ____ view.

(Multiple Choice)

4.7/5

(28)

Question 45

Figure AC 7-1 In the accompanying figure, item 1 points to the area showing the table ____.

(Multiple Choice)

4.9/5

(38)

Question 46

Showing 41 - 46 of 46

Exam 7: Enhancing Table Design

The default placeholder is the ____.

When a(n) validation rule is created, data entered into the field must meet the rule requirements.

To create an input mask, you must be in ____ view.

Figure AC 7-1 In the accompanying figure, item 1 points to the area showing the table ____.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters