MSL40118: Certificate IV in Laboratory Operations Release 1 - IT Assignment help

Assignment Task:

Part 1 – Retrieving, storing and transcribing data 

You cannot work on data you don’t have so the first task involves retrieving the data, which  will be stored in a Microsoft Access™ database. You will add data from physical data sheets  to the database. This will also need to be stored (saved), so that you have a stable version to  work with. 

Use the following procedure to complete this task: 

1. Open Microsoft Access™ on your computer 

2. Your teacher will provide the file location. Navigate to the file location on your  computer or network 

3. Open the Table titled G1S1 from the Object pane. A large data set should appear as  in the screenshot below; 

4. Refer to the four field record sheets found in Attachment 1 of this document. This  contains the data you need to enter. 

5. Enter the data from the field record sheets into the database (use new row at  bottom). This will need to be done for ALL record sheets (that is, four new rows of  data). Not all of the data on the sheets is required. Only enter the required data. 

6. Check that you have entered the data correctly into the database from the field  record sheets. 

7. Save the database when complete. 

Part 2 – Data quality control 

We now have the data in a database, but the formatting of the data is completely incorrect  and needs to be ‘cleaned’ and checked. 

Use the following procedure to complete this task: 

1. Open the database if it is not already. Export the data to an Excel spreadsheet (from  the External Data tab, export group), named G1S1 to a folder on your computer. 

2. Open the spreadsheet to start work on it (if it didn’t open automatically for you). 

3. For all the data on the spreadsheet, use the Data Quality Control (QC) Checklist  (below) to ensure that the data is in the correct format.  

4. If the data is incorrect or improperly formatted (in accordance with Table 1 below),  rectify the data in the spreadsheet accordingly.  

5. Tick the checkbox in the table when you have completed each check, including Rules  1-3. 

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.