database/ microsoft access project
database/ microsoft access projectTitle of Brief: Design & Implement an Access Database System (LOs 1, 2, 3, 9, 10, 11)
Teacher’s Feedback and Comments
Areas for improvement:
Feedback has been provided in relation to work submitted for this assignment:
Teacher Signature: ______________________________ Date: _______________
Learner Signature: ____________________________ Date: _______________
OR Student absent for feedback
Work submitted after the submission date must be accompanied by a fully completed Mitigating Circumstances Form and relevant documentation. All work must be spellchecked. No spelling waiver will apply. Submitted work should be clear, readable and neatly presented. Submit corner stapled. Keep a soft copy of any relevant submission material. Any results issued are provisional pending the completion of the External Authentication Process in May/June 2017.
General Project Brief
Design, build and document a database system which will computerise a pre-existing paper-based system in a small business, voluntary organisation, a personal filing system, or any other suitable context. The database should incorporate 2 tables, each with a primary key. There should be a relationship between the tables. One of the tables must have at least 5 fields and aminimum of 25 records.
Create a report with the following section headings and numbers:
1. Uses of Databases (5 marks)
1.1 Describe two typical databases that the general public would be familiar with. What might the primary key/s be in these typical databases?
1.2 Briefly explain the purpose of each of the following views of a query: Design View, Datasheet View and SQL View
2. Design (20 marks)
2.1 Current System/Problems/Solutions
Describe the current system. Describe 2 problems with the current system. (These should be specific to the system, not general problems with all paper-based systems).How will your new computerised database system will solve the 2 problems you have identified?
2.2 Table Design: What is the Structure of the Tables?
For each table, indicate each field name, data type, size, and give an example of data that will be stored in the field. Use a variety of data types (text, numeric, date/time, etc.)
Identify the primary and foreign key fields in the tables.
Describe the relationship between the 2 tables (include a screenshot of the implemented relationship when you have created it).
2.3 Query Design: What Queries will the New System Produce?
The new system should produce at least two appropriate queries, which should relate to the problems in section 2.1.At least one query must have an and/or condition. At least one query should be sorted. At least one query should incorporate data from 2 tables.
For each query, specify the following:
• Query name
• Purpose of query
• The table/s that the query is linked to
• Fields in the query
• Query condition(s)
• Sorting where used
2.4 Report Design: What Reports will the New System Produce?
The new systemshould produce at least 4 appropriate reports, which should solve problems identified earlier. At least one should be grouped and sorted. At least one should be based on a query. At least one must include a sum, average or count function.One must produce labels.
For each report, specify the following:
• Report Name:
• Purpose of report:
• Table/s or query/queries linked to:
• Fields included in the report:
• Sort and grouping (if any):
• Report functions (if any):
2.5 Form Design:
Plan the design of at least 1 form, using Word or draw by hand. Consider colour, image, text formatting, and ease of use. The form should show data from more than one table. Indicate the table/s where the field/s originate. Include a combo box for extra marks.
3. Implementation (20 marks)
Using your design as planned in Task 2, create the actual database system using Access.
Submit printouts of the following:
3.1 The relationship diagram (Use the Relationship Report option in Access)
3.2 For each Table:
• Datasheet View showing all the records
• Structure (Use the Database Documenter. For tables, include properties. For fields, include names, data types, and sizes. For indexes, include Nothing.)
3.3 Data entry form/s
3.4 For each Query:
• Datasheet View showing all the records
• Structure (Use the Database Documenter. For Query, include Properties and SQL. For Fields, include Names, Data Types and Sizes. For indexes, include nothing).
3.5 Report View of each Report.
Generally, extra marks will be awarded for user-friendly layout of objects such as forms and reports.
4. Review (5 marks)
Suggest at least two limitations of your database system – ie ways in which your database could be improved if you had more time. How would you approach solving these issues? Describe in detail.
During implementationyou may have added in some extra features that you had not planned for when you designed the computerised database system. If so, describe these features, why you included them, and how you did so (at least two features).
How/What to Submit:
Submit a soft copy of your database file by uploadingit to Moodle
Submit a softcopy of your report by uploading it to Moodle
Submit a hardcopy of your report with a printout of this document to the Caretaker’s Office.