When you add a calculated field to a query it creates a new

Assignment Help Database Management System

Reference no: EM13818741

1. In which type of scenario would you place two criteria in the criteria row when creating a query?
a. When looking for two separate values
b. When using the AND logical operator for both values
c. When each criterion is designated for a separate database
d. When using the OR logical operator for the two values

2. In which type of scenario would you place two criteria in different rows in the query design grid?
a. When looking for two separate values
b. When using the AND logical operator for both values
c. When each criterion is designated for a separate database
d. When using the OR logical operator for the two values

3. You need to access the property sheet button to modify the settings for a form you are creating in order to change the background color of the form. You would access this button in the ______ group of the ________ tab ribbon.
a. Tools; arrange
b. Tools; format
c. Formatting; arrange
d. Formatting; format

4. You need to access the align text center button in order to center the text at the top of a form. You need to access this button in the _______ group of the _________ ribbon.
a. Font; arrange tab
b. Font; form layout
c. Font; format tab
d. Font; home tab

5. You are running a query on your database. You want to query any customer's last name that starts with an R. What wildcard characters would you type?
a. [R]
b. *
c. R#
d. R*

6. You are tracking what numbers have won the lottery every night. There are three numbers in a row and you want to see how many times the winning numbers started with the number 5. How would you query this using a wildcard?
a. 5$
b. *
c. 5##
d. 5&&

7. When you add a calculated field to a query it creates a new:
a. Column
b. Table
c. Form
d. Report

8. You have just run a query to find out how many customers spent over $500 this year with you. You now want to see how many of these same customers live in Atlanta. What is the easiest way to do this?
a. Run a second query with Atlanta as criteria
b. Run a second query using the wildcard phrase At*
c. Click the find button in the editing group and search for Atlanta
d. Run the report wizard using Atlanta as the primary key criteria

9. A summary statistic could provide which of the following?
a. The number of records within a table
b. The batting average for the players on a team
c. Customers whose first name starts with a J
d. The number tables a record is related to

10. What does this button, Aa represent in the control group?
a. A text box
b. A caption
c. A label
d. A font property

11. You are creating a report in access 2007 but you see all of the tools you need to configure the report as you want. What can you do?
a. Import the tools you need from the Microsoft web site.
b. Click on the additional tool button on the database tools tab ribbon
c. Click on the hidden tool button on the database tools tab ribbon
d. Switch to design view to see additional tools on the design tab ribbon

12. You have added a textbox to a report using the control group tools. You want to change the placement of the text box. How do you do this?
a. Click the indent buttons on the home tab ribbon.
b. Click the movement buttons on the home tab ribbon.
c. Press the arrow keys on the keyboard.
d. Press the tab key on the keyboard.

13. You insert a label into the report footer of an access report. Where will it be displayed?
a. On the first page of the report
b. On the last page of the report
c. In the footer section of every page
d. In the report notes summary

14. You insert a text box into the page header. Where will it be displayed?
a. On the first page of the report
b. On the last page of the report
c. In the header section of every page
d. In the page notes summary

15. You want to configure conditional formatting for the fonts in an access report. How do you access this setting?
a. Click the conditional button in the font group on the design tab ribbon
b. Click the conditional button in the font group on the home tab ribbon
c. Click the font button arrow on the home tab ribbon and choose conditional formatting.
d. Click the font button arrow on the design tab ribbon and choose conditional formatting.

16. Which view will you be working in by default when you use the blank report tool?
a. Design
b. Layout
c. Form
d. Report

17. Which of the selections below is NOT a tool found in the controls group?
a. Date and time button
b. Title button
c. Gridlines button
d. Logo button

18. You want to use a chart in a report to visually display the data from a recent query. What is the easiest way to do this?
a. Click the import chart button in the controls group and select excel chart
b. Click the import chart button in the controls group and select PowerPoint Chart.
c. Use the PowerPoint chart wizard tool located on the create tab ribbon
d. Click the chart wizard button in the controls group.

19. How do you access the access options dialog box?
a. Click the access options button on the design tab ribbon
b. Click the access options button on the arrange tab ribbon
c. Click the access options button on the create tab ribbon
d. Click the access options button after pressing the office button

20. In which section of the access options can you access navigation options?
a. Popular
b. Current database
c. Advanced
d. Navigation

Reference no: EM13818741

Questions Cloud

Annual increase in income : Your firm has $45.0 million invested in accounts receivable, which is 90 days of net revenues. If this value could be reduced to 50 days, what annual increase in income would your firm realize if the increase in cash could be invested at 7.5 perce..

Evelop the ability to communicate a pricing strategy : Achieve an understanding of the theory and techniques of company and product/service pricing. Develop the ability to communicate a pricing strategy

Appropriate hypotheses statements : What examples (professional, personal, social) can you provide on when we might use each type? What would be the appropriate hypotheses statements for each example?

Discuss your choice of two reasons excuses : Discuss your choice of two reasons (excuses?) mentioned within "Not Doing It By the Book" that we neglect to read -- or downright ignore -- manuals, instructions, quick guides, etc.

When you add a calculated field to a query it creates a new : When you add a calculated field to a query it creates a new

How writing for the workplace differ from writing in college : How might writing for the workplace differ from writing in college? Describe some of the important ways that writing functions in the workplace or other professional contexts.

Operating system for an existing machine : A new operating system for an existing machine is expected to cost $520,000 and have a useful life of six years. The system yields an incremental after-tax income of $150,000 each year after deducting its straight-line depreciation. The predicted ..

What is the depreciation expense : The average useful life for commercial buildings is 25 years. What is the depreciation expense for the 90%/10% allocation?

How job analysis could be used at customers first : Determine how job analysis and job evaluation could be used at Customers First to develop an internally consistent compensation system.

User Account

All Pages