For those of you who want to raise your mark doing the 'database project', here are some tips which may help you:
What to do:
- Design on paper how your tables will be related.
- Start a new database:
- First design the tables
- Enter two records for each table to see if everything’s working fine.
- Then design the queries. Think of what are the things that the user will need to search in the database. At least 3.
- Test the queries by putting some more data in the tables.
- Design the reports; one for each query. If you want you can make reports with all the information from certain tables too.
- Test your reports to see if everything’s right. Don’t forget to check that the layout of the report: it must look nice and neat.
- Build the forms to input data into the database.
- Test your forms to see if they work.
- Create a Menu (with any submenus you need) to navigate through out all your application (the use of your own macros will give you more marks).
- Change the startup configuration so the Menu form opens automatically at the start.
- Do anything else that can make your application look better and more useful.
There is a wide variety of possible situations where you could investigate the application of database software. These includes:
| video library | garage | nursery | newsagent | milk round |
| hair dresser | farm | dentist | vet | stables |
| mail order business | accountant | pharmacist | music collection | tourist attractions |
| travel agent | coach hire business | driving school | social club | sports club |
| solicitor | dating agency | optician | builder | beauty salon |
| computer games | stock | restaurant | kennels | employees |
Database rubric.
Student name: ______________________
Class: ____
Requirements:
At least 3 tables………
At least 3 queries ……
At least a report per query ………
Enough forms to enter data into each table ……
A main menu …
Access to each different report and form from the menus…
Macros used ……
Following data are given a mark from 0 to 10
Tables
| Use of data types | |
| Use of validation rules | |
| Use of field length | |
| Use of required | |
Extras/comments:
…………………………………………………………………………………
Queries
| Queries from more than one table | |
| Multiple criteria’s | |
| Asking questions to the user in criteria | |
Extras/comments: …………………………………………………………………………………………………
Reports
| Headings fit on one page | |
| Grouping levels, sorted out results | |
| Attractive layout | |
Extras/comments:
………………………………………………………………………………………
Forms
| Clear layout | |
| Correct number of fields | |
| Combo boxes or list boxes | |
| Subforms with easy combo box search | |
Extras/comments:
……………………………………………………………………………………
Navigation
| Main menu with submenus: clear layout | |
| Attractive Menus | |
| Macros (using their own macros, as for more than one action in one go (closing and opening forms), scores higher) | |
| Go back buttons on forms | |
Extras/comments:
………………………………………………………………………………………
Good luck! :)
Mr Lopez
