Access Practice Exam 2 questions
with verified answers graded A+
From Design view, hide the navigation buttons for the sub form. - correct answer ✔✔ Go to the
form properties in design view and under the FORMAT tab look for NAVIGATION BUTTONS and
select NO.
Which of the following can be used to copy a file into OneDrive from the File Explorer window?
Select all that apply from the list on the right, then click Done. - correct answer ✔✔ You chose
Ctrl + C > Ctrl + V, chose Copy button > Paste button, and clicked the Done button.
Add a calculated control without a label to the right of the Release Date control in the Detail
section to calculate the value of the Release Date field - the Datafile field for each individual
record. - correct answer ✔✔ On the Report Design tools tab, in the controls group, click the
TEXT BOX button. If the controls gallery is not visible on the Ribbon, click the CONTROLS button
to display it. Press CTRL key and click the report to the right of the LabFee field. On the Report
Design Tools Design tab, in the Tools group click the Property Sheet button. On the property
sheet data tab click the CONTROL SOURCE property, ant type: =[Credits]*[CreditHourFee]+
[LabFee] and press enter.
From Design view, align the selected controls at the top. - correct answer ✔✔ On the Report
Design Tools Arrange tab, in the Sizing & Ordering group, click the align button, and select top.
Which category would you use to customize the background for your computer? Select your
answer from the list on the right, then click Done. - correct answer ✔✔ You chose
Personalization, chose System, chose Personalization, and clicked the Done button.
Add a subform to the bottom of this form to display all the fields from the WageIncreases table.
Accept the relationship suggested by Access, and accept the suggested name for the subform. -
correct answer ✔✔ On the Form Design Tools Design tab, in the Controls group, expand the
, Controls gallery by clicking the More button. Click the Subform/Subreport button. Click in the
empty area at the bottom of the form. Click Next. Expand the Tables/Queries list and select
Table: WageIncreases. Click the >> button. Click Next. Click Next. Click Finish.
Split this database into separate front end and back end files. Name the back end file:
Payroll_be - correct answer ✔✔ On the Database Tools tab, in the Move Data group, click the
ACESS DATABASE button. Click the SPLIT DATABASE button. CLick the SPLIT button. Click OK.
Which of the following can be used to create a new folder from the OneDrive Web site? Select
all that apply from the list on the right, then click Done. - correct answer ✔✔
Use the wizard to create a query to display records from the Staff table without matching
records in the InsurancePlans table. Accept the MedicalInsurance field as the field that might
contain matches. Include the LastName and FirstName fields (in that order) in the query results.
Accept the suggested query name, and view the query results when finished. - correct answer
✔✔ EXTRA STEP- On the Create tab, in the queries group, click the QUERY WIZARD button. Click
FIND UNMATCHED QUERY WIZARD and click OK. Click TABLE:STUDENTS. Click NEXT. Click
TABLE:FACULTY. Click NEXT.Click NEXT. Double-click STUDENTID. Double-click LASTNAME. Click
Next. CLick FINISHED.
Modify this database so the Navigation Pane is hidden when the database is opened. - correct
answer ✔✔
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. - correct answer ✔✔ On the Database Tools tab, in the Analyze group, click the
ANALYZE PERFORMANCE button. Click the ALL OBJECT TYPES tab. Click the SELECT ALL button.
Click OK. CLick the recommendation to add an index to the TuitionRates table. click the
OPTIMIZE button. Click the CLOSE button.
Open the Payroll database from the My Documents folder with exclusive access and add the
password griffin. - correct answer ✔✔ Click the FILE tab to open Backstage. Click the OPEN
with verified answers graded A+
From Design view, hide the navigation buttons for the sub form. - correct answer ✔✔ Go to the
form properties in design view and under the FORMAT tab look for NAVIGATION BUTTONS and
select NO.
Which of the following can be used to copy a file into OneDrive from the File Explorer window?
Select all that apply from the list on the right, then click Done. - correct answer ✔✔ You chose
Ctrl + C > Ctrl + V, chose Copy button > Paste button, and clicked the Done button.
Add a calculated control without a label to the right of the Release Date control in the Detail
section to calculate the value of the Release Date field - the Datafile field for each individual
record. - correct answer ✔✔ On the Report Design tools tab, in the controls group, click the
TEXT BOX button. If the controls gallery is not visible on the Ribbon, click the CONTROLS button
to display it. Press CTRL key and click the report to the right of the LabFee field. On the Report
Design Tools Design tab, in the Tools group click the Property Sheet button. On the property
sheet data tab click the CONTROL SOURCE property, ant type: =[Credits]*[CreditHourFee]+
[LabFee] and press enter.
From Design view, align the selected controls at the top. - correct answer ✔✔ On the Report
Design Tools Arrange tab, in the Sizing & Ordering group, click the align button, and select top.
Which category would you use to customize the background for your computer? Select your
answer from the list on the right, then click Done. - correct answer ✔✔ You chose
Personalization, chose System, chose Personalization, and clicked the Done button.
Add a subform to the bottom of this form to display all the fields from the WageIncreases table.
Accept the relationship suggested by Access, and accept the suggested name for the subform. -
correct answer ✔✔ On the Form Design Tools Design tab, in the Controls group, expand the
, Controls gallery by clicking the More button. Click the Subform/Subreport button. Click in the
empty area at the bottom of the form. Click Next. Expand the Tables/Queries list and select
Table: WageIncreases. Click the >> button. Click Next. Click Next. Click Finish.
Split this database into separate front end and back end files. Name the back end file:
Payroll_be - correct answer ✔✔ On the Database Tools tab, in the Move Data group, click the
ACESS DATABASE button. Click the SPLIT DATABASE button. CLick the SPLIT button. Click OK.
Which of the following can be used to create a new folder from the OneDrive Web site? Select
all that apply from the list on the right, then click Done. - correct answer ✔✔
Use the wizard to create a query to display records from the Staff table without matching
records in the InsurancePlans table. Accept the MedicalInsurance field as the field that might
contain matches. Include the LastName and FirstName fields (in that order) in the query results.
Accept the suggested query name, and view the query results when finished. - correct answer
✔✔ EXTRA STEP- On the Create tab, in the queries group, click the QUERY WIZARD button. Click
FIND UNMATCHED QUERY WIZARD and click OK. Click TABLE:STUDENTS. Click NEXT. Click
TABLE:FACULTY. Click NEXT.Click NEXT. Double-click STUDENTID. Double-click LASTNAME. Click
Next. CLick FINISHED.
Modify this database so the Navigation Pane is hidden when the database is opened. - correct
answer ✔✔
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. - correct answer ✔✔ On the Database Tools tab, in the Analyze group, click the
ANALYZE PERFORMANCE button. Click the ALL OBJECT TYPES tab. Click the SELECT ALL button.
Click OK. CLick the recommendation to add an index to the TuitionRates table. click the
OPTIMIZE button. Click the CLOSE button.
Open the Payroll database from the My Documents folder with exclusive access and add the
password griffin. - correct answer ✔✔ Click the FILE tab to open Backstage. Click the OPEN
