Access Database Essay Example for Free

door Database EssayProblemCreate a computerised relational selective informationbase development Microsoft accession for a library close by because the library has too many themes and lose many of them, so they want a selective informationbase that solves alone their problems.UsersThe Librarian provide be going to use the database, and the assistance will also use it, the assistance might not be an expert so the assistance must take classes on how to use the database because it has to be used c befully. I will also make it substance abuser friendlyObjectives* must realise more than one accede (entity) to create relationships* Each confuse has a special key to uniquely find each eternise* Each table is linked through primary/foreign keys* The database will be normalised so each table has its appropriate data* Create Forms to gather data/ bowdlerize mistakes* Create Queries to search for data* Create Reports to coming into court the output from your queries* Make databa se user friendly so it nookie be used* To show the stock-taking of the videos in the library* Age group of videosAlternative solutionsI could take over used a flat file database or Microsoft Excel but I used a Computerised relational database because if I use flat file database there will be lots of paper, too much space will be used unnecessarily and too much to carry. And I couldnt use Microsoft Excel because the librarian doesnt have that softw ar so I used Microsoft Access.software productThe database managing system is Microsoft Access and the desktop publishing is Microsoft Word in this very project.HardwareIn this project, I will use a Windows Based PC because all computers in School support them, I will also use a Printer to print out all evidence and paper make believe. I will also use a memory stick as a backup for my project so if it is lost I continuously have my memory stick.SecurityFor security I will save my work regularly so this would reduce the risk of i t not being saved. I will also save it in several places for ideal school computer, computer at home and USB. This will make sure I rule lose my work. I will also regularly print out p develops of the project, this will assure the examiner I have done the project, and this will muster very handy if all my work is lost.Input methodI will input data in design view using Microsoft Access to create tables, fields. And when my system will be complete, when I hand it over to my guests they will input data via the forms (in fields)Output methodThe output is when you run a Query on a PC, its result or output will come onto a report, that is that is the output method.ProcessWhen query runs it searches fro a database that is an example of a process.VerifyVerification is the process of stamp downing that input data is correct. It is normally carried out by a human who visually compares the data with the bring inress document. To site check, is an example of verification. For example, to check that the fields work.ValidateVerification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. Input masks, is an example of validation.Questionnaire1. What do you think I could improve in my hand careworn plans?2. What do you think is good in my hand move plans?3. Do you think my database looks user-friendly, if not why?4. What do you think of the layout of my hand drawn plans?5. Is the food coloring combination used good, is the style of the page good?6. Overall, what do you think of the hand drawn plans, should I redo do them, or keep it as it is?7. Out of a rating of 5 being the highest, what do you rate this database?Test PlanOBJECTIVESTEST* Must have more than one table (entity) to create relationshipsI will check that the relationships work because if they work that means I have more than one table* Each table has a primary key to uniquely identify each recordI will chec k that the primary key is working in Microsoft Access* Each table is linked through primary/foreign keysI will check that I connect the Invoice table with client and Video table and check it in E-R diagram* The database will be normalised so each table has its appropriate dataI will check that each table has its own headings so that it is user friendly and will check it in design view* Create Forms to gather data/reduce mistakesI will subject the forms and check if they work properly in Microsoft Access* Create Queries to search for dataI will open the queries and check if they work properly in Microsoft Access* Create Reports to show the output from your queriesI will open the reports and check if they work properly in Microsoft Access* Make database user friendly so it can be usedI will ask people about my database by giving them a questionnaire, if they think it user friendly* To show the stock of the videos in the libraryI will check in my forms that there is a field for the st ock of the videos* Age group of videosI will check in my forms that there is a field for age group of videosObjectivesWhat should happen?What actually happened?1. Must have more than one table (entity) to create relationshipsThe tables should have relationships + must workThey worked as I expected them to2. Each table has a primary key to uniquely identify each recordThe table has a primary key, the of import oneThe tables didnt work because it had no primary key3. Each table is linked through primary/foreign keysThe tables should be linked through primary keysThey worked as I expected them to4. The database will be normalised so each table has its appropriate dataThe tables should have its appropriate fields according to their tableThey all had the appropriate fields5. Create Forms to gather data/reduce mistakesWhen I open the forms they should work and look the homogeneouss of the ones as I intentional them to beThey did work but did not like the ones I designed6. Create Querie s to search for dataWhen I open the queries they should work and look like the ones as I designed them to beThey worked as I expected7. Create Reports to show the output from your queriesWhen I open the reports they should work and look like the ones as I designed them to beThey did work but did not like the ones I designed8. Make database user friendly so it can be usedFrom user feedback they should tell me its user friendlyFrom user feedback I got told that my database is user friendly9. To show the stock of the videos in the libraryWhen I open the library, there should be a field called Stock of VideosThere was not the field, which I wanted10. Age group of videosThere should be a field called Age group of videos in video formThere was the field, which I wantedTesting Table11. To have a customized When I open up database A switch board didSwitch board customized switch board not open upshould open upEvaluation of objectives* Must have more than one table (entity) to create relatio nshipsI kept more than one table, in order to input more data. With more tables, there could be more forms. More different subjects, and so the database can be make. The main reason was so I can create relationships. The reason for the relationships are so I can relate or link the tables with each other. This is very helpful. For example I can add the field name Customer_ID from the Customer form, and the field name Video_ID from the Video form to the Invoice from. In the end, I managed to achieve the objective.* Each table has a primary key to uniquely identify each recordEach table has to have a primary key to uniquely identify each record because without it the table would not work, they are also needed for relationships, if you want to create relationships between several tables. At first it did not work but later after many attempts I achieved the objective.* Each table is linked through primary/foreign keysAll the tables are supposed to be linked through the primary/foreign ke ys or else they will not work. I did this on the E-R diagram and also did it on the database and I achieved the objective.* The database will be normalised so each table has its appropriate dataI normalised the data, for each table. I did 3 normalisations. In the first one, I just kept any field name calling I thought would be useful in my database. In the second one, I put them in tables and in third normalisation I took out the extra field names that were not relevant. Most of it was good except one field name was wrong, I edited it and achieved the objective.* Create Forms to gather data/reduce mistakesI created forms for the database so I can input data. Then I created them at first they did not work, but later I fixed them and achieved the objective.* Create Queries to search for dataI created queries for the database so I can search for data and they worked the first time I tried. I achieved the objective.* Create Reports to show the output from your queriesI created reports t o show the output and it can be very helpful to the customer or librarian. At first when I created the reports, they were not same as my hand drawn plans, but then in edited them again and I achieved the objective.* Make database user friendly so it can be usedI made the database user friendly so it is easy to navigate. And I achieved the objective.* To show the stock of the videos in the libraryI made the field name of stock of videos in the library, at first the field was missing but then I added the field name and achieved the objective.* Age group of videosTo show the field name of age group of videos and I achieved the objective.To have a customized switchboardAt start it did not open up, but then I achieved the objective.Data CollectionIn this project data will be collected in different kinds of forms. The invoice form, the customer form and the video form. The librarian will give the customer the customer form for him or her to fill in. For the invoice form and video form the librarian will be expected to fill in the data for those forms. There will also be reports and queries made for some the data.Designs ExplainedI have kept my forms very user friendly so it easy for the librarian, the associate and for the customer to use. For the forms I have kept a simple intensity combination. In the forms, in the fields the accentuate colour is yellow and the handwriting colour is blue because yellow and blue go well with each other, the colours are also bright and easy to read. For filling in the data, in those blocks the background colour will be red and the handwriting colour will be black because red and black are a good colour combination and will be easy to read. I have kept the handwriting size fairly big so it is easy for the customer and librarian to read or fill in. I have distinguishable to use the font Arial because it is very clear and big. Also for the field names I have decided to keep them bold because they are very important. My reports are also very user friendly and attractive.User feedbackFrom the user feedback I have decided to keep my hand drawn plans as my final designs because of the feedback I got. They have said everything in my hand drawn plans is good. They also said it is very user friendly, clear and the colour combination used goes very well together. However, one person said to add buttons and maybe an image. So I decided to add a video cover image and buttons to all my hand drawn plans.