Business Computing 1
ISYS2059
CHEW YONG QIANG KELVIN
S3303531
Presents:
Classic Offices
Workshop Lecturer: Dr Lawrence Sim
Software Used: Microsoft Access 2007.
(License No: 12.0.6535.5005)
Database_report.doc Database Report
Microsoft Word 2007.
(License No: 12.0.6541.5000 )
Attached Files: Database_kelvin.accdb
Database_report.doc
Database Print-outs Folder
Attempted the High Distinction Level.
2 S3303531
Database_report.doc Database Report
1 Table of Contents
1 Table of Contents ....................................................................................................................................................................................................................... 3
2 Relationships ................................................................................................................................................................................................................................ 3
3 Customer Table - Datasheet view ................................................................................................................................................................................................ 5
3.1 Customer Table - Field Type .............................................................................................................................................................................................. 6
3.2 Customer Table - Field Size ................................................................................................................................................................................................ 7
3.3 Customer Table - Input Mask & Caption ............................................................................................................................................................................ 8
3.4 Customer Table - Required & Validation Rule ................................................................................................................................................................... 9
4 Chair Table - Database View ..................................................................................................................................................................................................... 10
2 Relationships
3 S3303531
Database_report.doc Database Report
4 S3303531
Database_report.doc Database Report
3 Customer Table - Datasheet view
5 S3303531
Database_report.doc Database Report
3.1 Customer Table - Design View (Field Type)
Field Type (Customer ID - Text, it is not a value hence text is chosen instead of number)
6 S3303531
Database_report.doc Database Report
3.2 Customer Table - Design View (Field Size)
Field Size (Set to 30 as Family name is unlikely to exceed this number, this speeds up database access speed)
7 S3303531
Database_report.doc Database Report
3.3 Customer Table - Design View (Input Mask & Caption)
Input Mask (Input values have been masked with the mobile number format (99)000-0000)
Caption (Changed from Cust Mobile to Customer Contact for common interpretation)
8 S3303531
Database_report.doc Database Report
3.4 Customer Table - Design View (Required & Validation Rule)
Required (CUSTOMER ID is a required file and must be filled or prompt user to do so)
Validation Rule (Check input value for correct format before saving input to database)
9 S3303531
Database_report.doc Database Report
4 Chair Table - Database View
10 S3303531
Database_report.doc Database Report
4.1 Chair Table - Design View
11 S3303531
Database_report.doc Database Report
5 Query (Top Customers) - Datasheet View
12 S3303531
Database_report.doc Database Report
5.1 Query (Top Customers) - Design View
13 S3303531
Database_report.doc Database Report
5.2 Query (Top Customers) - SQL View
14 S3303531
Database_report.doc Database Report
5.3 Query (Best Selling Chairs) - Datasheet View
15 S3303531
Database_report.doc Database Report
5.4 Query (Best Selling Chairs) - Design View
16 S3303531
Database_report.doc Database Report
5.5 Query (Best Selling Chairs) - SQL View
17 S3303531
Database_report.doc Database Report
6 Customer Information Form
-Add, Remove, Save, Print , Main Menu and Close buttons. -Combo Box, Subform -Menu Driven System
18 S3303531
Database_report.doc Database Report
6.1 Chair Information Form
19 S3303531
Database_report.doc Database Report
7 Summary of Chair Sales Report part-1
20 S3303531
Database_report.doc Database Report
7.1 Summary of Chair Sales Report part-2
21 S3303531
Database_report.doc Database Report
7.2 Summary of Chair Sales Report - SQL Dump
22 S3303531