Assignment 2 HIT1401/5401 Intro to Information Systems The assignment is to be done individually Due Date/Time: 9:30am Monday 27 May, 2013 Marks: 10% of your total marks for this subject. Submission Requirements · One .zip file that contains: " One MS Word document named Ass2_1234567_Summary.docx (details described below) " One Access database file named Ass2_1234567_Production.accdb " Contains ALL of the queries and reports required for this assignment. " One or more Excel files (details described below) " You must submit your assignment via ESP https://esp.ict.swin.edu.au/ by the due date. " You must save a copy of your submitted zip file on Drive H: for backup purposes. Mark Allocation . Parts 1 & 2 11% • Part 3 10% . Part 4 20% . Part 5 10% • Part 6 10% • Part 7 21% . Part 8 18% Getting Started 1. Download the file name Ass2_Master.accdb from Blackboard. 2. Open this file. 3. If a button below the ribbon says Enable Content, click it. (a bunch of various reasons may cause this button to appear / not appear) 4. From the Ribbon menu, choose a. File / Options b. Trust Centre C. Trust Centre Settings (button on right of window) d. Macro Settings e. Choose Enable All Macros Select OK, OK 5. Enter your student ID in the textbox 6. Click on the Make My Database button 7. A file named Ass2_1234567.accdb will be created in the My Documents folder of the computer you are using (where 1234567 will be replaced with your Student ID) Microsoft Access Security Notice X A Microsoft Access Security Notice may appear up to six times during this process. Simply click on the OPEN button each time. A potential security concern has been identified. Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you trust its source. This file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation? More information Open Cancel 8. A confirmation message appears and then the database closes. 9. You may now commence working with your own personalized database.
Assignment 2 HIT1401/5401 Intro to Information Systems Part 1. Copying the database and changing Options This can be done via Windows Explorer · Copy the Ass2_1234567.accdb . Paste it as Ass2_1234567_Production.accdb. The 'Production' database is the database file that you must use to create your queries and reports for within this assignment. Save this file regularly. Open the database file named Ass2_1234567_Production.accdb. (where 1234567 is your Student ID) Setting Options In this database, if you were to display the contents of two tables, each would appear in an overlapping window. This is not what you are used to. You usually have each table appear as a Tabbed Document. To change this outcome, you need to modify an Access setting: . Choose File / Options from the Ribbon Menu · Choose Current Database