| 1 | 1 | Import the file Support_NP_AC16_8a_Vendor.csv, available for download from the SAM website, as a new table in the database as described below:
a. Choose the comma as the delimiter.
b. Use the names in the first row as field names.
c. Make sure all nine fields use the Short Text data type, including the VendorID and Zip fields. (Hint: You will need to scroll the display to see all nine fields.)
d. Choose the VendorID field as the table's primary key.
e. Use tblVendor as the table name. Do not save the import steps. | true | 7 | 7 | The tblVendor table should be imported from the Support_NP_AC16_8a_Vendor.csv support file and should contain the following fields: VendorID, CompanyName, Address, City, State, Zip, Phone, ContactFirst, and ContactLast. | Import a table into a database. | 1 |
| 2 | 1 | Import the file Support_NP_AC16_8a_Vendor.csv, available for download from the SAM website, as a new table in the database as described below:
a. Choose the comma as the delimiter.
b. Use the names in the first row as field names.
c. Make sure all nine fields use the Short Text data type, including the VendorID and Zip fields. (Hint: You will need to scroll the display to see all nine fields.)
d. Choose the VendorID field as the table's primary key.
e. Use tblVendor as the table name. Do not save the import steps. | true | 7 | 7 | The tblVendor table should have 6 records imported from the Support_NP_AC16_8a_Vendor.csv file. | Import records into a table. | 2 |
| 3 | 1 | Import the file Support_NP_AC16_8a_Vendor.csv, available for download from the SAM website, as a new table in the database as described below:
a. Choose the comma as the delimiter.
b. Use the names in the first row as field names.
c. Make sure all nine fields use the Short Text data type, including the VendorID and Zip fields. (Hint: You will need to scroll the display to see all nine fields.)
d. Choose the VendorID field as the table's primary key.
e. Use tblVendor as the table name. Do not save the import steps. | true | 7 | 7 | The VendorID, CompanyName, Address, City, State, Zip, Phone, ContactFirst, and ContactLast fields in the tblVendor table should all have the Short Text data type. | Set the data type for table fields. | 3 |
| 4 | 1 | Import the file Support_NP_AC16_8a_Vendor.csv, available for download from the SAM website, as a new table in the database as described below:
a. Choose the comma as the delimiter.
b. Use the names in the first row as field names.
c. Make sure all nine fields use the Short Text data type, including the VendorID and Zip fields. (Hint: You will need to scroll the display to see all nine fields.)
d. Choose the VendorID field as the table's primary key.
e. Use tblVendor as the table name. Do not save the import steps. | true | 7 | 7 | In the tblVendor table, the VendorID field should be the primary key. | Define the primary key for a table. | 4 |
| 5 | 2 | Import the structure and data from the XML file Support_NP_AC16_8a_Payments.xml, available for download from the SAM website, as a new table named tblPayment in the database. (Hint: The tblPayment table is the only table in the XML file.) Do not save the import steps. | true | 7 | 7 | In the tblPayment table, the PaymentID, BillingID, and AmountPaid fields should all have the Short Text data type. | Import a table into database. | 1 |
| 6 | 2 | Import the structure and data from the XML file Support_NP_AC16_8a_Payments.xml, available for download from the SAM website, as a new table named tblPayment in the database. (Hint: The tblPayment table is the only table in the XML file.) Do not save the import steps. | true | 7 | 7 | The tblPayment table should have 20 records imported from the Support_NP_AC16_8a_Payments.xml file. | Import records into a table. | 2 |
| 7 | 3 | Export the tblLocation table as an HTML document, following the steps below:
a. Use the file name tblLocation.html for the exported file.
b. Export the data with formatting and layout.
c. Do not change the default HTML Output Options.
d. Save the export steps with the name Export-Location and with the description HTML file with Location information. (Hint: Be sure to include the period at the end of the description.) | false | 0 | 7 | The tblLocation table should be exported to the tblLocation.html file, and the export steps should be saved as ''Export-Location'' with the description ''HTML file with Location information.'' | Export a database object in a HTML format. | 1 |
| 8 | 4 | Export the tblBilling table as an XML file, following the steps below:
a. Use the file name tblBilling.xml for the exported file.
b. Embed the schema (XSD) in the exported XML data document, and confirm the Export Presentation (XSL) option is not selected. (Hint: Remember that you need to click More Options to embed the schema.)
c. Save the export steps with the name Export-tblBilling and the description XML file with Billing information. (Hint: Be sure to include the period at the end of the description.) | false | 0 | 7 | The tblBilling table should be exported to the tblBilling.xml file, and the export steps should be saved as "Export-tblBilling" with the description "XML file with Billing information." | Export a database object in a XML format. | 1 |
| 9 | 5 | Link to the data in the workbook Support_NP_AC16_8a_Promotions.xlsx, available for download from the SAM website, using tblPromotions as the table name. (Hint: The first row in this workbook contains the column heading.) | false | 0 | 8 | The tblPromotions table should contain 4 fields with the title of each field defined by the first row in the Support_NP_AC16_8a_Promotions.xlsx workbook. | Create a table linked to an Excel file. | 1 |
| 10 | 6 | Open the frmTrainersBilling form in Design View, and then add a tab control to the form by completing the following steps:
a. Cut the existing subform control (located below the Accepts Minors label in the Detail section).
b. Add a tab control below the Accepts Minors label in the Detail section, and place it so the left edge of the tab control is aligned with the left edge of the Certification label, the right edge is at the 6.5" mark on the horizontal ruler, and the bottom edge is located at approximately the 5.5" mark on the vertical ruler.
c. Paste the subform cut from the frmTrainersBilling form on the first (left) page of the tab control. | true | 5 | 8 | The frmTrainersBilling form should contain a tab control. | Add a tab control to a form. | 1 |
| 11 | 6 | Open the frmTrainersBilling form in Design View, and then add a tab control to the form by completing the following steps:
a. Cut the existing subform control (located below the Accepts Minors label in the Detail section).
b. Add a tab control below the Accepts Minors label in the Detail section, and place it so the left edge of the tab control is aligned with the left edge of the Certification label, the right edge is at the 6.5" mark on the horizontal ruler, and the bottom edge is located at approximately the 5.5" mark on the vertical ruler.
c. Paste the subform cut from the frmTrainersBilling form on the first (left) page of the tab control. | false | 5 | 8 | The tab control in the frmTrainersBilling form should have the left edge of the tab control is aligned with the left edge of the Certification label, the right edge is at the 6.5" mark on the horizontal ruler, and the bottom edge located at approximately the 5.5" mark on the vertical ruler. | Resize and reposition a tab control. | 2 |
| 12 | 6 | Open the frmTrainersBilling form in Design View, and then add a tab control to the form by completing the following steps:
a. Cut the existing subform control (located below the Accepts Minors label in the Detail section).
b. Add a tab control below the Accepts Minors label in the Detail section, and place it so the left edge of the tab control is aligned with the left edge of the Certification label, the right edge is at the 6.5" mark on the horizontal ruler, and the bottom edge is located at approximately the 5.5" mark on the vertical ruler.
c. Paste the subform cut from the frmTrainersBilling form on the first (left) page of the tab control. | true | 5 | 8 | The frmTrainersBilling form should contain the frmBillingSubform subform. | Create a subform. | 3 |
| 13 | 7 | In the frmTrainersBilling form, in Design View, change the caption for the main form's navigation buttons to Trainer. | false | 0 | 8 | The frmTrainersBilling form should display "Trainer" as the navigation caption. | Modify the navigation caption property of a form. | 1 |
| 14 | 8 | With the frmTrainersBilling form still open in Design View, modify the tab control as described below:
a. Set Billing Data as the caption for the left tab.
b. Set Billing Chart as the caption for the right tab. (Hint: This tab page should be blank.)
Save, but do not close, the form. | false | 0 | 8 | In the frmTrainersBilling form, the page 1 tab control should be named "Billing Data" and the page 2 tab control should be named "Billing Chart". | Set the caption of a tab control. | 1 |
| 15 | 9 | Add a chart to the Billing Chart page of the tab control and include the following options:
a. Insert the chart near the upper-left corner of the black portion of the Billing Chart page.
b. Use the tblBilling table as the record source.
c. Select BillingID and Amount as the fields for the chart.
d. Use 3-D Column Chart (located in the 2nd column, 1st row) as the chart type.
e. Do not change the default chart layout or the default fields to link records to the chart options.
f. Use Amount by BillingID as the chart title.
g. Do not display a legend in the chart.
Refer to Figure 1 and Figure 2 in the Instructions file. Save and close the frmTrainersBilling form. (Hint: Your graph may look incorrect until you save the form and view the chart in Form View.) | false | 0 | 8 | The frmTrainersBilling form should contain a 3-D column chart. | Create a chart in a form. | 1 |
| 16 | 9 | Add a chart to the Billing Chart page of the tab control and include the following options:
a. Insert the chart near the upper-left corner of the black portion of the Billing Chart page.
b. Use the tblBilling table as the record source.
c. Select BillingID and Amount as the fields for the chart.
d. Use 3-D Column Chart (located in the 2nd column, 1st row) as the chart type.
e. Do not change the default chart layout or the default fields to link records to the chart options.
f. Use Amount by BillingID as the chart title.
g. Do not display a legend in the chart.
Refer to Figure 1 and Figure 2 in the Instructions file. Save and close the frmTrainersBilling form. (Hint: Your graph may look incorrect until you save the form and view the chart in Form View.) | false | 0 | 8 | The frmTrainersBilling form should contain a 3-D Column Chart. | Add a title to a chart in a form. | 2 |
| 17 | 9 | Add a chart to the Billing Chart page of the tab control and include the following options:
a. Insert the chart near the upper-left corner of the black portion of the Billing Chart page.
b. Use the tblBilling table as the record source.
c. Select BillingID and Amount as the fields for the chart.
d. Use 3-D Column Chart (located in the 2nd column, 1st row) as the chart type.
e. Do not change the default chart layout or the default fields to link records to the chart options.
f. Use Amount by BillingID as the chart title.
g. Do not display a legend in the chart.
Refer to Figure 1 and Figure 2 in the Instructions file. Save and close the frmTrainersBilling form. (Hint: Your graph may look incorrect until you save the form and view the chart in Form View.) | false | 0 | 8 | The frmTrainersBilling form should contain a 3-D Column Chart. | Remove a legend from a chart. | 3 |
| 18 | 9 | Add a chart to the Billing Chart page of the tab control and include the following options:
a. Insert the chart near the upper-left corner of the black portion of the Billing Chart page.
b. Use the tblBilling table as the record source.
c. Select BillingID and Amount as the fields for the chart.
d. Use 3-D Column Chart (located in the 2nd column, 1st row) as the chart type.
e. Do not change the default chart layout or the default fields to link records to the chart options.
f. Use Amount by BillingID as the chart title.
g. Do not display a legend in the chart.
Refer to Figure 1 and Figure 2 in the Instructions file. Save and close the frmTrainersBilling form. (Hint: Your graph may look incorrect until you save the form and view the chart in Form View.) | false | 0 | 8 | The frmTrainersBilling form should contain a 3-D Column Chart. | Set the link properties of a chart. | 4 |
| 19 | 9 | Add a chart to the Billing Chart page of the tab control and include the following options:
a. Insert the chart near the upper-left corner of the black portion of the Billing Chart page.
b. Use the tblBilling table as the record source.
c. Select BillingID and Amount as the fields for the chart.
d. Use 3-D Column Chart (located in the 2nd column, 1st row) as the chart type.
e. Do not change the default chart layout or the default fields to link records to the chart options.
f. Use Amount by BillingID as the chart title.
g. Do not display a legend in the chart.
Refer to Figure 1 and Figure 2 in the Instructions file. Save and close the frmTrainersBilling form. (Hint: Your graph may look incorrect until you save the form and view the chart in Form View.) | false | 0 | 8 | In the frmTrainersBilling form, a 3-D Column Chart should exist in the Billing Chart tab. | Add a chart to a tab control. | 5 |
| 20 | 10 | Open the frmLocationSessions form in Design View. Modify the Sessions by Trainer chart on the Session Chart page of the tab control by removing the legend from the chart. | false | 0 | 8 | In the frmLocationSessions form, the legend in the chart should not be visible. | Remove a legend from a chart. | 1 |
| 21 | 11 | Further modify the Sessions by Trainer chart on the Sessions Chart page of the tab control by changing the chart type to a Column chart. | false | 0 | 8 | On the frmLocationSessions form, the Sessions by Trainer chart should be a Clustered Column chart. | Change the chart type in a form. | 1 |
| 22 | 12 | Change the blue data markers on the chart to Lime (3rd column, 3rd row of the Color palette). Save the form, switch to Form View, and then view the Sessions Chart page. Confirm the chart matches Figure 3 in the Instructions file, and then close the frmLocationSessions form. | false | 0 | 8 | In The Sessions by Trainer chart on the frmLocationSessions form, the first data series should have a fill color of Lime. | Change the color of a data series in a chart. | 1 |
| 23 | 13 | Create an application part and use it to create a new table in the NP_AC16_8a_FirstLastName_2.accdb file by following the steps below:
a. Open the file Support_NP_AC16_8a_Referral.accdb, available for download from the SAM website, and save it as a template.
b. In the Create New Template from This Database dialog box, create an application part with the name Referral and New Referral as the description. (Hint: Make sure that the Application Part checkbox is checked.) Do not modify any other options in the dialog box.
c. Close the Support_NP_AC16_8a_Referral.accdb database.
d. Activate the NP_AC16_8a_FirstLastName_2.accdb database, and then use the Referral application part to create a new table. The table created by the application part should have no relationship to any of the other tables.
Open the tblReferral table to verify that the table has been imported, and then close the tblReferral table. | false | 0 | 8 | The database should contain a table named ''tblReferral''. | Create a table using an application part. | 1 |
rohittamang5126
NP_AC16_8a_RohitLama_Report_1.accdb
