Reflect and respond penn foster

Advanced In Microsoft Access

Microsoft Access 2016

Click the _______ Design button to create a select query.

A. Query

B. Table

C. Form

D. Report

_______ are used to store all the data in a database.

A. Fields

B. Tables

C. Queries

D. Forms

In a complex query, a _________ allows for data to be searched on multiple criteria.

A. primary key

B. relational comparison

C. comparison

D. logical operator

A previously saved labels report can be accessed from the

A. Layout Tools tab.

B. Create tab.

C. Home tab.

D. Navigation pane.

The purpose of a report is to

A. organize and summarize data.

B. sort data chronologically.

C. search for specific data points.

D. filter data.

To see all of the records at once, you should use _______ view.

A. Table

B. Form

C. Datasheet

D. Report

Which tab is typically used to delete an entire record?

A. Home

B. External Data

C. Create

D. Database Tools

What is the fastest way to locate a record for updating?

A. Use the search box.

B. Review the data in Form view.

C. Use the Report view.

D. Review the data in Table view.

What field would you use to store a value from another table?

A. Lookup

B. Hyperlink

C. AutoNumber

D. Memo

A database is a collection of ________ data.

A. queried

B. related

C. object

D. reported

Assume you're running a query on your orders in the past year. You want to see how many orders were placed after May. What type of query would you use to find this data?

A. Select

B. Range

C. Parameter

D. Complex

Labels are typically designated by

A. product number.

B. date.

C. alphabetical order.

D. type.

A _______ object is used for storing data.

A. table

B. report

C. form

D. query

Where is data stored in an Access database?

A. Related objects

B. Query objects

C. Form objects

D. Table objects

A ______ object is used for displaying the results of a question based on stored data.

A. report

B. form

C. table

D. query

On which tab is the Report button located?

A. Create

B. Home

C. External data

D. Add-ins

In Access, data is stored in a _______ once a form is completed.

A. record

B. page

C. cell

D. form

If you're doing a relational comparison, which filter would be available?

A. Date

B. Text

C. Number

D. Currency

Which of the following is used to manage the objects in a database?

A. Navigation pane

B. File tab

C. The Ribbon

D. Window controls

What operator is used to create a validation rule?

A. /

B. –

C. < or >

D. +

Integrating Word, Excel, and Other Data into PowerPoint

In the Pictures in album list, what indicates which slide each photo will be placed on?

A. Numbers

B. Checked boxes

C. Captions

D. Titles

As you type your outline, click Demote to move a line of text

A. out one level.

B. out two levels.

C. in one level.

D. in two levels.

What type of slide show is a dynamic and eye-catching way to familiarize potential customers with what your company has to offer?

A. Brochure

B. Photo album

C. OLE

D. Office Clipboard

A Level 2 topic in a Word outline will be used in PowerPoint to create a

A. second-level bullet item.

B. third-level bullet item.

C. slide title.

D. first-level bullet item

Which of these commands allows you to navigate to the outline file that will be integrated into a presentation?

A. Slide > From Outline

B. Edit Data > Edit Data

C. New Slide > Slides from Outline

D. Document Object > Edit

How do you change the number of rows and columns displayed for an embedded Excel object on a PowerPoint slide?

A. Deselect the Excel object and drag a row or column divider of the object.

B. Deselect the Excel object and drag a size handle of the object.

C. Double-click the Excel object and drag a row or column divider on the active object.

D. Double-click the Excel object and drag a size handle on the active object

You can store data copied from any Office application file with the

A. Outline Clipboard.

B. Office Clipboard.

C. Home tab.

D. File tab.

How do you insert an Excel worksheet object into a presentation?

A. Object > Excel Spreadsheet

B. Linked Worksheet Object > Edit

C. Table > Excel Spreadsheet

D. Object > Create from File

It's usually easier to change the design of a photo album slide show

A. before you've created the presentation.

B. before you've planned out the presentation.

C. after you've created the presentation.

D. after you've planned out the presentation but before creating it

What does the Level 1 topic in a Word outline become in PowerPoint?

A. Second-level bullet item

B. Third-level bullet item

C. First-level bullet item

D. Slide title

In the Photo Album dialog box, what are the first two buttons used for?

A. Rotating an image

B. Recoloring an image

C. Increasing or decreasing the brightness of an image

D. Increasing or decreasing the contrast of an image

How would you change the size of an embedded Excel object?

A. Deselect the Excel object and drag a row or column divider of the object.

B. Deselect the Excel object and drag a size handle of the object.

C. Double-click the Excel object and drag a row or column divider on the active object.

D. Double-click the Excel object and drag a size handle on the active object

How do you set up a slide show to play continuously, advancing through all the slides without requiring your interaction?

A. Click Set Up Slide Show, and then select the Loop continuously until ‘Esc' and Use timings, if present options.

B. Click Set Up Slide Show, and then select the Loop continuously until ‘Esc' and Show without narration options.

C. Click Set Up Slide Show, and then select the Show Presenter View and Use timings, if present options.

D. Click Set Up Slide Show, and then select the Show without animation and Browsed at a kiosk (full screen) options

If you embed a Word table into PowerPoint, what happens when you make edits to the embedded data?

A. Edits made to embedded data change the data in the source file; however, edits made to the source file will not be reflected in the embedded data.

B. Edits made to embedded data don't change the data in the source file, nor will edits made to the source file be reflected in the embedded data.

C. Edits made to embedded data will change the data in the source file, and edits made to the source file will be reflected in the embedded data.

D. Edits made to embedded data don't change the data in the source file; however, edits made to the source file will be reflected in the embedded data

15. On the Transitions tab, in the _______ group, you can set slides to automatically advance after a set number of seconds.

A. Preview

B. Transition to This Slide

C. Photo Album

D. Timing

16. A/An _______ Word document contains headings and subheadings formatted using commands.

A. outline

B. caption

C. embedded

D. source

17. From the Insert Object dialog box, what option should be selected to insert an entire worksheet as a shortcut to the source file?

A. Display as icon

B. Link

C. Create from file

D. Create new

18. How do you activate a linked chart?

A. Double-click the chart and select Edit Data > Edit Data.

B. Click the chart and select Edit Data > Edit Data.

C. Click the chart.

D. Double-click the chart.

19. Using the _______ list, you can select the number of photos that will appear on each slide.

A. Theme

B. Pictures in album

C. Picture layout

D. Frame shape

20. Which Paste command is used to insert a new linked Excel worksheet into a PowerPoint presentation?

A. Paste Special

B. Embed

C. Keep Source Formatting

D. Use Destination Styles

Lesson Name: Integrating Word, Access, and Excel

1. A mail merge allows you to create personalized _______, which allow you to insert a predefined list of data into text.

A. form letters

B. data sources

C. mailing lists

D. fields

2. On which tab are import and export commands located in Access?

A. Home

B. Database Tools

C. Create

D. External Data

3. Which of the following is the best way to add a lengthy explanation to Excel data without being limited to cell sizes and restrictions?

A. Adding an Access object

B. Adding a Word object

C. Adding an Excel object

D. Adding a chart object

4. To select Access database entries, you should be in

A. Datasheet view.

B. Form Design.

C. Query wizard.

D. Design view

5. A _______ document is the file containing information to be copied.

A. source

B. embedded

C. linked

D. destination

6. Which button would you use to quickly add addresses to a mail merge envelope?

A. Address Block

B. Greeting Line

C. Insert Merged Fields

D. Update Labels

7. The first thing you should select if you're using an Address Block or Greeting Line is

A. Insert Merged Field.

B. Match Fields.

C. Edit Recipient List.

D. Start Mail Merge

8. In Excel, what tab would you use to add a Word object?

A. Insert

B. Formulas

C. Home

D. Data

9. How do you change the number of rows and columns displayed by an Excel object?

A. Click outside the Excel object and drag a size handle.

B. Insert a column into Excel and it will automatically enlarge.

C. Insert a row into Excel and it will automatically enlarge.

D. Drag a size handle on the active object.

10. A compound document has

A. the computing power of a spreadsheet.

B. more than one application interface.

C. only one application interface.

D. a spreadsheet embedded

11. A mail merge combines _______ with document content.

A. form letters

B. a field

C. a mailing list

D. a data source

12. Assume you're sending a holiday greeting card to all your clients in the United States. Which of the following is considered a viable data source?

A. A PowerPoint slide with a list of names and addresses.

B. A query from Access with names and addresses

C. A Word document with a list of names and addresses

D. An Excel file with a list of names

13. When adding text to an Excel worksheet, which option displays the Word window features?

A. Typing in cell

B. There are no options that show the Word window features.

C. Word object

D. Text box

14. Assume you have an Access database with five different tables, including various pieces of information about your client base. You want to pull information from Table 1, which includes your client names and addresses. From Table 2, you want to pull information on how much they've paid for your product in the past year. What is the best way to set this up for a mail merge?

A. Copy the two tables from Access to Excel, and then perform the mail merge from Word.

B. Create a query that includes the required information for the mail merge.

C. Export both tables from Access and import them into Word to complete the mail merge.

D. Manually retype the lists into Word to complete the mail merge

15. An active chart displays _______ features.

A. Excel

B. Access

C. Word

D. no

16. Assume you had a .csv file with data already populated that you wanted to use for a mail merge. Which button would you press to import the text?

A. From Other Sources

B. From Access

C. From File

D. From Text

17. A data source contains

A. numerical characters only.

B. a collection of organized data.

C. random data that will then be organized.

D. text-based characters only.

18. What does adding a greeting line allow you to add to a letter?

A. The date

B. A recipient's name

C. An invoice number

D. An address

19. Once you've connected to a data source, which button would you select to add a first name to your form letter?

A. Address Block

B. Greeting Line

C. Highlight Merge fields

D. Insert Merge Field

20. Which tab in Excel would you use to import information?

A. Insert

B. Data

C. Review

D. Formulas