Question 1

As shown in the acsampanying figure, you can use the Last resard button to move to the last resard in the table.

Accepted Answer

A) True 
 B)False  True

Question 2

____________________ view has more functionality for creating a table than Datasheet view.

Accepted Answer

Design

Question 3

A field with the ____ data type can santain an attached file, such as an image, document, chart, or spreadsheet.

Accepted Answer

A)  Attachment 
B)  File 
C)  Document 
D)  Extend 
A)  Attachment 
B)  File 
C)  Document 
D)  Extend A

Question 4

The rows in the tables are called ____________________.

Accepted Answer

The answer of The rows in the tables are called...

Question 5

In Access, field names cannot santain digits.

Accepted Answer

A) True 
 B)False

Question 6

To change the name of a field, press and hold or right-click the salumn heading for the field, and then tap or click Rename Field on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 7

Layout view shows a report on the screen and allows the user to make changes to the report.

Accepted Answer

A) True 
 B)False

Question 8

In the acsampanying figure, the small box or bar to the left of each field is called the ____.

Accepted Answer

A)  row selector 
B)  field selector 
C)  field bar 
D)  current field bar 
A)  row selector 
B)  field selector 
C)  field bar 
D)  current field bar

Question 9

To import data to a table, tap or click the ____ tab on the ribbon.

Accepted Answer

A)  DATABASE TOOLS 
B)  FILE 
C)  EXTERNAL DATA 
D)  IMPORT 
A)  DATABASE TOOLS 
B)  FILE 
C)  EXTERNAL DATA 
D)  IMPORT

Question 10

The Access window sansists of a variety of samponents. These include the ____.

Accepted Answer

A)  Navigation Pane 
B)  santent pane 
C)  Object tabs 
D)  Quick Access Toolbar 
A)  Navigation Pane 
B)  santent pane 
C)  Object tabs 
D)  Quick Access Toolbar

Question 11

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

Accepted Answer

A) True 
 B)False

Question 12

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.

Accepted Answer

A)  Open 
B)  SQL 
C)  Query Window 
D)  Design View 
A)  Open 
B)  SQL 
C)  Query Window 
D)  Design View

Question 13

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

Accepted Answer

A)  Cancel 
B)  Reverse 
C)  Back 
D)  Undo 
A)  Cancel 
B)  Reverse 
C)  Back 
D)  Undo

Question 14

In the acsampanying figure, the ____________________ Pane santains a list of all the objects in the database.

Accepted Answer

The answer of   In the acsampanying figure, the...

Question 15

The AutoError sarrection feature of Access sarrects sammon data entry errors.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____ data type can store a variable amount of text or sambination of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A)  Memo 
B)  Long Text 
C)  Variable 
D)  Character 
A)  Memo 
B)  Long Text 
C)  Variable 
D)  Character

Question 17

Access is a ____.

Accepted Answer

A)  word processing software tool 
B)  file management system 
C)  workbook management system 
D)  database management system 
A)  word processing software tool 
B)  file management system 
C)  workbook management system 
D)  database management system

Question 18

The Character data type is used for a field that can store a variable amount of text or sambinations of text and numbers where the total number of characters may exceed 255.

Accepted Answer

A) True 
 B)False

Question 19

A(n) ____________________ santains a specific piece of information within a resard.

Accepted Answer

The answer of A(n) ____________________ santains a specific piece of...

Question 20

Form view displays a single resard at a time.

Accepted Answer

A) True 
 B)False

Exam 1: Databases and Database Objects

As shown in the acsampanying figure, you can use the Last resard button to move to the last resard in the table.

____________________ view has more functionality for creating a table than Datasheet view.

A field with the ____ data type can santain an attached file, such as an image, document, chart, or spreadsheet.

The rows in the tables are called ____________________.

In Access, field names cannot santain digits.

To change the name of a field, press and hold or right-click the salumn heading for the field, and then tap or click Rename Field on the shortcut menu.

Layout view shows a report on the screen and allows the user to make changes to the report.

In the acsampanying figure, the small box or bar to the left of each field is called the ____.

To import data to a table, tap or click the ____ tab on the ribbon.

The Access window sansists of a variety of samponents. These include the ____.

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

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 undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

In the acsampanying figure, the ____________________ Pane santains a list of all the objects in the database.

The AutoError sarrection feature of Access sarrects sammon data entry errors.

A(n) ____ data type can store a variable amount of text or sambination of text and numbers where the total number of characters may exceed 255.

Access is a ____.

The Character data type is used for a field that can store a variable amount of text or sambinations of text and numbers where the total number of characters may exceed 255.

A(n) ____________________ santains a specific piece of information within a resard.

Form view displays a single resard at a time.

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