Excel 4-6

Question 1

DSN

Answer 1

Data Source Names- connect to external data sources

• A text file that defines how to connect to an external data source.
• It is listed in the Choose Data Source dialog box.

Question 2

MS Query

Answer 2

• Retrieve just the desired columns and rows
• Retrieve data from multiple tables (or files),
• Filter data at data source before returning the data to Excel
• Access to a greater number of database functions

Question 3

Steps to Use MS Query

Answer 3

1) Create a new Data Source Name (DSN) or use an existing one
2) Use Query Wizard to pull data into Excel
or
2) Use MS Query to pull data into Excel

Question 4

When creating an Excel report to access an external data source- Information

Answer 4

• The data connection information is stored in the Excel report
• A copy of the connection information is saved as a separate Data Source Name (DSN) file in a special folder.

Question 5

If the data source changes

Answer 5

Your Excel report can be refreshed to get the most updated data from the data source.

Question 6

How to add fields in Query Wizard

Answer 6

+

Question 7

How to change name in MS Query

Answer 7

Records> Edit column

Question 8

How to add 2 tables in contagion joint

Answer 8

Multiply 2 together

Question 9

Aggregate function- can you have more than one?

Answer 9

Yes- in query, sum, count, etc

Question 10

Manual Filters

Answer 10

can select

Question 11

Label Filters

Answer 11

Doesn’t include, does include, ends with

Question 12

Value Filters

Answer 12

greater than, less than, top 10 `

Question 13

Inner fields & butter fields

Answer 13

Excle 6

Question 14

Edit query already made

Answer 14

Data> from external> access> Query> find one ur looking for

Question 15

Do you have to type pound sign on each side of data?

Answer 15

No- #