P3 and M2

D2

The database that I have created was made on Microsoft Access. Making it in Access meant that I could easily add information about new members and could  The database was designed for the Kingswoods Film Club. Creating this database allowed easy storage of information about the users.

My database can easily collect members as their is an electronic members table that can keep all this data together. The second table collects all records of payments and also keeps all this information together. This allows it to be read easily by a company and to see all the members and payments made. The third table collects reviews and star ratings about each film, this allows users to make reviews which shows customers whether they should pay for a film. The last table is films information, this table was used for keeping all the information and data together. This made my database easily accessible.

D1 - corrections

P7 - Test Table

Screenshots