Question 1

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

Accepted Answer

Click the Classification field's criteria row, changed the Classification field's criteria to Sr, clicked the Credits field's criteria row, and changed the Credits field's criteria to >124. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Question 2

Open the wizard that will analyze a table and move redundant data into new tables that are linked to a copy of the original table through lookups.

Accepted Answer

In the External Data Ribbon Tab in the Import & Link Ribbon Group, you clicked the Linked Table Manager button.

Question 3

Export the Tuition query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps.

Accepted Answer

Click the Tuition query, right-clicked the Tuition query. In the Right-Click menu in the Export Options menu, you clicked the Excel menu item. Inside the Export - Excel Spreadsheet dialog, you checked the Export with formatting and layout check box, clicked the OK button. Inside the Export - Excel Spreadsheet dialog, you clicked the Close button.

Question 4

Switch to the view where you can modify the SQL code for the query.

Accepted Answer

In the application footer, you clicked the SQL View button.

Question 5

Rename the table IncomingFreshmenStudents to: NewStudents

Accepted Answer

right-clicked the IncomingFreshmanStudents table. In the Right-Click menu, you clicked the Rename menu item. You clicked the Tables navigation item, renamed the IncomingFreshmanStudents table to NewStudents

Question 6

Export the Housing query to a tab-delimited text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps.

Accepted Answer

Right-clicked the Housing query. In the Right-Click menu in the Export Options menu, you clicked the Text File menu item. Inside the Export - Text File dialog, you clicked the OK button. Inside the Export Text Wizard dialog, you clicked the Advanced... button, clicked the Next > button, selected the Tab Radio Button, checked the Include Field Names on First Row check box, and clicked the Finish button. Inside the Export - Text File dialog, you clicked the Close button. In the application header, you clicked the Save button.

Question 7

This database has been opened with exclusive access. Remove the password from the database. The password is warner.

Accepted Answer

Opened the backstage view, clicked the Decrypt Database button. Inside the Unset Database Password dialog, you typed warner in the Password: input, pressed the Enter key.

Question 8

Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is FR. Run the query

Accepted Answer

You clicked the Classification field's criteria row, changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Question 9

Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.

Accepted Answer

You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or row to CIS. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Question 10

Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.

Accepted Answer

You clicked the Credits field's criteria row, changed the Credits field's criteria to >=120. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Question 11

Start a new query without using one of the query wizards.

Accepted Answer

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button.

Question 12

Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.

Accepted Answer

You clicked the Credits field's sort row, expanded the Credits field's sort options list, and selected the Ascending option. In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Datasheet View menu item.

Question 13

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

Accepted Answer

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 AND, clicked the credits field's or row, and changed the credits field's or row to <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Question 14

Run the Performance Analyzer on all database objects at once. Accept the recommendation and allow Access to make the change for you. When you are finished, close the Performance Analyzer.

Accepted Answer

In the Database Tools Ribbon Tab in the Analyze Ribbon Group, you clicked the Analyze Performance button. You clicked the All Object Types tab. Inside the Performance Analyzer dialog, you clicked the Select All button, clicked the OK button. Inside the Performance Analyzer dialog from the Queries list, you selected Table 'TuitionRates': Add an index to field(s) 'Department'. Inside the Performance Analyzer dialog, you clicked the Optimize button, clicked the Close button.

Question 15

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.

Accepted Answer

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Students. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected DOB. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected Advisor. Inside the Simple Query Wizard dialog, you clicked the > button. Inside the Simple Query Wizard dialog from the Available Fields list, you selected GPA. Inside the Simple Query Wizard dialog, you clicked the > button, clicked the Next > button, clicked the Next > button, typed Tuition in the What title do you want for your query? input, and clicked the Finish button.

Exam Access 2016 3, 8, & 9

Unlock all answers in this set

Haven't found what you need?