Assignment Presentation
[pic 2]BX5550001Business computingassignment 3: Major ProjectDUE: Week 7 Day 2This assignment contributes 30% of the total course grade Assignment rationaleYou are expected to show understanding on the following learning outcomes (number 3 and 4 on Course Outline):Discuss issues associated with computer use and recommend actions to minimise their impact.Use software functions effectively to produce information to meet business requirements.Assignment Presentation Question 1 consists of 3 parts:Part 1 is to create and add data to an existing file using Access. Part 2 is to create and add data to an existing file using Excel.Part 3 is to create a report in Word to explain information in Question 2.Refer to the marking guide for full details of requirement.Question 2 is to be Word processed, 1.5 spacing, font size 12. It should be presented with suitable headings and layout, correct spelling and grammar, and tidy presentation.
The page limit is 3 pages. Submission & Late hand-in of assignment:You are expected to submit your assignment by the end of class on Week 7 Day 2. You are reminded of, and referred to, the policy in the Course Outline regarding late hand-in of assignment.Plagiarism:You are reminded of, and referred to, the policy in the Course Outline.QUESTION 1: Design and Access Database, analyse data using Excel and write a report using WordQ1, PART 1 – ACCESS: CREATE AND ADD DATA TO AN ACCESS FILE 10 marksABC Bookstore:A new used bookstore has just opened in town. You were talking to the owner when he checked you out and found out that the owner needs some help in updating his database. He is currently using an Excel workbook, but his inventory has grown so large that he needs to move to an Access database for efficiency. He also keeps records of his employees. You have agreed to look at his Excel workbook and show him how to import the data into an Access database.Create Tables by Entering Data 1 MarkCreate a new database named Assignment3_FirstnameLastname.Add a table called Bindings, that specifies the binding type of the book by adding the data in Datasheet view. The information is listed in the table below. IDBindingExplanationCost1CardCardboard (some listed as paper are really cardboard)302HardHardcover403LeatherLeather (at least some portion)604NoneNo cover or no binding05PaperPaper (paperback or magazine or leaflet)156RingRing binding (3 ring or otherwise)107FlexSoft hardcover (flexible, durable non-paper cover material)5Modify the table in Design view using the information belowSet the primary key to be the ID fieldChange the field names from Field 1 etc. to the names in the top row of the table aboveSet the field size of the Binding field to 10Import Data from Excel 1 markUse the Import Data Wizard to import each of the Books worksheet from Excel into Access. You need to select the worksheets, specify the primary keys, set the indexing option, and name the newly imported table. 1 mark