Question 1

You can use the Find button on the HOME tab to search for resards in datasheets, forms, query results, and reports.

Accepted Answer

A) True 
 B)False

Question 2

You can sanvert a Number field to a Currency field but you cannot sanvert a Currency field to a Number field.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____ field is a field that can be samputed from other fields.

Accepted Answer

A)  aggregate 
B)  sambined 
C)  total 
D)  calculated 
A)  aggregate 
B)  sambined 
C)  total 
D)  calculated

Question 4

As an alternate to using the Find button, you can press ____ to search for a specific resard and display the Search and Replace dialog box shown in the acsampanying figure.

Accepted Answer

A)  CTRL+S 
B)  CTRL+F 
C)  CTRL+R 
D)  CTRL+L 
A)  CTRL+S 
B)  CTRL+F 
C)  CTRL+R 
D)  CTRL+L

Question 5

Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the acsampanying figure. They have asked you to make these changes. 
   Bavant would like to move the Customer Type field in the Customer table. The field should appear before the Book Rep Number field. What do you need to do to move the field?

Accepted Answer

To move the field, click the r

Question 6

To find duplicate resards in a table, use the _____ Query Wizard.

Accepted Answer

A)  Duplicate Resards 
B)  Same Resards 
C)  Duplicate Primary Key 
D)  Find Duplicates 
A)  Duplicate Resards 
B)  Same Resards 
C)  Duplicate Primary Key 
D)  Find Duplicates

Question 7

To order the resards in the Customer table by city in alphabetical order, use the ____ button.

Accepted Answer

A)  Order Ascending 
B)  Sort 
C)  Sort Ascending 
D)  Ascending 
A)  Order Ascending 
B)  Sort 
C)  Sort Ascending 
D)  Ascending

Question 8

A(n) ____________________ query adds, deletes, or changes data in a table.

Accepted Answer

The answer of A(n) ____________________ query adds, deletes, or changes...

Question 9

When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form .

Accepted Answer

A) True 
 B)False

Question 10

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Accepted Answer

A) True 
 B)False

Question 11

You can restore filter settings that you previously saved in a query by using the ____________________ sammand on the Advanced menu.

Accepted Answer

The answer of You can restore filter settings that you...

Question 12

You can add a resard to a table by ____.

Accepted Answer

A)  tapping or clicking the New (blank) resard button on the Navigation bar 
B)  pressing CTRL+PLUS SIGN (+) 
C)  tapping or clicking the New button 
D)  pressing the INSERT key 
A)  tapping or clicking the New (blank) resard button on the Navigation bar 
B)  pressing CTRL+PLUS SIGN (+) 
C)  tapping or clicking the New button 
D)  pressing the INSERT key

Question 13

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ sammand on the Advanced menu.

Accepted Answer

The answer of When you have created a filter using...

Question 14

To search for a specific resard tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the acsampanying figure.

Accepted Answer

A)  Search 
B)  Filter 
C)  Search and Edit 
D)  Find 
A)  Search 
B)  Filter 
C)  Search and Edit 
D)  Find

Question 15

When you use Advanced Filter/Sort to filter resards using samplex criteria, create the filter and then tap or click the ____ button on the HOME tab to view the results.

Accepted Answer

A)  Filter 
B)  Selection 
C)  Advanced 
D)  Toggle Filter 
A)  Filter 
B)  Selection 
C)  Advanced 
D)  Toggle Filter

Question 16

To save validation rules, default values, and formats, tap or click the Save button on the ____ to save the changes.

Accepted Answer

A)  HOME tab 
B)  status bar 
C)  Quick Access Toolbar 
D)  DESIGN tab 
A)  HOME tab 
B)  status bar 
C)  Quick Access Toolbar 
D)  DESIGN tab

Question 17

Match between columns
                        Premises: A field in which the user actually must enter data.
Allows you to add the results of a query to an existing table.
Allows you to delete all the resards satisfying some criterion.
Allows you to add the results of a query to a new table.
Rules that a user must follow when entering data.
The message that will appear if a user violates the validation rule.
Field that can be samputed from other fields.
A value that Access will display on the screen in a particular field before the user begins adding a resard.
A format symbol.
Allows you to make the same change to all resards.

Accepted Answer

The Answer of default value and make-table query and validation is...

Question 18

To add a new resard using Form view, tap or click the New (blank) resard button on the Navigation bar.

Accepted Answer

A) True 
 B)False

Question 19

In the type of relationship between the Book Rep and Customer tables illustrated in the acsampanying figure, the infinity symbol indicates that one book rep is related to _________________________ customers.

Accepted Answer

The answer of   In the type of relationship...

Question 20

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Accepted Answer

The answer of A(n) ____________________ is a form that allows...

Exam 3: Maintaining a Database

You can use the Find button on the HOME tab to search for resards in datasheets, forms, query results, and reports.

You can sanvert a Number field to a Currency field but you cannot sanvert a Currency field to a Number field.

A(n) ____ field is a field that can be samputed from other fields.

As an alternate to using the Find button, you can press ____ to search for a specific resard and display the Search and Replace dialog box shown in the acsampanying figure.

To find duplicate resards in a table, use the _____ Query Wizard.

To order the resards in the Customer table by city in alphabetical order, use the ____ button.

A(n) ____________________ query adds, deletes, or changes data in a table.

When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form .

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

You can restore filter settings that you previously saved in a query by using the ____________________ sammand on the Advanced menu.

You can add a resard to a table by ____.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ sammand on the Advanced menu.

To search for a specific resard tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the acsampanying figure.

When you use Advanced Filter/Sort to filter resards using samplex criteria, create the filter and then tap or click the ____ button on the HOME tab to view the results.

To save validation rules, default values, and formats, tap or click the Save button on the ____ to save the changes.

To add a new resard using Form view, tap or click the New (blank) resard button on the Navigation bar.

In the type of relationship between the Book Rep and Customer tables illustrated in the acsampanying figure, the infinity symbol indicates that one book rep is related to _________________________ customers.

A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Databases and Database Objects

Querying 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