BUSM 1394 Computer Apps B Access Assignment Sem 2 2010.doc Created by Natalia Rosu
Page 1 of 2
代写留学生作业Business TAFE School
BUSM 1394 Computer Applications B
MS Access Assignment – Semester 2 2010
Student Name: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Student Number: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Due Date: Week 9 (in class)
This assignment covers:
□ Creation of a database that will include the following objects:
o Tables
o Queries
o Forms
o Reports
□ Individual presentation of your database
You work in a company that provides services to a diverse clientele.
Your boss needs access to clients’ details and their products/services. You are required to collect and organize the data.
These are the tasks that you need to complete:
Decide on the type/s of information needing to be stored in the database.
Advise your teacher by email no later than Friday, 20 August, COB
http://www.1daixie.com/liuxueshengzuoye/Determine which tables and which input data will be required.
Decide on and setup primary keys, appropriate datatypes and the appropriate field properties in each table. Populate your tables with appropriate data
Create appropriate relationships between tables, enforcing referential integrity.
Create two reports:
o report based on information extracted from table/s.
o report based on a query.
Create and save a form with subform. Use a format of your choice.
BUSM 1394 Computer Apps B Access Assignment Sem 2 2010.doc Created by Natalia Rosu
Page 2 of 2
Create and save queries that will:
o Display data using:
Wildcards
Comparison operators
Logical functions AND and OR
Ordering
Calculated fields
Parameters
The database should be named as <your username family name MS Access Assignment.mdb>. For example, <s1234567 Jane Lim MS Access Assignment.mdb>.
What you need to hand in:
1. softcopy of the database submitted to the BUSM 1394 Computer Applications B Learning Hub Digital Dropbox.
2. hardcopy of the report using grouping
http://www.1daixie.com/liuxueshengzuoye/3. completed and signed ‘Assignment Cover Sheet’ available for download from http://mams.rmit.edu.au/wcy2b1ka2ioo1.pdf AND this instruction sheet/marking guide.
Marking Guide:
Criteria
Marks/100 Actual Marks Marks Available
Database design and adherence to all criteria
15
Appropriate table structure
15
Enforce referential integrity
6
Reports
18
Forms and subforms
10
Queries
30
Compliance with submission instructions
6
代写留学生作业TOTAL (late submission penalty 10% per day)
100
Feedback:
Teacher:
Date: