Access Database Essay Example for Free

ingress Database EssayProblem relieve superstarself a computerised relational in reverberateationbase using Microsoft Access for a library cozy by beca drop the library has likewise numerous papers and lose many of them, so they want a database that solves all their problems.UsersThe Librarian entrust be going to use the database, and the assistance lead similarly use it, the assistance might non be an expert so the assistance must take classes on how to use the database because it has to be utilise carefully. I will in addition make it substance absubstance absubstance abuser palsy-walsyObjectives* moldiness have more than than atomic number 53 set back (entity) to hold relationships* from each one accede has a primary feather mark to uniquely identify for each one record* Each delay is linked through primary/ alien keys* The database will be normalised so each table has its arrogate data* Create Forms to gather data/ trigger-happyuce mistakes* Create Que ries to pursuit for data* Create Reports to convey the come onput from your queries* Make database user favorable so it can be apply* To show the stemma of the videos in the library* Age crowd of videosAlternative solutionsI could have used a flat file database or Microsoft Excel provided I used a Computerised relational database because if I use flat file database at that place 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 software so I used Microsoft Access.SoftwareThe database managing system is Microsoft Access and the desktop publishing is Microsoft Word in this rattling project.HardwareIn this project, I will use a Windows Based PC because all computers in School hold out them, I will also use a Printer to print out all try and paper movement. I will also use a memory stick as a backup for my project so if it is lost I always have my memory stick.S ecurityFor pledge I will save my work regularly so this would reduce the risk of it not organism saved. I will also save it in several places for physical exercise school computer, computer at home and USB. This will make sure I wont lose my work. I will also regularly print out pages of the project, this will assure the examiner I have done the project, and this will come really tidy sumy if all my work is lost.Input methodI will insert data in design view using Microsoft Access to create tables, sectors. And when my system will be complete, when I muckle it over to my customers they will scuttlebutt data via the forms (in fields)Output methodThe output is when you sound 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 checking that input data is correct. It is normally carried out by a human who visually co mpares the data with the source document. To station 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 conceptualise I could improve in my hand drawn plans?2. What do you think is peachy in my hand drawn plans?3. Do you think my database tones user-friendly, if not why?4. What do you think of the layout of my hand drawn plans?5. Is the emblazon 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 macrocosm 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 check that the primary key is working in Microsoft Access* Each table is linked through primary/foreign keysI will check that I get together the Invoice table with Customer 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 unresolved the forms and check if they work mightily 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 thither is a field for the stock 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 main 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 fit to their tableThey all had the appropriate fields5. Create Forms to gather data/reduce mistakesWhen I open the forms they should work and look like the ones as I designed them to beThey did work but did not like the ones I designed6. Create Queries 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 treasured10. 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 get on didSwitch board customized switch board no t open upshould open up rating of objectives* Must have more than one table (entity) to create relationshipsI unbroken more than one table, in order to input more data. With more tables, there could be more forms. More assorted subjects, and so the database can be made. The main reasonableness 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 relieve oneself 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 obje ctive.* Each table is linked through primary/foreign keysAll the tables are so-called to be linked through the primary/foreign keys 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 unploughed any field names I thought would be useful in my database. In the back 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 redact it and achieved the objective.* Create Forms to gather data/reduce mistakesI created forms for the database so I can input data. and so 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 to 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 prospering 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 assemblyIn this project data will be collected in different kinds of forms. The invoice form, the customer form an d the video form. The librarian will give the customer the customer form for him or her to deal 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 assistant and for the customer to use. For the forms I have kept a simple colour combination. In the forms, in the fields the background colour is yellow and the script 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 surface fairly big so it is easy for the customer and librarian to read or fill in. I have decided 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 verbalize 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 chassis. So I decided to add a video cover image and buttons to all my hand drawn plans.