TASK 1:
Demonstrate Problem Solving Skills by creating a Database and import the four (4) Text files into four (4) Tables
• Database correctly created.
• Four Database Tables correctly imported.
DATABASE - CREATION:
Logical development of database as per instructions.
Issues detected about your Database Creation:
Logical development of database tables through the use of the Textfile Import tool.
Issues detected about your Database Tables Import from Textfiles:
TASK 2:
Demonstrate Problem Solving Skills by modifying the four imported tables' structures using the given table specifications in Microsoft Access using TableDesign View.
• Data fields have the appropriate data type.
• Data fields have appropriate Field Description to describe the data field.
• Data fields have appropriately set properties.
Logical development of appropriate data types for all data fields in the four database tables.
Issues detected about your Database Table Field Data Types:
TABLE DESIGN - SETTING APPROPRIATE FIELD DESCRIPTIONS &PROPERTIES:
Logical development of appropriate field descriptions and properties for all data fields in the four database tables.
Issues detected about your Database Table Field Descriptions and Properties:
TABLE DESIGN - PRIMARY KEYS:
Logical development of database tables primary keys.
Issues detected about your Database Tables Primary Key(s) Development:
TASK 4:
TABLE RELATIONSHIPS:
Demonstrate Problem Solving Skills bythe logical development of the relationships between the four (4) tables.
Issues detected about your Database Tables Relationship Development:
TASK 5:
Demonstrate Problem Solving Skills by the creation the following five (5) queries using the QueryDesign View:
• Query 1: Unfulfilled Mother's Day Brass Instrument Orders
• Query 2: Southern Australian Percussion Instrument Orders from a Supplier
• Query 3: Import Duty Saint Lucia (LC) Cost Price Increase
• Query 4: Late Dispatched Orders Form Query
• Query 5: Invoice Query with Calculated Fields
QUERY 1: UNFULFILLED MOTHER'S DAY BRASS INSTRUMENT ORDERS:
Logical development ofthe Unfulfilled Mother's Day Brass Instrument OrdersSelect Query.
Issues detected about your Unfulfilled Mother's Day Brass Instrument OrdersSelect Query:
QUERY2: SOUTHERN AUSTRALIAN PERCUSSION INSTRUMENT ORDERS FROM A SUPPLIER:
Logical development ofthe Southern Australian Percussion Instrument Orders from a SupplierSelect Query.
Issues detected about your Southern Australian Percussion Instrument Orders from a SupplierSelect Query:
Logical development of the Import Duty Saint Lucia (LC) Cost Price IncreaseUpdateQuery.
Issues detected about your Import Duty Saint Lucia (LC) Cost Price IncreaseUpdateQuery:
Logical development ofthe Late Dispatched Orders Form Query.
Issues detected about your Late Dispatched Orders Form Query:
Logical development of the Invoice Query with Calculated Fields Select Query.
Issues detected about your Invoice Query with Calculated Fields SelectQuery:
TASK 6:
Demonstrate Problem Solving Skills by creating the following forms using the FormWizard and Form Design:
• Frm1: Late Orders Display Form with Calculated Fields
• Frm2: Supplier Items Display Form with Sub-form
FORM DESIGN - FORM1: LATE ORDERS DISPLAY FORM WITH CALCULATED FIELDS:
Demonstrate Problem Solving and Communication Skills through the logical development of the Late Orders Display Form with Calculated Fields.
TASK 7:
REPORT DESIGN - INVOICE REPORT:
Demonstrate Problem Solving Skills by the logical development of the Invoice Report using ReportWizard andDesign View.
TASK 8:
END OF PROJECT PRESENTATION TO THE CLIENT - PROFESSIONAL LAYOUT & STRUCTURE:
Demonstrate professional presentation skills by the development of a professional business presentation to the client outlining the development process for this Database Management System project. The presentation contains ALL elements in the online activity structure clearly labelled and in the order outlined in the Assignment Specification, showing good use of font size, font colour and slide background theme / colour, and appropriate succinct wording on ALL slidesas outlined in Appendix 1 for development of a professional PowerPoint presentation.
Attachment:- Assignment.rar