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

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!

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:

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

Titration of hcl and naoh experiment - Survival in life is beautiful - Introduction to programming using python y daniel liang pdf - East riding college moodle - What size shoe is a 9 year old - 6 hobson street sandringham - Wk#4 Research paper - 21 pilots car radio lyrics - Dplyr & ggplot2 - She walks in beauty - Rothe erde slew bearing catalogue - Paper 4 - Value proposition canvas strategyzer pdf - Coreldraw for screen printing - Module 2 wellness plan flvs answers - Where do you start your letters song - Australian standards for ceramic tiles - Performance - Philosophy Nr 347/ critical reasoning , thinking - What is psychometrics in psychology - Original miracle skinny drops - SOC discussion - List and discuss three prominent application areas for text mining - Mehr housing project iran - Icd 9 code for lumbar fusion surgery - Equation of energy efficiency - Bio ethics guiding assignment - Microsoft lync web client - Assume you are planning to invest $5000 - How much heat required to raise the temperature of water - What is muscular strength and how is it measured - Essay on a midsummer nights dream - Under armour financial report 2017 - Disney parks and resorts strategy - Criminology explaining crime and its context 10th edition pdf - Httpcontext current user isinrole - Denture base materials classification - Essay on What china is doing to control the antidumping policies - 3 pages 2 hrs - Assignment Buisness Law 1 - Gas gas gas poem - Lost at sea group activity answers - Reasons to use cellphones in school - C.wright mills claimed that the sociological imagination transformed - Presentational techniques english gcse - Loreal american corporation purchased several - Discussion: Growth, Inequality and Poverty - Brave new world quotes - Difference between acfm and scfm - Describe the fight between the stable buck and smitty - Which of the following has zero dipole moment - Tweenies karaoke boom boogie - The following information is available for remmers corporation for 2014 - Eating disorder inventory 3 pdf - A clothier makes coats and slacks - Guidelines to formal etiquette quite clearly stipulate that - Schuster institute for investigative journalism - Swot analysis between walmart and target - Margin call real firm - 250 word essay Explain how action potentials change in response to stimulus intensity. Use an example from the human visual system to illustrate this process - List of oxidising and reducing agents - Mechanical, personal, or neuromarketing methods are ways that __________ data can be collected. - Explain the agency problem in financial management - Ccms helpdesk contact number - 2019 vce scaling report - Molar mass of ethanol c2h6o - Overhead crane runway design - Can you make your own coat of arms - E3 8 adjusting entries - Nfpa 99 pdf free - Discussion - I need help in creating E. Final Overall Compensation Structure: Formatting must include an APA title page and be free of grammar, spelling and/or punctuation issues. - Ice cream machine rental des moines iowa - Cisco academy support center - The arson for profit course ielts answer - Week 6 - Assignment Overview - Ge creditline com au osc - Https www youtube com watch v yr5cjyokvus - All epithelial tissue rests upon - Tender price index calculation - Class ii division 1 - Duress and undue influence essay - Tank world coffs harbour - 6 cycle semi log graph paper - Five students took a math test - Nursing soap note for uti - Consumer Behavior Assignment 2 - Community health - 10 pages related to (ERP , IT) and ( MBA,IT ) - Working memory model diagram - Outline and rubric evaluation univ 104 - All at onceness of a painting - Harvard mit cross registration - Yeo valley primary school - Binding constraint shadow price - Negative beta stocks list - Physics 210 homework 4 - Coca cola strategic management report - Business ethics richard degeorge pdf - Let the carnival begin every pleasure every sin