D2 examples of form and switchboard

D2

The media department at Kingswood school wanted us to help keep record of membership, payments and reviews as at the moment they are handwritten of their film club which has been running for 2 years. They show films every month, and students pay a small fee to become a club member.

I have successfully finished completed a database for their film club. I created forms, queries, macros, tables and the relationship between them.

I’ve followed the specification I wrote at the beginning of this project and I’ve recently just tested the database and it was successful as everything is running perfectly as a part of my P7.

The 4 points below featured in my spec have all been followed:

1. Take handwritten data and put in correct tables – I successfully appended the data into the newly created tables and so you can view all data in the set up that was simple and understandable.
2. Be able to add new member successfully – this was done by creating a registration form so new member can be put into the database.
3. I also created a query with this form so the data can be appended into the right table. After testing the form proved to work successfully so no improvements were made.
4. Report each month’s data – I created a report which allows me to view the data from a specific time period and open it in a word document so it’s easily printed.
5. Validation rules – as I was creating the form and tables I also included different types of validation rules, range check, presence check, list check, input mask and format checks. This was done because it has the data in a certain way that would be easier and a way that I’d prefer.  All the validations were also checked and it was successful.

Improvement

To make the database better and more organised there is a few improvements that I’ve made:

1. I made more forms, so there wasn’t just a member form I made a payment, film reviews form, this will help with the database as users will be able to make reviews etc. more advanced.
2.  I’ve made the database only editable to those with a password so that the database is never messed around with unexpectedly and only those with the password can access this. I did this by opening access office and opening the data base file by clicking the file tab using the open command, click the arrow next to the open button and then select open exclusive.
3. Adding a switch board will allow using the database easily like a website, I will do this so when the customers open up the database they will not have to looks through the database menus to find the form they need.
4. Disable menus will also help with securing the database so no one else can access the data.

Task 5

p7

P4 and Part P6

Task 6 Part P5 Part M3 Unit 18

P6 Unit 18

M2 Unit 18

P3 Unit 18

P2 Unit 18

Data Types 

Text – this allows text numbers and symbols, up to 150 characters

Memo – allows a long text in the data 

Number – this allows a whole number or a decimal number. Only numbers can be entered.

Currency – this automatically formats the data to have   £ or $ or Euro symbol in front on the data and also it can have 2 decimal places.  £8.56 or $ 234.99

Date/Time – this makes sure that you are putting in the right data and it actually exists in the data entry: 1-31 for day (28 or 30) and appropriate months) and 1-12 for months.  For example it would not allow 31.02.2012 to be entered. It also formats the data into long, medium or short data/time.

Auto number- this datatype will increase by 1 as records are added to the database for example 1:1

Yes/No – this data is only restricted to two options, yes/no , male /female