Access Exam UPDATED ACTUAL Exam Questions and CORRECT Answers

Access Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
In Form Layout view of the Workshops form, resize the WorkshopName text box upto the right
edge of the StreetAddress column,so that the entire entry Refresh those kitchen cabinets, in the
first record is fully visible. - CORRECT ANSWER -


Add criteria to the WorkshopAttendanceByType query to select only those records where the
WorkshopDate field value is equal to 4/8/2017. Then, run the query to display it in Datasheet
view - CORRECT ANSWER -



Start Access. - CORRECT ANSWER -


In Query Design view of the WorkshopCapacity query, add the Total row to the query grid. -
CORRECT ANSWER -


In Datasheet view of the Participants table, use the More Fields option to add a new field
immediately after the FirstName field. Name the new field CallDate and use a Medium Date data
type. - CORRECT ANSWER -


In Design view of the Workshops table, change the Format property of the WorkshopDate field
to Short Date. - CORRECT ANSWER -


In Form Layout view of the Workshops form, add the Precision.png image to the Detail section
of the form. - CORRECT ANSWER -


Add criteria to the WorkshopsByType query to select only those records where the
CostPerPerson field value is greater than 20. Then, run the query to display it in Datasheet view.
- CORRECT ANSWER -

, In Form view of the Workshops form, edit the WorkshopName value of the first record
(WorkshopID 01-KT) to Paint those kitchen cabinets and edit the MaxCapacity to 50 -
CORRECT ANSWER -


In Form Layout view of the PartcipantEntry form, apply the Facet theme (1st row, 2nd column of
Themes gallery) - CORRECT ANSWER -



Rename the Workshop report to be WorkshopAttendance - CORRECT ANSWER -


In Report Layout view of the WorkshopsByType report, apply the Facet theme (1st row, 2nd
column of Themes gallery) - CORRECT ANSWER -


In Report Design view of the WorkshopAttendance report, move the Workshop Attendance label
in the Report Header section so the right side of the text box is positioned at the 5-inch mark on
the horizontal ruler. - CORRECT ANSWER -


Use the Form tool to create a form based on the Participants table. - CORRECT
ANSWER -


In Datasheet View of the Workshops table, change the Format property of the WorkshopDate
field to Medium Date. - CORRECT ANSWER -


In Query Design view of the WorkshopTypeSummary query, group the records by
WorkshopType, count the LastName field values, and run the query. - CORRECT
ANSWER -


In Datasheet view of the Participants table, hide the Nickname field. - CORRECT
ANSWER -


In Design View of the Workshops table, add a field named Veteran with a Yes/No data type. -
CORRECT ANSWER -