Assignment Presentation

[pic 2]

BX5550001

Business computing

assignment 3: Major Project

DUE: Week 7 Day 2

This assignment contributes 30% of the total course grade

Assignment rationale

You 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 Word

Q1, PART 1 – ACCESS: CREATE AND ADD DATA TO AN ACCESS FILE

        10 marks

ABC 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 Mark

1. Create a new database named Assignment3_FirstnameLastname.
2. 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.

1. Modify the table in Design view using the information below

• Set the primary key to be the ID field
• Change the field names from Field 1 etc. to the names in the top row of the table above
• Set the field size of the Binding field to 10

Import Data from Excel         1 mark

Use 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