New Views Entry 2019 | Module eight: SAM Undertaking 1a<\/p>\n
World Human Sources Consultants
\nBUILDING CHARTS, APPLICATION PARTS AND IMPORTING AND EXPORTING DATA<\/p>\n
GETTING STARTED
\n\u2022\tOpen the file NP_AC19_8a_FirstLastName_1.accdb, accessible for obtain from the SAM web site.
\n\u2022\tSave the file as NP_AC19_8a_FirstLastName_2.accdb by altering the \u201c1\u201d to a \u201c2\u201d.
\no\tIf 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.
\n\u2022\tTo finish this SAM Undertaking, additionally, you will must obtain and save the next knowledge recordsdata from the SAM web site onto your laptop:
\no\tSupport_AC19_8a_Europe.xml
\no\tSupport_AC19_8a_NewConsultants.csv
\no\tSupport_AC19_8a_States.csv
\no\tSupport_AC19_8a_Europe.xsd
\n\u2022\tOpen 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.
\nPROJECT STEPS
\n1.\tYou’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.<\/p>\n
Open the SoftwareComponents kind in Design View and full the next:<\/p>\n
a.\tUse the Chart Wizard so as to add a chart to the left aspect of the Type Footer part.
\nb.\tBase the chart on the Income question. Use the SoftwareCode and InstallationFee fields on the chart.
\nc.\tCreate a Column Chart.
\nd.\tSum the InstallationFee area within the Information space. Use the SoftwareCode area within the Axis space of the chart.
\ne.\tDon’t hyperlink the shape and chart fields.
\nf.\tUse Set up Income for the chart title, and don’t show a legend.
\n2.\tResize 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.
\nDetermine 1: Last SoftwareComponents Type in Type View<\/p>\n
three.\tOpen the Income report in Design View, and full the next:<\/p>\n
a.\tUse the Chart Wizard so as to add a chart to the left aspect of the Report Footer part.
\nb.\tBase the chart on the Income question. Use the SoftwareCode and MonthlyFee fields on the chart.
\nc.\tCreate a 3D Column Chart.
\nd.\tUse the SoftwareCode area within the Axis space, and sum the MonthlyFee area within the Information space.
\ne.\tDon’t hyperlink the report and chart fields.
\nf.\tUse Whole Month-to-month Charges for the chart title, and don’t show a legend.<\/p>\n
Save the Income report.
\nfour.\tResize the chart to be about 7″ huge and three” tall, then save the Income report.
\n5.\tWhereas 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.
\nDetermine 2: Final Web page of Last Income Report in Print Preview<\/p>\n
6.\tUse Software Elements to create a Contacts desk. The Contacts desk shouldn’t have a relationship to some other desk within the database.
\n7.\tUse Software Elements to create an Points desk with the next directions:<\/p>\n
a.\tOne document within the Consumer desk could also be linked to many information within the Points desk.
\nb.\tUse 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.
\neight.\tImport the Support_AC19_8a_States.csv file as a brand new desk utilizing the next directions:
\na.\tSpecify a delimited format and choose tab because the delimiter (if mandatory).
\nb.\tExamine the field that signifies that the primary row accommodates area names.
\nc.\tDon’t modify the fields; settle for the default area choices.
\nd.\tSelect StateAbbrev as the first key area.
\ne.\tUse StateProv as the brand new desk identify.
\nf.\tDon’t save the import steps.
\ng.\tOpen the StateProv desk in Datasheet View. It ought to have 64 information. Shut the StateProv desk.
\n9.\tImport 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:<\/p>\n
a.\tSpecify a comma delimited format.
\nb.\tExamine the field that signifies that the primary row accommodates area names.
\nc.\tDon’t save the import steps.
\nd.\tOpen the Guide desk in Datasheet View. It ought to now have 44 information. Shut the Guide desk.
\n10.\tImport 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.)<\/p>\n
a.\tImport each the construction and the information.
\nb.\tDon’t save the import steps.
\nc.\tOpen the Europe desk in Datasheet View. It ought to have 47 information. Shut the Europe desk.
\n11.\tUtilizing the Exterior Information group on the ribbon, export the Consumer desk as an HTML doc to the default folder utilizing the next directions:<\/p>\n
a.\tDon’t embody formatting and format.
\nb.\tSave the export steps with the identify Export-Consumer to HTML and don’t embody a Description.
\n12.\tUtilizing the Exterior Information group on the ribbon, export the ConsultantList report as an HTML doc to the default folder utilizing the next directions:<\/p>\n
a.\tDon’t open the file after the export is full.
\nb.\tDon’t use an HTML template, however do use default encoding.
\nc.\tSave the export steps with the identify Export-ConsultantList to HTML and don’t embody a Description.
\n13.\tUtilizing the Exterior Information group on the ribbon, export the Nation desk as an XML file to the default folder utilizing the next directions:<\/p>\n
a.\tEmbrace the XML (knowledge) and XSD (schema) recordsdata.
\nb.\tSave the export steps with the identify Export-Nation to XML and don’t embody a Description.
\nSave 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
New Views Entry 2019 | Module eight: SAM Undertaking 1a World Human Sources Consultants BUILDING CHARTS, APPLICATION PARTS AND IMPORTING AND EXPORTING DATA GETTING STARTED\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[666,667,665,663,664],"tags":[668,672,670,676,675,669,673,674,671],"class_list":["post-23151","post","type-post","status-publish","format-standard","hentry","category-nurse-study","category-nursing-essay","category-nursing-study","category-online-nursing-study","category-online-nursing-writers","tag-free-printable-nursing-study-guides","tag-nursing-study-guides-free","tag-nursing-study-guides-worksheets","tag-nursing-study-hub","tag-nursing-study-material","tag-nursing-study-websites","tag-study-nursing-in-australia","tag-study-nursing-in-usa","tag-study-nursing-online-uk"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/23151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=23151"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/23151\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=23151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=23151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=23151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}