Access Modules 1-3 SAM Training - ISDS 1100 Review Questions 2024.

Access Modules 1-3 SAM Training - ISDS 1100 Review Questions 2024.Create a new table using Table Datasheet view with the following fields and data types, and in the following order: ID (AutoNumber which is automatically added by Access), CommentDate (Date & Time), and Comments (Long Text). Save the table with "ClientComments" as the table name. - ANSWER 1. Click create -- Table 2. "Click to add" -- Date & Time -- type "CommentDate" -- Press ENTER 3. "Click to add" -- Long Text -- type "Comments" -- press ENTER 4. Press save button - enter "ClientComments" in text box 5. Click OK In Datasheet View of the Clients table, change the Date Acquired field to Data/Time data type. - ANSWER 1. Click the first value in the "Date Acquired" field. 2. Click the "Table Tools - Fields" tab on the ribbon. 3. Formatting -- Data Type arrow -- Select Date/Time In Datasheet View of the Managers table, rename the field name of the Manager Email Address field using "Email" as the new name. - ANSWER 1. Right-click the column heading, "Manager Email Address" 2. Click Rename Field 3. Type "Email" and press ENTER With the Clients table in Datasheet View, change the Field Size of the State field to "2" and click YES when warned about some data being lost. Save the table. - ANSWER 1. Click the first value "TX" in the state field. 2. Fields tab on ribbon -- Properties -- "Field Size" to 2 3. Click YES when prompt appears 4. Click SAVE button In Datasheet View of the Managers table, add a new field named "Notes" with the Long Text data type. - ANSWER 1. Click the "Click to Add" column heading. 2. Select Long Text. 3. Type "Notes" then press ENTER. In Datasheet View of the Clients table, enter "Address" as the Caption property for the Street field. - ANSWER 1. Click the "Street" field 2. Click the Fields tab on the ribbon. 3. Under "Properties" select name and caption 4. Select Caption text box -- type Address then click OK