Loading...

Messages

Proposals

Stuck in your homework and missing deadline?

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Reflect and respond penn foster

15/10/2021 Client: muhammad11 Deadline: 2 Day

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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Guarantee Your Academic Success!

Hire Professional Writers And Get Best Homework Writing Services In Any Subject

6 writers have sent their proposals to do this homework:

Helping Engineer
Homework Master
Financial Hub
Academic Mentor
Innovative Writer
Peter O.
Writer Writer Name Offer Chat
Helping Engineer

ONLINE

Helping Engineer

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$22 Chat With Writer
Homework Master

ONLINE

Homework Master

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$34 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$23 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$48 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$34 Chat With Writer
Peter O.

ONLINE

Peter O.

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$45 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

How does jeep cherokee reach its customers - Good us history research paper topics - Google maps scale ratio - Outbreak at waters edge answers - Employee engagement - Contrec batch controller 414 - ____ control is a method of gathering information about performance deficiencies as they occur. - Ms 500 exam dumps - Gene therapy for color blindness - Criminological theory past to present 6th edition pdf - Week 11 hsa 551 - Psychology - Health Organization Evaluation - Acting character development worksheet - The canterbury tales prologue questions and answers - The last dance despelder pdf - Jb hi fi insurance phone - Approved learning framework victoria - Module 3 Public Human - Frankston special development school - Dulux brunswick green colour - Different types of caves - Discussion question, 150 words, 2 recent reference citations(2019-2020) - Counseling older clients - Tumby bay medical centre - Writing iep goals for reading - George namay dds 6800 central ave toledo oh 43617 - Commedia dell arte stock characters list - Analog multimeter block diagram - English essay - Current Event - Two minute speech word count - Find an equation of the tangent line at each given point on the curve. x = t2 − 4, y = t2 − 2t - Clinic 16 royal north shore - Physical security failed - Put on earth to exterminate thots lyrics - Legacy of racism reflection essay - Cisco packet tracer files - Mid shot camera angle - Analysis of cherry pink and apple blossom white - Henri fayol management theory - Introduction to computer programming mq - Seated tricep extension with cambered bar - CL -- Discussion 3 - Ejb entity bean life cycle - Koch ag and energy solutions wichita ks - Clean kitchen premises and equipment - Http lib stat cmu edu datasets - Create t accounts in excel - Apple 1984 commercial analysis - The great gatsby study questions and answers - Prizm is a segmentation scheme - Accounting excel project - April business simulation - Integrating teams at hernandez & associates - Contemporary Music Influence - Experiment 4 gross anatomy of the muscular system - Difference matters communicating social identity - What does rom mean in ict - Brave new world bernard quotes - Mary palm's checking account had a starting balance - Sheet pile wall design - Inner beacon moreton bay - Neutrogena microdermabrasion system boots - Which ventral cavity subdivision has no bony protection - How does crowdsourcing influence marketing strategy - Circular Motion and Gravitational Forces - Gordon rule essay - How to become financially independent on airbnb free pdf - Community DQ4 - Article notes - Divergence of a vector in cylindrical coordinates - Dc shunt motor circuit diagram - Top10 chemically competent cells - Artwork that uses appropriation - Murgan salem al gohary - Expansion strategy and establishing a reorder point excel - Migraine soap note plan - Staffing process class 12 - Social Problems - Naplan bands year 5 - Disaster managment - Family to family leaving a lasting legacy - Why hard nosed executives should care about management theory summary - Snap core first tutorial - Dana hall funding a mission - Lab alkanes and alkenes datasheet answers - Please read question in comment section 500 words. - Form 956a appointment of a migration agent - The sum of the addends 11 and 15 is - Cessna 172 max flaps for takeoff - Bright guardian akira face reveal - Current Topic 3 - Leaders - Ghost dances full version - Sales account consultant topgolf salary - Public Administrator Generated Information on Economic Developement - Run highlighted code matlab - LOVE GURU【≽+91-9829644411≼】Love Vashikaran Specialist Molvi Ji - Whose ransoms did the general coffers fill - In a 5-7 slide Powerpoint presentation, report on one of these agreements/countries.