INF10025 Task 1 INF10025 Data Management and Analytic Task 1 - Pass and Credit Overview . See Canvas -> Assignments for due date · To complete your learning portfolio, every few weeks we ask you to complete a set of tasks, document them (usually by asking for screen grabs), and submit them online. . In this first task we focus on the basics. This includes using filters, queries, adding data, creating tables, more advanced queries, making relationships, indexes and forms. . To create your submission download the files TO1P.DOCX and TO1C.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, save the files as TO1P.PDF and TO1C.PDF. · Submit both files into Canvas via Assignment Pay attention to ALL requirements. If a column in Design Grid is not showing the full criteria or shows ### in the Table or Data view, make sure you widen the column (same way as in Excel). Pass Tasks Pass 1a In Microsoft Access, data can be queried using the following methods: · View a table in Datasheet View mode and use Filters · Create a query, specify a table(s) and use the Query Design screen to search for data In this unit, we do not want to use the first method that uses Filters. We want you to create Queries. . What advantages does the Query method have over using filters? List at least three advantages. 1
INF10025 Task 1 Pass 1b . Download the file named moviedb.accdb from Canvas. Open the file using Microsoft Access. Important: before you begin, you must rename the ALL tables so that the table names end with the final 4 digits of your student ID. E.g. if your id is 100234567 then the name of the MOVIE table must be MOVIE4567, ACTOR becomes ACTOR4567, CASTING becomes CASTING4567, etc. · Create a single Query that displays the following: . The MOVIENO, TITLE, RATINGCODE, RELYEAR, and RUNTIME of all movies released in the year 2009. " The list must appear in Descending RUNTIME sequence . Save the query. Call it T1PB_4567 (where 4567 is the final 4 digits of your student ID.) The next activity requires you to screen capture part of the screen. Use a screen capture tools (such as the Snipping Tool in Windows Accessories) to capture only the necessary part of the screen. Please avoid using the PrintScreen key on your keyboard to capture the entire screen. This method often captures such a large image that when pasted into a document, the results are often too miniscule to be read by your tutor. • Capture the Query Design Grid including the Table area (this is the screen where you specify criteria etc). Paste the screen capture in the appropriate position in T01P.DOCX Note: The table name in the screen capture must contain the final 4 digits of your student