Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours 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

What command embeds a new spreadsheet

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

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!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Financial Analyst
Coursework Helper
Best Coursework Help
Top Class Results
Top Academic Tutor
Solution Provider
Writer Writer Name Offer Chat
Financial Analyst

ONLINE

Financial Analyst

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.

$30 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$36 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$41 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$26 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$34 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$34 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

Speed of sunlight from the sun to earth - Paralyzed veterans of america free address labels - Nuffield orthopaedic centre oxford - Kung fu panda name - Sayyid qutb hsc notes - Plot diagram template doc - The tempest quotes prospero revenge - Case study on capital budgeting with solution - Week 3 Assignment: Scientific and Mathematical/Analytical Perspectives of Inquiry Paper - Relationship between housing and education - St croix model 488 rotating davits - Axial skeleton lab - The constitution and change essay - Verification of bernoulli's equation lab report - FRAME YOUR ISSUE AND COLLECT YOUR DATA - How can Detroit schools ensure students are able to transition to new routines, expectations, and responsibilities virtually? - Basic steps for data mining process - Choose a sample crime product - Financial accounting provides the primary source of information for - I wanna be yours poem - Myers briggs field marshal - Predator is to prey as owl is to - Wpl wrekin pneumatics ltd - An upstream sale of inventory is a sale - Sam cengage new user - Algebraic equations with fractions worksheet - Columbia southern university algebra 1 - Culture neutral assessment presentation - Determination of specific heat capacity of a metal - Mrs tilscher's class analysis - Leadership MG401 - Justin robinson and the mary onettes - Data mining and its application in healthcare industry - Excel chapter 12 grader project - Tushy ottoman vs squatty potty - Problem statement for data analytics - Guided discovery worksheet cbt - How does akhirah influence a muslim's life - Fife council odeon discount - Difference quotient calculator with work - Pratt truss balsa wood bridge - The economizing problem for society is - Gcse pe paper 1 quiz - Sociology - History - Two way intercom system - Review workplace sustainability policy implementation - With privileged glimpses into the human heart figurative language - C6h12o6 ionic or covalent - Mcq on naive bayes classifier - Wag the dog 303 - Sppa teachers opt out form - Fun home chapter 1 pdf - Discussion about A digital forensics professional - Narrative essay introduction paragraph - Kbr acid or base - Hot rod turn signal wiring diagram - Writing Context - 1o mins quiz for econ - Tyco pressure relief valve - How to write a metanarrative - Black genesis l ron hubbard - Consumer Behavior writing assignment - Paul tillich ultimate concern - Political Parties Essay /no plagiarism / must be original / scholar resource 2015/ must be turn in ready/ cited - Animals that live in trees lesson plan - Nick nightingale resene net worth - Essay - Fire riser room requirements - Cloud in a bottle experiment hypothesis - Economics Question - Southwest region worksheet - Eminent Cricket Live Streaming Regions - Writing your informative explanatory article - Collaborative partnerships with families - Adja hair braiding lagrange ga - Compare and contrast servant leadership and followership - Mchale bale wrapper manual - GHF A.6 - History of homework in america - First 50 triangular numbers - Rhapsody on a windy night - Continuing cookie chronicle answers chapter 4 - Bachman, Ieshia Evans, Baton Rouge (2016).jpg - Animals including humans year 3 - Explain the major difference between statistical and nonstatistical sampling - Osmo polyx oil nz - Marshmallow catapult tissue box - English is a crazy language richard lederer summary - Cardinia shire fire restrictions - Assignment2 - Power factor correction australia - Wgu leadership principles - Imageless thought controversy in psychology - Chapter 12: Discussion - Ninth circle of hell - Bcd to seven segment decoder theory - Write a seven-page minimum research paper with a separate cover sheet - 1984 war is peace ignorance is strength - Worldwide Paper Case - Distributed systems by coulouris