Access Practice Exam 2 || with Complete Solutions.
From Design view, hide the navigation buttons for the subform. correct answers 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 answers 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 ReleaseDate control in the Detail
section to calculate the value of the ReleaseDate field - the DateOfHire field for each individual
record. correct answers 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 answers 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 answers 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 answers 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 answers 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 answers
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 answers 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
answers
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 answers 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 answers Click the FILE tab to open Backstage. Click the OPEN button.
Double-click THIS PC to open the Open Dialog box. In the Open Dialog, click University
Registration once to select it. Click the arrow on the Open button, and select Open Exclusive.
CLick the FILE tab. Click the ENCRYPT WITH PASSWPRD button. Type griffin in the
Password box. Press Tab. Type griffin in the Verify Box. Click OK.
In the Navigation Pane, select the query that will delete records in the underlying table. correct
answers Click DeleteClasses query.
The selected field, InsuranceType, is a lookup field. Modify the lookup field properties so data
entry is limited to items on the list. correct answers
Display the group footer. correct answers In the Group, Sort, and Total Plane, click the MORE
button. Click the arrow next to WITHOUT A FOOTER section, and select WITH A FOOTER
SECTION instead.
From Design view, add a subform control to the bottom of this form. correct answers 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 the empty area at the bottom of the
form.
From Design view, change the Border Style property for the WageIncreases subform control to
Transparent. correct answers On the Form Design Tools Design tab, in the Tools group, click the
PROPERTY SHEET button. Expand the SELECTION TYPE box at the top of the Property
Sheet, and select Classes Subform. On the Property Sheet Format tab, click the BORDER
STYLE box, expand the list, and select TRANSPARENT.
Change the query to a delete query. Run the query and delete the records. correct answers
Add a comment to this macro with the text: This macro displays staff insurance elections correct
answers In the Action, Catalog, double;e-cliick COMMENT. Type: This macro displays staff
insurance elections Click outside the comment.
