Access Module 3 Sam Training Study Guide Questions And Correct Answers

In the relationships window, create a one-to-many relationship between the states and clients tables using the stateAbreviations field in the states table and the state field in the clients table. Encore referential integrity on the relationship. {Ans: -click database tools tab on ribbon -click relationships button -in relashioship tools design tab click the show table button -double click states button -press close -drag the state abbreviation field from the states table to the state field in the clients table -click the encore referential integrity box -click create}In data sheet view of the States table, set to font of the data sheet to Arial {Ans: -click text formatting button on home tab -click the font box -change font to arial}In the managers data sheet, resize the email field so that all field values are fully visible. {Ans: -double-click the filename separator line to the right of the email field}In data sheet view of the Clientorders query query, sort the records in ascending (a to z) order based on the values in the client name field {Ans: -click arrow to the right of the client name field -click sort a to z option}in the clinetsbystate query in data