Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
Data Management Tools Assessment
Assessment Instructions
1. In order to undertake the assessment you will need to copy a computer file onto your OneDrive or M: drive. The Preliminaries section of the assessment sheet indicates what this file is called and where to find it; although you may already have a copy of it if you undertook the formative learning material. If you do not already have a copy of the file, follow the instructions below to copy it to your OneDrive or M: drive.
• Go to the Digital Literacy for Business - Data Learn space.
• Open the Formative Learning Example File folder under the Data Management Tools learning topic of the Learn space.
• Select the file and save (not open) it to your OneDrive or M: drive.
2. The file contains a database that you need to make modifications and additions to. These tasks are outlined in Parts 1, 2 & 3. Follow the specific instructions on the assessment sheet for each individual task. Parts 2 & 3 also require the creation of a PDF file of the results.
3. At the end of the assessment you will have three computer files: The Northwind database file and two PDF ones (one each for Parts 2 & 3). You must submit all three files to the specified submission links in the Data Management Tools Assessed Assignment folder under Assessment on the course Learn space.
Preliminaries
Part 3 - Creating a report using the Report Wizard
1. Use the Report Wizard to create a stepped report using the Customers table that gives you a list of contact name, contact title and phone number for each Company, grouped together by Country.
2. Within the country groupings, sort alphabetically on Company Name.
3. Give your report the title Customer Contact List followed by a hyphen (-) then your examination number.
4. Save the report as a PDF file, showing only the first page. The file name should be Customer Contact List followed by a hyphen (-) then your examination number
Final Steps
Rename your database file for submission.
1. Click on the File tab, then select Save As.
2. Ensure that Save Database As is selected, then click on the Save As button to select a disk drive and folder into which to save the file.
3. Now click at the end of the writing in the File name: box and add a hyphen (-) then your examination number to the end of the file name and click on Save.
Before submitting to Learn, you need to ensure that the Northwind database file is closed and that you have also exited and closed Access itself, otherwise you will get an error when you attempt to submit the file.
• Submit your Northwind - database file to the Data Management Tools Assessment Submission link in the Data Management Tools Assessed Assignment folder in the Assessment folder on the course Learn space.
• Submit the PDF file of the Date Employee Was Hired form. to the Form Task Submission link in the Data Management Tools Assessed Assignment folder in the Assessment folder on the course Learn space.
• Submit the PDF file of the Customer Contact List report to the Report Task Submission link in the Data Management Tools Assessed Assignment folder in the Assessment folder on the course Learn space.