Access Test ACTUAL Exam Questions and CORRECT Answers

Access Test ACTUAL Exam Questions and
CORRECT Answers
Create a single record form from the service table - CORRECT ANSWER - HINT: on the
create tab, in the forms group, click the form button


create a multiple items form from the service table - CORRECT ANSWER - HINT: on the
create tab, in the forms group, click more forms button, and select multiple forms


create a split form from the services table - CORRECT ANSWER - HINT: on the create
tab, in the forms group, click the more forms button, and select split form


start the form wizard - CORRECT ANSWER - HINT: on the create tab, in the forms
group, click the form wizard button


create a new blank form so it opens directly in layout view - CORRECT ANSWER -
HINT: on the create tab, in the forms group click the blank form button


display the field list pane - CORRECT ANSWER - HINT: on the form layout tools design
tab in the tools group click the add existing fields button


Add the ApptDate field from the appointments table to the form - CORRECT ANSWER -
HINT: in the field's list pane, click the + infant of Appointments. Double-click APPTdate


Add the Appt time field from the appointments table to the form, creating another layout column
to the right of the ApptDate control - CORRECT ANSWER - HINT: in the field list pane,
click ApptTime to select it and drag to the right of the ApptDate controls in the form


renaming fields - CORRECT ANSWER - HINT: double-click the label control that
displays the text ApptDate. press backspace to delete the existing name and type Date instead,
press enter

, create a basic report from the service table - CORRECT ANSWER - HINT: on the create
tab, in the reports group, click the report button


all label controls in the form have been selected for you. bold them - CORRECT
ANSWER - HINT: on the form layout tools format tab, in the font group click the bold
button


Select the service name column and then move it to place it between apptime and last name
columns - CORRECT ANSWER - HINT: click anywhere in the service name column. on
the report layout tools arrange tab, in the rows and columns group, click the select column
button. move the mouse pointer over the column, when the pointer changes to the move shape,
click and drag until the I-bar shape appears between the appttime and last name columns and
then release the mouse


Move the service label control and its bound control down one row in the layout to the area to
the right of the first name controls - CORRECT ANSWER - HINT: click the service label
control. Press CTRL and click the bound control displaying the service name. click and drag to
move both controls down to the empty layout area to the right of the Firstname controls


Insert above - CORRECT ANSWER - HINT: click anywhere in the row. on the form
layout tools arrange tab, in the row and columns group, click the insert above button


Apply the medium padding option to the entire report layout - CORRECT ANSWER -
HINT: On the report layout tools arrange tab, in the rows and columns group ,click select layout
button. in the position group, click the control padding button and select medium


Add the image SPALOGO25 to the form header as a logo. do not switch views. - CORRECT
ANSWER - HINT: on the form layout tools design tab in the header/footer group, click the
logo button. in the insert picture dialog, click SPALOGO20 to select the file, then click the open
button