Access Database Essay Example for Free

Access Database Essay Problem: Create a computerised relational database using Microsoft Access for a library close by because the library has too many papers and lose many of them, so they want a database that solves all their problems. Users: The Librarian will 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 carefully. I will also make it user friendly Objectives: * Must have more than one table (entity) to create relationships * Each table has a primary key to uniquely identify each record * 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/reduce mistakes * Create Queries to search for data * Create Reports to show the output from your queries * Make database user friendly so it can be used * To show the stock of the videos in the library * Age group of videos Alternative solutions: I could have 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 software so I used Microsoft Access. Software: The database managing system is Microsoft Access and the desktop publishing is Microsoft Word in this very project. Hardware: In 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 work. I will also use a memory stick as a backup for my project so if it is lost I always have my memory stick. Security: For security I will save my work regularly so this would reduce the risk of it not being saved. I will also save it in several places for example: 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 very handy if all my work is lost. Input method: I 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 customers they will input data via the forms (in fields) Output method: The 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. Process: When query runs it searches fro a database that is an example of a process. Verify: Verification 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. To site check, is an example of verification. For example, to check that the fields work. Validate: Verification 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. Questionnaire 1. What do you think I could improve in my hand drawn plans? 2. What do you think is good in my hand drawn 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 colour 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 Plan OBJECTIVES TEST * Must have more than one table (entity) to create relationships I 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 record I will check that the primary key is working in Microsoft Access * Each table is linked through primary/foreign keys I will check that I connect 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 data I 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 mistakes I will open the forms and check if they work properly in Microsoft Access * Create Queries to search for data I will open the queries and check if they work properly in Microsoft Access * Create Reports to show the output from your queries I will open the reports and check if they work properly in Microsoft Access * Make database user friendly so it can be used I 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 library I will check in my forms that there is a field for the stock of the videos * Age group of videos I will check in my forms that there is a field for age group of videos Objectives What should happen? What actually happened? 1. Must have more than one table (entity) to create relationships The tables should have relationships + must work They worked as I expected them to 2. Each table has a primary key to uniquely identify each record The table has a primary key, the main one The tables didnt work because it had no primary key 3. Each table is linked through primary/foreign keys The tables should be linked through primary keys They worked as I expected them to 4. The database will be normalised so each table has its appropriate data The tables should have its appropriate fields according to their table They all had the appropriate fields 5. Create Forms to gather data/reduce mistakes When I open the forms they should work and look like the ones as I designed them to be They did work but did not like the ones I designed 6. Create Queries to search for data When I open the queries they should work and look like the ones as I designed them to be They worked as I expected 7. Create Reports to show the output from your queries When I open the reports they should work and look like the ones as I designed them to be They did work but did not like the ones I designed 8. Make database user friendly so it can be used From user feedback they should tell me its user friendly From user feedback I got told that my database is user friendly 9. To show the stock of the videos in the library When I open the library, there should be a field called Stock of Videos There was not the field, which I wanted 10. Age group of videos There should be a field called Age group of videos in video form There was the field, which I wanted Testing Table 11. To have a customized When I open up database A switch board did Switch board customized switch board not open up should open up Evaluation of objectives * Must have more than one table (entity) to create relationships I 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 made. 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 record Each 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 keys All the tables are supposed 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 data I normalised the data, for each table. I did 3 normalisations. In the first one, I just kept any field names 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 mistakes I 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 data I 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 queries I 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 used I 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 library I 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 videos To show the field name of age group of videos and I achieved the objective. To have a customized switchboard At start it did not open up, but then I achieved the objective. Data Collection In 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 Explained I 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 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 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 feedback From 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.

Comparing Different Types of Love in William Shakespeares Romeo and Ju

Comparing Different Types of Love in William Shakespeare's Romeo and Juliet The three different examples of love between Romeo and Juliet, Romeo and Rosaline and Paris and Juliet do share some similar aspects, but they also have their own differences. These three different types of love show us the variations of love and how it can mask itself into different forms. Romeo's 'love' for Rosaline. He was portrayed as a Petrarchan lover and his 'love' was simply an infatuation. He did not take time to know Rosaline or understand her, but thought that he truly loved her. In actual fact, he was only attracted to her because of her beauty; "The all-seeing sun/Ne'er saw her match since first the world begun." Romeo knows that Rosaline does not love him, that the relationship is not mutual. Romeo became depressed when he realised that Rosaline did not love him. He was moody and withdrawn. His use of oxymorons such as "bright smoke, cold fire, sick health" shows his uncertainty and confusion of this 'love' he has for Rosaline. Romeo's love for Rosaline is clearly infatuation, which really is not true love. Similarly, we question Paris' 'love' for Juliet. Did he really love her? His love for Juliet was not as straightforward. He did not even know Juliet, probably falling for her beauty rather that loving her for who she really was. It was probably superficial, but we cannot completely ignore his attempts to show 'love'. He risks his reputation as a noble by visiting Juliet's grave in the dead of the night so secretly and suspiciously. Also, when Romeo kills him he asks to be put in her tomb, "If thou be merciful, Open the tomb, lay me with .. ...d be one that was approved and acknowledged. Not like the one between Romeo and Juliet, where the choice to get wedded was based purely on their own decision and not one that was consulted with their own parents. Compared with Romeo's love for Rosaline, his best friends knew about it, Benvolio having found out when he spoke to Romeo, and probably telling Mercutio. It wasn't a total secret but was kept hidden from his parents. It is obvious that the love Romeo has for Juliet is true and deep, it is also reciprocated, unlike the one between Romeo and Rosaline, and Paris and Juliet. Also, the three relationships showed signs of hastiness and rashness, which resulted in a short-lived and rather brief relationship. However, the love did affect the characters in some way or other and had changed Romeo into a better person.

Phytomining †Pros and Cons Essay

Phytomining describes the production of a metal crop by using high-biomass plants, which are plants that produce energy or a usable resource when burnt. Phytominers cultivate crops of a specific plant species with high concentrations of a desired metal, harvest the plant and deliver it to a furnace to burn and gather its bio-ore. As a potential alternative to environmentally destructive mining practices, phytomining has great promise to transform the way metals are extracted from the environment; however, phytomining has yet to produce metal yields that would begin to satisfy global demand. Environmental Considerations It is generally accepted that phytomining is greener than conventional mining practices. In environments with metal-contaminated soil, phytominers can recollect metal pollutants from the soil, thereby restoring the soil to health. Still, growingmass amounts of plants also takes a toll on the land used for cultivation. Industrial farming practices deplete the soil and overgrowing biocrops has the potential to permanently alter an area’s ecology. Economic Viability If the scale of production is large enough, phytomining could become a cheaper alternative to excavation, but large-scale harvesting of plants with concentrations of metal is currently more costly than extracting metals from mines. In the future, as metal prices rise and the yields from mines deplete, this could change. The shortage of metal from mines and persistent demand for metal by industry would offset the costs of initiating large-scale phytomining farm production. Growing Conditions Phytomining’s success is subject to the forces of nature. Unlike traditional excavation, phytomining is dependent on growing conditions such as the weather, altitude and soil quality. A bad growing season could wipe out an entire crop of metal-producing plants, and if global climate change alters weather patterns, the risks associated with establishing a long-term phytomining industry in an area increase. Other Considerations As with any new industry, much is unknown about the long-term effects of phytomining. For example, with a limited amount of good farming land available, what land use would be displaced to make room for a phtyomining industry? Researchers will also need to examine the effect of having metal-enhanced plants entering the food chain over time. They will also need to determine if it is possible to prevent metal runoff from the plants from entering the local water supply.

The French Revolution And The Arab Spring - 1322 Words

Throughout history many societies have, and will likely continue to have revolutions as we as humans strive towards a utopian society. Each and every one of these revolution follows some pattern, a pattern that most often includes a great number of civilian casualties. But what is it that pushes such revolutions forward? Why have people risked and given their lives fighting against their own leadership? Looking at both the French Revolution and the Arab Spring can help uncover the answer to these questions, as for people to willingly risk their lives, they must have been living in destitute situations. Both of these societies did indeed have many social and economic problems, as well as a poor quality of life, specifically for the bottom class, or in the case of the French Revolution, the Third Estate. It is because of these issues that the people stood up to their leaders and demanded a better life, overtaking the government in the process. Prior to the French Revolution enlightenme nt thinkers such as Voltaire had been writing about equality and individual freedoms. These ideas began to catch hold with the populous of France, who were almost all living in very poor conditions. Perhaps the most important of these authors, in regards to the French Revolution, was John Locke who talked about the idea of a decentralized government, a system where the people represented the people; a democracy.1 The people of France began to make a push for such equality, and in August ofShow MoreRelatedArab Spring and the French Revolution1272 Words   |  6 PagesFrench Revolution and the Arab Spring Essay Essay Prompt: To what extent does the French Revolution reflect the recent conflicts seen within the Arab Spring? Note: Consider the following themes: * Short-term and long-term causes * Popular Revolts * Voice of the People – leaders, writings, media and symbols * Shifts in Power * International Interventions * Religious Repercussions Research links/News Articles: Middle East Region - http://www.time.com/time/magazine/article/0Read MoreAfter researching informational texts on modern and historical revolutions, write an essay that800 Words   |  4 PagesAfter researching informational texts on modern and historical revolutions, write an essay that compares a modern revolution to the French revolution and argues the significance of each. Mikayla Hammers World Studies Revolutions essay March 11, 2014 The French revolution and the Arab Spring revolution are comparable and both play significant roles. Many aspects of the revolutions from the causes to aftermath in the Middle East can resemble those that happened in France. All of which plays significantRead MoreThe Arab Spring Revolution is a Failure1303 Words   |  6 PagesThe Arab Spring Revolution is a Failure â€Å"Arab spring mishap leads to sharp increase of oil smuggling†, â€Å"Syrian revolution starts experiencing causalities†, â€Å"Overthrown Egyptian government a downright failure†, â€Å"Tunisia on the verge of economic collapse post being struck by the Arab spring revolution†, â€Å"Bombing in Libya kills 20 in the proximity of a ration distribution unit†. These were the kind of news headlines the modern world was bombarded with when the riots in the Middle East were instigatedRead MoreCauses And Effects Of Revolutions1237 Words   |  5 PagesCauses and Effects of Revolutions Revolutions have occurred throughout history and continue to arise even in the present day. Many revolution happens because of the miscommunication between the government and its citizens. In the end, the outcome of revolutions are usually good but, sometimes it might not be what people want. In the following paragraphs, examples of the general causes and effects that creates a revolution will be discussed in order to illustrate how revolutions are mainly caused byRead MoreBritish Control Over The Suez Canal1351 Words   |  6 PagesAbdel Nasser to power. His rise to power lead to the Suez Canal Crisis and Egypt’s independence from Britain in 1956. The Arab Spring began in Tunisia in December, 2010, eventually spreading to Egypt in 2011. British control over parts of Africa during the nineteenth century lead to many crises in the 20th and 21st centuries, including the Suez Canal Crisis and the Arab Spring in Egypt. The Cold War began soon after the Second World War ended, starting in 1947 and ending in 1991. The United StatesRead MoreToo Soon to Tell: An Examination of the ‘Arab Spring’ and its Impact on Israel1437 Words   |  6 Pagesof Tunisia to the entire Arab world. Israel, as the only democracy in the area, has very delicate relationships with many of the countries involved. With the Muslim Brotherhood coming into power in Egypt, the possibility of the decades long treaty with Israel coming to a violent end is more threatening than ever. This leads us to consider the danger of other ideologically like-minded groups continuing to surround Israel. On the surface, it may seem as if the Arab Spring is very bad news for IsraelRead MoreThe Arab Spring1807 Words   |  8 Pagesï » ¿The Arab Spring The Arab Spring is an uprising in the Arab world against their government. The uprising started in Tunisia by a man named Mohamed Bouazizi who set himself on fire in protest for the harassment and repression from the Tunisian government. Rebel groups throughout the Arab world in countries such as Tunisia, Egypt, Libya, Syria and Bahrain, were formed with the intent of overthrowing their government and/or changing their regime. This came as a shock to many political scientists becauseRead MoreWhat Is Syria Essay1398 Words   |  6 Pagespolitical groups that have shown to be susceptible to the whims of its’ bickering neighbors and is engulfed in a brutal civil war that has claimed close to a half a million lives. Syria began its existence under French rule. It wasn’t until 1946, when they were granted full independence by the French government, that they began to develop an internal governing structure. However, the region was not politically stable and was plagued by many military coups for the next few decades. The country finally stabilizedRead MoreDoes Inequality Help Or Hurt Democracy / Democratization?858 Words   |  4 Pagesbe a citizen and be a full part of the democracy. This notion of what a democracy is slowly evolved out of different revolutions and ideas. WE saw great leaps forward in what democracy is with the US revolution where the cry was â€Å"No taxation without representation.† To the French revolution that so much has been studied about. To the modern day, where we have seen the Arab spring rise and fall, with some countries making modest reforms and people fighting for as many reforms that they can get, toRead MoreThe Battle Of Civilizations By Samuel P. Huntington1302 Words   |  6 Pagesand simplicity of the two groups used in Huntington’s article. The terrorist attacks on September 11, 2006 led many to believe that it was the start of clash of civilizations, which Said argued as one not seeing the whole picture. The Egyptian revolution, of thousands pouring onto Cairo’s Tahrir Square demanding the self-determination they were denied, shows that the clash of civilization was a myth. The world is filled with clashes and significant conflicts, through the perspective of Huntington’s