contestada

Rachel wants to use Microsoft Query to retrieve data from her corporate databases and files so that she doesn't have to retype the data that she wants to analyze in Excel. To do so, she can click and/or enter the following information in the following series of clicks: Data tab > Get External Data group > From Other Sources > From Microsoft Query > Databases tab (To specify a data source for a database, text file, or Excel workbook) > OK > Create New Data Source dialog box > Type a name to identify the data source > Click a driver for the type of database for use as data source > Connect (Provide the information needed to connect to the data source) > OK.
1. True
2. False

Respuesta :

teobguan2019

Answer:

Option: True

Explanation:

Microsoft Query can be used to retrieve data from external source such as databases. There are lots of databases or data sources which are accessible such as Microsoft Access, Microsoft Excel, Microsfot SQL Server OLAP Services, Oracle, Paradox, text file etc.

The steps mentioned in the question are correct. After finishing all the steps, user shall see the name of the data source will appears in the Choose Data Source dialog box.

Lanuel

Rachel can use Microsoft Query to retrieve data from her corporate databases and files by using the aforementioned steps in Microsoft Excel: 1. True.

A database can be defined as a structured (organized) collection of data that are stored on a computer system and are usually accessed in various ways such as electronically.

Microsoft Query is a visual technique in Microsoft Excel that uses a data source to connect to an external database while showing end users the data that are available based on the following criteria:

  • A text string.
  • Name of the data source.
  • A driver for the type of database to be accessed.
  • A default table for the data source.

In order for Rachel to retrieve data from her corporate databases and files, she should use Microsoft Query in Microsoft Excel while following these steps:

1. Click on Data tab.

2. Click on Get External Data group.

3. Select other Other Sources and then click on From Microsoft Query.

4. A dialog box opens, specify the data source for a database.

5. Click on OK.

6. Create a New Data Source.

7. Click on connect and OK after creating a New Data Source.

Read more: https://brainly.com/question/23388493

ACCESS MORE