代写留学生作业:Computer Apps B Access Assignment Sem

发布时间:2011-05-02 09:06:46 论文编辑:第一代写网

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: