Exam 1: Microsoft Access Basics

Explore all topics

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

(Multiple Choice)

4.9/5

(33)

Question 21

A record is an incomplete set of data.

(True/False)

4.8/5

(39)

Question 22

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

(Multiple Choice)

4.9/5

(34)

Question 23

After you delete a record, you can use the Undo command to restore it.

(True/False)

4.8/5

(36)

Question 24

A computerized DBMS is ____ than using file folders.

(Multiple Choice)

4.7/5

(25)

Question 25

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. Jonathan has information in Excel worksheets that he wants to add to the database. Worksheets are similar to datasheets, so he chooses to transfer this information into ____ objects.

(Multiple Choice)

4.7/5

(23)

Question 26

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

(Short Answer)

4.9/5

(38)

Question 27

Each object has a different ____________________ to identify its function.

(Short Answer)

4.8/5

(33)

Question 28

A database is a collection of ____.

(Multiple Choice)

4.7/5

(36)

Question 29

When you are navigating in Datasheet view, pressing Shift+Tab ____.

(Multiple Choice)

4.9/5

(40)

Question 30

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

(Multiple Choice)

5.0/5

(36)

Question 31

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

(True/False)

4.7/5

(26)

Question 32

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

(True/False)

4.7/5

(34)

Question 33

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

(True/False)

4.9/5

(38)

Question 34

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

(Multiple Choice)

4.8/5

(31)

Question 35

____ is a program known as a database management system (DBMS).

(Multiple Choice)

4.9/5

(33)

Question 36

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

(Multiple Choice)

4.8/5

(26)

Question 37

After opening a database, the Navigation Pane opens on the left side of the screen.

(True/False)

4.8/5

(40)

Question 38

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

(Short Answer)

4.7/5

(26)

Question 39

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

(Multiple Choice)

4.8/5

(35)

Question 40

Showing 21 - 40 of 46

Exam 1: Microsoft Access Basics

Case AC 1-1 Jonathan is the IT manager for a Toy Company and is looking into using different types of database objects. The Sales Manager has asked Jonathan to consolidate data from several tables into a format similar to a paper form. In this case, Jonathan would use the ____ object.

A record is an incomplete set of data.

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

After you delete a record, you can use the Undo command to restore it.

A computerized DBMS is ____ than using file folders.

A(n) ____________________ is used to search for and retrieve data from tables using conditions.

Each object has a different ____________________ to identify its function.

A database is a collection of ____.

When you are navigating in Datasheet view, pressing Shift+Tab ____.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

To make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet.

Backing up a database rearranges how the database is stored on the disk and optimizes the performance of the database.

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

You can print a datasheet by clicking the File tab, clicking Print in the navigation bar, and then clicking ____ to print the datasheet using the default printer and the default print.

____ is a program known as a database management system (DBMS).

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

After opening a database, the Navigation Pane opens on the left side of the screen.

You can change the colors used in the rows of the datasheet by clicking the arrow on the Alternate Row Color button in the Text Formatting group on the ____________________ tab.

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

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