ISDS 1100 EXAM 1 MODULES 1 TO 3 2026
VERIFIED QUESTIONS AND ANSWERS
COMPLETE A+
◉ 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
◉ With the Managers table open in Datasheet view, change the Format
property of the DateOfHire field to Medium Date Answer: 1. Click the
first value in the DateOfHire field.
2. Click the "Fields" tab on the ribbon --> select Formatting
3. Click "Medium Date" on the list. (it changes the whole field
automatically)
◉ View the Managers table in Design view. Answer: 1. In the
Navigation pane, right-click the Managers table.
2. Click "Design View"
, ◉ In Table Design view of the Clients table, change the Field Size to "2"
for the State field. Then, save the table, and click YES when prompted.
Answer: 1. Click the State field.
2. In the "Field Properties" pane (below), click the Field Size property
box
3. Type "2" to replace the value, then press ENTER
4. Click the SAVE button
5. Click YES when prompted
◉ With the Managers table in Datasheet view, enter a new record with
"M-13" as the Manager ID, "Shin" as the First Name, "Li" as the Last
Name, and "" as the email address. Answer: 1. In
Datasheet view, in the "Records" group on the Home tab, click the
"New" button.
2. Type "M-13" and Press TAB
3. Type "Shin" and press TAB
4. Type "Li" and press TAB
5. Then type in the email and press TAB
◉ Open the ClientEntry form in Form view. Answer: 1. Double click
then ClientEntry form.
◉ In the Table Datasheet view, delete the Client ID 113 SC Logistics
record from the Clients table. Answer: 1. Click the Record sleeved for
Client ID 113 SC Logistics (first little block on the row)
VERIFIED QUESTIONS AND ANSWERS
COMPLETE A+
◉ 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
◉ With the Managers table open in Datasheet view, change the Format
property of the DateOfHire field to Medium Date Answer: 1. Click the
first value in the DateOfHire field.
2. Click the "Fields" tab on the ribbon --> select Formatting
3. Click "Medium Date" on the list. (it changes the whole field
automatically)
◉ View the Managers table in Design view. Answer: 1. In the
Navigation pane, right-click the Managers table.
2. Click "Design View"
, ◉ In Table Design view of the Clients table, change the Field Size to "2"
for the State field. Then, save the table, and click YES when prompted.
Answer: 1. Click the State field.
2. In the "Field Properties" pane (below), click the Field Size property
box
3. Type "2" to replace the value, then press ENTER
4. Click the SAVE button
5. Click YES when prompted
◉ With the Managers table in Datasheet view, enter a new record with
"M-13" as the Manager ID, "Shin" as the First Name, "Li" as the Last
Name, and "" as the email address. Answer: 1. In
Datasheet view, in the "Records" group on the Home tab, click the
"New" button.
2. Type "M-13" and Press TAB
3. Type "Shin" and press TAB
4. Type "Li" and press TAB
5. Then type in the email and press TAB
◉ Open the ClientEntry form in Form view. Answer: 1. Double click
then ClientEntry form.
◉ In the Table Datasheet view, delete the Client ID 113 SC Logistics
record from the Clients table. Answer: 1. Click the Record sleeved for
Client ID 113 SC Logistics (first little block on the row)
