Database Analysis & Design INF10002 Task 2 - Pass and Credit Overview . This week you will continue to compile tasks for your learning portfolio. As per the first task: complete tasks, document them (usually by making screenshots) and submit online. · In this task we focus on parameters, data exchange, data analytics, and data visualisation. . Read through the tasks once first before getting started. . To create your submission, download the files TO2P.DOCX and TO2C.DOCX from Canvas. Paste the required screen captures from the tasks below into these files. . ALL listed tasks in each section MUST be completed for you to complete the Pass and/or Credit Level Tasks . When complete, use the File / Export menu option to generate the files TO2P.PDF and TO2C.PDF. · Submit both files into Canvas via Assignment • . Pass Tasks Pass 2a • Download the studentlist.csv data file from Canvas · Look at the file name in File Manager. . DO NOT double click the file (as it may cause Excel to open). . Instead Right Click the file name and edit the file using Notepad or Notepad ++ (or similar editor). Note: MS Word is not a good choice as it may add hidden formatting characters. . Add a new row of student details below the headings. Use your student name and student ID (drop the X if your student id contains an 'X'). Use your current home address postcode. This screen capture depicts an example of a student in this unit named Fred Blogs. studentlist.csv - Notepad File Edit Format View Help StudentId, Gender, GivenName, Surname, DateOfBirth, Faculty, Home PostCode 101010, M, Fred, Blogs, 25/12/1980, Faculty of Agriculture, 3122 286069, F, Madeline, Porteus, 19/12/1999, Faculty of Business & Law, 3031 · Save your CVS file. 1
• • • Import the file into MS Access • *** When importing files that have dates make sure the Date format in your Access ( or your computer) has the same format of the Data you are importing *** Check Lecture 3 slide No.34 • Take a screen shot during the Field Options process - so that your details appear in Row 1. (See Fred's details in the screen shot example) Import Text Wizard 3 -Do × You can specify information about each of the fields you are importing. Select fields in the area below. You can then modify feld information in the 'Field Options' area. Field Options Field Name: StudentId Data Type: Long Integer Indexed: Yes (Duplicates OK) Do not import field (Skip) Student Id Gender 101010 286069 161176 GivenName Fred Surname DateOfBirth 25/12/1980 19/12/1999 Blogs Porteus F Madeline Jayden M Cuthbert 6/12/1999 Faculty Faculty of Agriculture Faculty of Business & Law Faculty of Business & Law . Make sure the table name is Student9999, where 9999 are the last 4 digits of your student ID. . Finally take a screen capture of the student table datasheet with your name displayed in the list. . Paste the 3 screen captures