Ms access Archives

1. How can you display sales grouped by country, region, and salesperson, all at the same time? A. Use the Sort Descending command. B. Use the Pivot table view command C. Use the find command on specified groups D. All of above

Use the Sort Descending command.

Use the Pivot table view command

Use the find command on specified groups

All of above

Detailed SolutionHow can you display sales grouped by country, region, and salesperson, all at the same time? A. Use the Sort Descending command. B. Use the Pivot table view command C. Use the find command on specified groups D. All of above

2. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command A. File menu B. View menu C. Database menu D. Tools menu

File menu

View menu

Database menu

Tools menu

Detailed SolutionTwo tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command A. File menu B. View menu C. Database menu D. Tools menu

3. Which function extracts the name of the month from a date/time value? A. Month B. MonthName C. MonthLabel D. MonthValue

Month

MonthName

MonthLabel

MonthValue

Detailed SolutionWhich function extracts the name of the month from a date/time value? A. Month B. MonthName C. MonthLabel D. MonthValue

4. Which of the following is not a form style available in the form wizard dialog box. A. Blends B. Standard C. Stone D. Highlights

Blends

Standard

Stone

Highlights

Detailed SolutionWhich of the following is not a form style available in the form wizard dialog box. A. Blends B. Standard C. Stone D. Highlights

5. Which part of the IIF expression is the action performed if the true condition exists? A. inner B. first C. second D. third

inner

first

second

third

Detailed SolutionWhich part of the IIF expression is the action performed if the true condition exists? A. inner B. first C. second D. third

6. how do you update pivot table report data after changes are made to the source data? A. Save your changes, close the workbook, and then reopen it. B. Select the pivot table worksheet and press f9 on the keyboard C. Click the report, and on the pivot table toolbar, click the refresh data button D. All of the above

Save your changes, close the workbook, and then reopen it.

Select the pivot table worksheet and press f9 on the keyboard

Click the report, and on the pivot table toolbar, click the refresh data button

All of the above

Detailed Solutionhow do you update pivot table report data after changes are made to the source data? A. Save your changes, close the workbook, and then reopen it. B. Select the pivot table worksheet and press f9 on the keyboard C. Click the report, and on the pivot table toolbar, click the refresh data button D. All of the above

7. The report footer section is most useful for displaying: A. grand totals B. Column headings C. subtotals D. page numbers

grand totals

Column headings

subtotals

page numbers

Detailed SolutionThe report footer section is most useful for displaying: A. grand totals B. Column headings C. subtotals D. page numbers

8. Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join

Inner join

Left outer join

Right outer join

Self join

Detailed SolutionWhich of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join

9. It is a sign or symbol that specifies, operator, and values that produce a result A. operator B. query C. expression D. None of the above

operator

query

expression

None of the above

Detailed SolutionIt is a sign or symbol that specifies, operator, and values that produce a result A. operator B. query C. expression D. None of the above

10. It is a database object to view, change, and analyze data in different ways A. query B. form C. report D. None of the above

query

form

report

None of the above

Detailed SolutionIt is a database object to view, change, and analyze data in different ways A. query B. form C. report D. None of the above

Page 1 Page 2 Page 3 Page 4 Page 5

Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 Test 7 Test 8 Test 9 Test 10

Exit mobile version