What Is The Easiest Way To View

What Is The Easiest Way To View

Part 1 of 1 - Question 1 of 20 5.0 Points What is the easiest way to view all the relationships between the tables in your Access database? A. Click the Relationships button on the Database Tools tab ribbon. B. Click the Relationships button on the Home tab ribbon. C. Click the Trust Design button on the Home tab ribbon. D. Click the Table Layout button on the Database Tool tab ribbon. Reset Selection Mark for Review What's This? Question 2 of 20 5.0 Points The easiest way for the Access novice to create a query in Access 2007 is to click the __________ button on the __________ tab ribbon. A. Query Wizard; Database Tools B. Query Wizard; Create C. Simple Query; Database Tools D. Simple Query; Create Reset Selection Mark for Review What's This? Question 3 of 20 5.0 Points When you create a query in Access, you are essentially: A. finding relationships between multiple tables. B. finding related data among multiple tables. C. asking the database a question. D. creating a relationship report. Reset Selection Mark for Review What's This? Question 4 of 20 5.0 Points You wish to create a label report. Labels in Access 2007 are identified by: A. how they relate to a table. B. how they are related to the database. C. manufacturer and product number. D. the auto number assigned by Access. Reset Selection Mark for Review What's This? Question 5 of 20 5.0 Points You wish to print the first two pages of a label report created in Access 2007. The place to specify the pages to print is in the: A. Office button menu. B. Label Report View box. C. Print Preview box. D. Print Dialog box. Reset Selection Mark for Review What's This? Question 6 of 20 5.0 Points Which of the mathematical operators below is used as a comparison operator for queries in Access? A. + B. > C. D. / Reset Selection Mark for Review What's This? Question 7 of 20 5.0 Points You are inputting Date/Time data type criteria for the desired fields when creating a query. What is special about the Date/Time data type? A. The date and time must be separated by commas. B. The date values are surrounded by the # symbol. C. The date and time values are surrounded by the % symbol. D. The time must be inputted in military time format. Reset Selection Mark for Review What's This? Question 8 of 20 5.0 Points You have just run a query on your database and you want to save the results. The save button is on the: A. Quick Access Tool above the ribbon tabs. B. Query Report toolbar C. Query Status toolbar. D. Data View toolbar. Reset Selection Mark for Review What's This? Question 9 of 20 5.0 Points You have run a report using the Report Wizard in Access 2007. The report has a column showing a series of dollar amounts but all that shows is a series of ######## symbols instead. What must you do to correct this? A. Rerun the report using the correct data type format. B. Rerun the report, this time checking the Show Currency checkbox. C. Drag the column border to make the column wider. D. Rerun the report selecting the correct fields. Reset Selection Mark for Review What's This? Question 10 of 20 5.0 Points When running reports, the __________view allows for more precision. A. layout B. design C. precision D. details Reset Selection Mark for Review What's This? Question 11 of 20 5.0 Points The Controls group is located on which Access tab ribbon? A. Home B. Create C. External Data D. Design Reset Selection Mark for Review What's This? Question 12 of 20 5.0 Points Rather than dragging controls with the mouse to their desired position, you can utilize the: A. control alignment tools. B. control placement tools. C. control insert drop box. D. control group insert button. Reset Selection Mark for Review What's This? Question 13 of 20 5.0 Points You are running a query in Access 2007. A Dialog box is requesting you to input your criteria. What type of query are you running? A. Control group query B. Input query C. Parameter query D. Results query Reset Selection Mark for Review What's This? Question 14 of 20 5.0 Points The following button in Access 2007, is used to run: A. reports. B. the analyzer tool. C. macros. D. queries. Reset Selection Mark for Review What's This? Question 15 of 20 5.0 Points One benefit of building a report on a Parameter Query is that you can: A. select from multiple database sources. B. display a variety of results from a single query. C. display the results with input from the user. D. run reports in silent mode. Reset Selection Mark for Review What's This? Question 16 of 20 5.0 Points The Text button used to align text within a Report is located in the __________ group. A. Text B. Font C. Control D. Styles Reset Selection Mark for Review What's This? Question 17 of 20 5.0 Points The Group and Sort button is located on the __________ tab ribbon. A. Database Tools B. Format C. Arrange D. Page Setup Reset Selection Mark for Review What's This? Question 18 of 20 5.0 Points You have assigned a Null value to a field for a report. This means the field: A. has a negative value. B. has a non-numeric value. C. has been configured for sorting. D. is empty and has no value. Reset Selection Mark for Review What's This? Question 19 of 20 5.0 Points You want to export an Access report that will preserve the text formatting of the report. What type of file should you choose? A. RTF file B. TXT file C. DOC file D. DOCX file Reset Selection Mark for Review What's This? Question 20 of 20 5.0 Points To make the file visible in a Web browser, you should export the report as a: A. RTF file. B. NotePad file. C. HTML document. D. TXT file. Reset Selection Mark for Review What's This? Part 1 of 1 - Question 1 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 2 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 3 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 4 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 5 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 6 of 20 5.0 Points 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&& Reset Selection Mark for Review What's This? Question 7 of 20 5.0 Points When you add a calculated field to a query it creates a new: A. column. B. table. C. form. D. report. Reset Selection Mark for Review What's This? Question 8 of 20 5.0 Points 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 the criteria. B. Run a second query using the wildcard phrase At*. C. Click the Find button in the Find group and search for Atlanta. D. Run the report wizard using Atlanta as the primary key criteria. Reset Selection Mark for Review What's This? Question 9 of 20 5.0 Points 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 Reset Selection Mark for Review What's This? Question 10 of 20 5.0 Points What does this button, represent in the Controls group? A. A text box B. A caption C. A label D. A font property Reset Selection Mark for Review What's This?