New Views Entry 2019 | Module eight: SAM Undertaking 1a
World Human Sources Consultants
BUILDING CHARTS, APPLICATION PARTS AND IMPORTING AND EXPORTING DATA
GETTING STARTED
• Open the file NP_AC19_8a_FirstLastName_1.accdb, accessible for obtain from the SAM web site.
• Save the file as NP_AC19_8a_FirstLastName_2.accdb by altering the “1” to a “2”.
o If you don’t see the .accdb file extension within the Save As dialog field, don’t kind it. This system will add the file extension for you mechanically.
• To finish this SAM Undertaking, additionally, you will must obtain and save the next knowledge recordsdata from the SAM web site onto your laptop:
o Support_AC19_8a_Europe.xml
o Support_AC19_8a_NewConsultants.csv
o Support_AC19_8a_States.csv
o Support_AC19_8a_Europe.xsd
• Open the _GradingInfoTable and be sure that your first and final identify is displayed as the primary document within the desk. If the desk doesn’t include your identify, delete the file and obtain a brand new copy from the SAM web site.
PROJECT STEPS
1. You’re employed within the software program division of World Human Sources Consultants (GHRC), which sells modular Human Useful resource (HR) software program to massive worldwide firms. For top-level planning functions, you might have created an Entry database to trace new shoppers, the HR software program modules they’ve bought, and the lead guide for every set up. On this venture you’ll construct charts and objects utilizing Software Elements. Additionally, you will import and export knowledge utilizing HTML and XML file codecs.
Open the SoftwareComponents kind in Design View and full the next:
a. Use the Chart Wizard so as to add a chart to the left aspect of the Type Footer part.
b. Base the chart on the Income question. Use the SoftwareCode and InstallationFee fields on the chart.
c. Create a Column Chart.
d. Sum the InstallationFee area within the Information space. Use the SoftwareCode area within the Axis space of the chart.
e. Don’t hyperlink the shape and chart fields.
f. Use Set up Income for the chart title, and don’t show a legend.
2. Resize the chart to be about 6″ huge and about three” tall. Save and show the SoftwareComponents kind in Type View as proven in Determine 1, after which shut it.
Determine 1: Last SoftwareComponents Type in Type View
three. Open the Income report in Design View, and full the next:
a. Use the Chart Wizard so as to add a chart to the left aspect of the Report Footer part.
b. Base the chart on the Income question. Use the SoftwareCode and MonthlyFee fields on the chart.
c. Create a 3D Column Chart.
d. Use the SoftwareCode area within the Axis space, and sum the MonthlyFee area within the Information space.
e. Don’t hyperlink the report and chart fields.
f. Use Whole Month-to-month Charges for the chart title, and don’t show a legend.
Save the Income report.
four. Resize the chart to be about 7″ huge and three” tall, then save the Income report.
5. Whereas nonetheless in Design View of the Income report, change the chart kind of the chart within the Report Footer part from 3D Column Chart to Clustered Column Chart. Save the Income report, show it in Print Preview, and navigate to the final web page of the report as proven in Determine 2, after which shut the Income report.
Determine 2: Final Web page of Last Income Report in Print Preview
6. Use Software Elements to create a Contacts desk. The Contacts desk shouldn’t have a relationship to some other desk within the database.
7. Use Software Elements to create an Points desk with the next directions:
a. One document within the Consumer desk could also be linked to many information within the Points desk.
b. Use the ClientID area within the Consumer desk, don’t kind the sector, identify the lookup column Consumer, and don’t enable a number of values.
eight. Import the Support_AC19_8a_States.csv file as a brand new desk utilizing the next directions:
a. Specify a delimited format and choose tab because the delimiter (if mandatory).
b. Examine the field that signifies that the primary row accommodates area names.
c. Don’t modify the fields; settle for the default area choices.
d. Select StateAbbrev as the first key area.
e. Use StateProv as the brand new desk identify.
f. Don’t save the import steps.
g. Open the StateProv desk in Datasheet View. It ought to have 64 information. Shut the StateProv desk.
9. Import the Support_AC19_8a_NewConsultants.csv file situated within the default folder and append the information into the prevailing Guide desk utilizing the next directions:
a. Specify a comma delimited format.
b. Examine the field that signifies that the primary row accommodates area names.
c. Don’t save the import steps.
d. Open the Guide desk in Datasheet View. It ought to now have 44 information. Shut the Guide desk.
10. Import the Support_AC19_8a_Europe.xml file as a brand new Entry desk utilizing the next directions. (Trace: The Support_AC19_8a_Europe.xsd file must be in the identical folder because the Support_AC19_8a_Europe.xml file for the import to achieve success.)
a. Import each the construction and the information.
b. Don’t save the import steps.
c. Open the Europe desk in Datasheet View. It ought to have 47 information. Shut the Europe desk.
11. Utilizing the Exterior Information group on the ribbon, export the Consumer desk as an HTML doc to the default folder utilizing the next directions:
a. Don’t embody formatting and format.
b. Save the export steps with the identify Export-Consumer to HTML and don’t embody a Description.
12. Utilizing the Exterior Information group on the ribbon, export the ConsultantList report as an HTML doc to the default folder utilizing the next directions:
a. Don’t open the file after the export is full.
b. Don’t use an HTML template, however do use default encoding.
c. Save the export steps with the identify Export-ConsultantList to HTML and don’t embody a Description.
13. Utilizing the Exterior Information group on the ribbon, export the Nation desk as an XML file to the default folder utilizing the next directions:
a. Embrace the XML (knowledge) and XSD (schema) recordsdata.
b. Save the export steps with the identify Export-Nation to XML and don’t embody a Description.
Save and shut any open objects in your database. Compact and restore your database, shut it, after which exit Entry. Observe the instructions on the SAM web site to submit your accomplished venture.
