ISDS 1100 FINAL EXAM ACTUAL QUESTIONS AND
ANSWERS GUARANTEE A+
✔✔In the Table Datasheet view, delete the Client ID 113 SC Logistics record from the
Clients table. - ✔✔1. Click the Record sleeved for Client ID 113 SC Logistics (first little
block on the row)
2. Press DELETE (Just press cut and that also works)
3. When prompted click YES
✔✔Move to the first record in the ClientEntry form. - ✔✔1. In the lower-left corner of the
form, click the First record button in the navigation buttons. [<
✔✔Move to the next record in the Managers data sheet. - ✔✔1. Click the Next record
button, in the navigation buttons in the lower-left corner of the data sheet. >
✔✔With the ClientEntry form open in Form view, navigate to the previous record. -
✔✔1. In the lower-left corner of the ClientEntry form, in the navigation buttons, click the
Previous record button. <
✔✔In Table Design view, set the ClientID field as the primary key field for the Clients
table. - ✔✔1. In Table Design view, click the ClientID field.
2. In the Table Tools Design tab, click the Primary Key button.
✔✔With the Managers table in Design view, change the Hire Date field to a Date/Time
data type. - ✔✔1. In Table Design view, click the Data Type cells for the Hire Date field.
"Short Text"
2. Click the arrow for the field, click Date/Time on the list.
✔✔In Design View of the Clients table, enter "Address" as the new Field Name for the
Street field. - ✔✔1. Click the Field Name cell for the Street field.
2. Type "Address" and press ENTER.
✔✔In Design View of the Clients table, add a new field names "Notes" with a Long Text
data type. - ✔✔1. In Design view of the Clients table, click the empty Field Name cell
below the Zip field.
2. Type "Notes" and press ENTER
3. Click the data type arrow --> Click Long Text
✔✔Create a new table in Design View with the following field names and data types:
"ManagerID" Short Text; "Rating" Number. Save the table with the name
ManagerRatings and do not set a primary key field at this time. - ✔✔1. Click the Create
tab on the ribbon.
2. In the Tables group, click the Table Design button.
3. Type "ManagerID" as the first field name and press ENTER.
, 4. Click the field name cell in the second row.
5. Type "Rating" and press ENTER --> Data Type arrow and click "Number"
6. Click the SAVE button
7. Type "ManagerRatings" in the Table Name text box. --> Click OK
8. When prompted, click NO
✔✔Create a new select query using the Simple Query Wizard based on the Client ID,
Client Name, and Discount fields of the Clients table, in that order. Show Details, enter
"ClientDiscounts" as the query name, and open the new query in Datasheet View. -
✔✔1. Click the Create tab.
2. Click the Query Wizard button.
3. With "Simple Query Wizard" selected, click OK
4. Click the Tables/Queries list arrow, then click Table: Clients
5. Select ClientID --> Click the Select Single Field button. --> ClientName is selected -->
then click the (>) button
6. In the Available Fields list, click Discount --> Click the Single Field Button (>)
(you should have ClientID, ClientName, & Discount)
7. Click Next. Accept the default option.
8. Click Next again.
9. Click in the text box and enter "ClientDiscounts" for the query title
10. Accept default setting --> click Finish
✔✔Use the Form tool to create a form based on the Clients table. - ✔✔1. On the
Navigation pane, click the Clients table.
2. In the Create tab, click FORM
✔✔With the ClientEntry form open in Layout view, switch to Form view. - ✔✔1. On the
Form Layout Tools Design tab on the ribbon, in the Views group, click the View button.
✔✔Create a new report using the Report Wizard based on all of the fields in the
ClientOrdersQuery query. Do not apply any additional grouping, sorting, or summary
information. Use a Columnar layout and Portrait orientation, enter MinimumOrders as
the title, and preview the new report in Print Preview. - ✔✔1. Click Create
2. Click the "Report Wizard" button.
3. Click the drop arrow; click ClientOrdersQuery
4. Click the Select All button (>>)
5. Click Next three times.
6. Change to Columnar layout
7. Click Next
8. Edit the title to read MinimumOrders
9. Click FINISH
✔✔With the ClientOrders report in Report view, switch to Report Design view. - ✔✔1. In
the Views group on the ribbon, click the View arrow.
2. Click Design View
ANSWERS GUARANTEE A+
✔✔In the Table Datasheet view, delete the Client ID 113 SC Logistics record from the
Clients table. - ✔✔1. Click the Record sleeved for Client ID 113 SC Logistics (first little
block on the row)
2. Press DELETE (Just press cut and that also works)
3. When prompted click YES
✔✔Move to the first record in the ClientEntry form. - ✔✔1. In the lower-left corner of the
form, click the First record button in the navigation buttons. [<
✔✔Move to the next record in the Managers data sheet. - ✔✔1. Click the Next record
button, in the navigation buttons in the lower-left corner of the data sheet. >
✔✔With the ClientEntry form open in Form view, navigate to the previous record. -
✔✔1. In the lower-left corner of the ClientEntry form, in the navigation buttons, click the
Previous record button. <
✔✔In Table Design view, set the ClientID field as the primary key field for the Clients
table. - ✔✔1. In Table Design view, click the ClientID field.
2. In the Table Tools Design tab, click the Primary Key button.
✔✔With the Managers table in Design view, change the Hire Date field to a Date/Time
data type. - ✔✔1. In Table Design view, click the Data Type cells for the Hire Date field.
"Short Text"
2. Click the arrow for the field, click Date/Time on the list.
✔✔In Design View of the Clients table, enter "Address" as the new Field Name for the
Street field. - ✔✔1. Click the Field Name cell for the Street field.
2. Type "Address" and press ENTER.
✔✔In Design View of the Clients table, add a new field names "Notes" with a Long Text
data type. - ✔✔1. In Design view of the Clients table, click the empty Field Name cell
below the Zip field.
2. Type "Notes" and press ENTER
3. Click the data type arrow --> Click Long Text
✔✔Create a new table in Design View with the following field names and data types:
"ManagerID" Short Text; "Rating" Number. Save the table with the name
ManagerRatings and do not set a primary key field at this time. - ✔✔1. Click the Create
tab on the ribbon.
2. In the Tables group, click the Table Design button.
3. Type "ManagerID" as the first field name and press ENTER.
, 4. Click the field name cell in the second row.
5. Type "Rating" and press ENTER --> Data Type arrow and click "Number"
6. Click the SAVE button
7. Type "ManagerRatings" in the Table Name text box. --> Click OK
8. When prompted, click NO
✔✔Create a new select query using the Simple Query Wizard based on the Client ID,
Client Name, and Discount fields of the Clients table, in that order. Show Details, enter
"ClientDiscounts" as the query name, and open the new query in Datasheet View. -
✔✔1. Click the Create tab.
2. Click the Query Wizard button.
3. With "Simple Query Wizard" selected, click OK
4. Click the Tables/Queries list arrow, then click Table: Clients
5. Select ClientID --> Click the Select Single Field button. --> ClientName is selected -->
then click the (>) button
6. In the Available Fields list, click Discount --> Click the Single Field Button (>)
(you should have ClientID, ClientName, & Discount)
7. Click Next. Accept the default option.
8. Click Next again.
9. Click in the text box and enter "ClientDiscounts" for the query title
10. Accept default setting --> click Finish
✔✔Use the Form tool to create a form based on the Clients table. - ✔✔1. On the
Navigation pane, click the Clients table.
2. In the Create tab, click FORM
✔✔With the ClientEntry form open in Layout view, switch to Form view. - ✔✔1. On the
Form Layout Tools Design tab on the ribbon, in the Views group, click the View button.
✔✔Create a new report using the Report Wizard based on all of the fields in the
ClientOrdersQuery query. Do not apply any additional grouping, sorting, or summary
information. Use a Columnar layout and Portrait orientation, enter MinimumOrders as
the title, and preview the new report in Print Preview. - ✔✔1. Click Create
2. Click the "Report Wizard" button.
3. Click the drop arrow; click ClientOrdersQuery
4. Click the Select All button (>>)
5. Click Next three times.
6. Change to Columnar layout
7. Click Next
8. Edit the title to read MinimumOrders
9. Click FINISH
✔✔With the ClientOrders report in Report view, switch to Report Design view. - ✔✔1. In
the Views group on the ribbon, click the View arrow.
2. Click Design View
