Long Project Design Essay Example

Long Project Design Essay The database will be made in Microsoft Access. The other option is to use is to use Microsoft Excel to do the database but it wouldnt allow me to do a relational database. I need a relational database so that information doesnt need to be entered over and over again like what Michael has to do at the moment. I also looked at various advantages for using Access, which Ive stated below. Furthermore, making a database will accomplish the criteria of being efficient and being able to be used over many years. To meet the needs of the user for an effective solution to his problems, I will need to make a database system that has forms, reports and queries. Additionally, I will also need to make mail merged letters for him. The forms are to solve his organisation problems and time wasting for editing, searching etc. The queries and reports are to solve his time wasting problem in finding things for himself and for customers. My solution will also have to fulfil all of Mr. Longs desires and all of the performance criteria. For my database, I will have the fields: ID, first name, surname, address, telephone number, and date of birth for the Customers table. This is so that it is clear and the different bits of information is organised. The logo will be given to me by Mr. Long. It represents the travel agency so people can easily recognise it. This is also one of the desires Michael had. Part of the performance criteria is to have 4 different tables to store information in. For the Destinations table, I will have the fields: Destination ID, Destination, Airline, and Airport. I think this is enough details for the different destinations and the only ones that are needed. For the Hotels table, I will put the fields: Hotel ID, Name, Address, and Hotel Grade. Furthermore, for the bookings table, I will put the fields: Bookings ID, Departure Date, Departure Time, Arrival Date, Arrival Time, Customer ID, Destination ID, and Hotel ID. This is because the information on customers, hotels and destinations will be linked to the bookings table through relationships. This way, the data doesnt have to be entered all the time. This is an automated process which is one of the performance criterions. The field I use will also fulfil some performance criterions. We will write a custom essay sample on Long Project Design specifically for you for only $16.38 $13.9/page Order now We will write a custom essay sample on Long Project Design specifically for you FOR ONLY $16.38 $13.9/page Hire Writer We will write a custom essay sample on Long Project Design specifically for you FOR ONLY $16.38 $13.9/page Hire Writer One of the criterions is to have tables linked so that it is a relational database. For the relationships, the customers, destinations and hotels tables will all be linked to the bookings table. The Customers ID field from the Customers table will link with the Customer ID field on the booking table. The Destination ID field on the Destinations table will link with the Destinations ID field on the Bookings table. And finally, the Hotel ID from the Hotels table will be linked to the Hotel ID in the bookings table. That performance criteria will now be achieved. For every one of the tables, a form will be made for it. This is because the user wants to be able to access data quickly and easily. By making a form, the information can be accessed, searched, edited, created and deleted easily and quickly. That desire will be achieved. Also, forms can be user friendly with the use of buttons which will make it easy to use. This was one of the desires. For all the forms, I will use the same background to give it a consistent and professional design. Michael desired this. I will also include the company logo to make the forms recognisable. The forms will display all the fields of the table so every bit of information is available for the user to see. I will also make buttons for the user to easily use to the system because it was one of the desires. This way, the user only needs to click on the buttons on the forms for their processes to be carried out. The buttons and logo will be at the same place for each of the forms. The bookings form will be a sub-form within a form. This is so that information on all of the other tables can be displayed in the bookings form. Furthermore, all of the forms can be reused by updating the information on them. By editing the information in the forms, the information in the tables will also be changed so the data will always be up to date. On all of the forms, I will have the Previous record and Next record button. This is because it will make it easier for the user to browse through the records that are there. Also, I will include the print and undo record buttons so the user can print a record and undo one at the click of a button. Furthermore, I will add save record, add record, search record, run word, run excel, close form and delete record buttons. This will save the user time because all they have to do is click the button instead of going through menus after menus. The run word and run excel button are just in case the user needs to access those programs for things such as calculating prices in excel or writing a simple letter in word. Furthermore, for the Destination form, I will also include a Print Destination Report button because Mr Long wants to be able to print a holiday list and I think the button will be able to save him time doing so. It will also solve the problem of photocopying flights to give to customers which is time consuming. Additionally, I will include a Print Hotels Report button on the Hotels form so it can be quickly printed and given to customers. I will also include Luxor Hotels, Cairo Hotels and Hong Kong Hotels buttons so that when a customer enquires about hotels in the countries that theyre interested in, the user can pull up that information with ease. The buttons themselves will open hotel queries that I will make. I will put all the buttons and logo on the forms in the same place so theres a consistent design. I will make a hotels query for each country that is on offer so that the user can quickly get hotels for a particular country rather than going through a list and picking out the relevant ones that are wanted. I will also make a customers query template because Mr Long would like to be able to enter an area and all his customers in that area will come up. I will show Mr Long how to change my template query in the user guide. Also, I will make a query template for destinations so that the user is able to find all the flights available to a particular destination. The instructions for doing this will also be in the user guide. Because Mr. Long wants to know all the customers that are born before 01/01/1955, I will make a query for customers who are born before 01/01/1955 because it needs to be known so that it can be merged with the letter Mr. Long wants to send out. All of these queries can be reused because only the criteria in the queries need to be changed. A main menu will be made where there will be buttons that, when clicked, will open the other forms. This will make my database system easier to use. The main menu will have the same background as the other forms. It will contain a Customers, Hotels, Destinations and Bookings button. I will need to add the logo in it as well. The name of the travel agency will also need to be put on so that it is easily recognised. These will fulfil some of Mr. Longs desires. To make the heading, I will use Microsoft Word. I will choose the font Palace Script MT. After that I will copy it over to paint. In paint, I will fill the surrounding with turquoise. When that is done, I will copy it over to my main menu. I am going to create forms for each of the tables. The font for my forms will need to be clear and easy to read so it will prevent Michael and his staff from reading anything wrong. Also, Ill make the database user friendly so the end user, Michael Long and his staff wouldnt have any troubles to get the hang of it. On the database, the fields must have the correct type of data. For example, the field First name must have the type of data: text. This will minimise the mistakes being entered because you wouldnt be able to put a date of birth in a first name field. The colour of the database will need to be according to the end users preference and I will make a questionnaire to find out a little more about Mr Longs preferences. For the DOB field, I will need to put a validation on it to stop the user from putting in any future dates. This will minimise incorrect data being entered. I will also add queries to allow the user to access certain information quickly as speed is highly wanted . I will also need to put a password onto the database or tell Michael how to do it himself to stop strangers from accessing the database. I need to do this because Michael requested some sort of security system. In my Analysis, I stated that my database should be able to give print outs for the customers on flights and hotels available. To do this, I will need to make reports on the destinations and hotels available so they can be printed off and given to customers. The reports will all have the same style design (corporate) to make it easily recognisable and associated with this business. I am also going to make a customers report because Mr. Long wants to be able to print a destinations, hotels and a customers list. All these reports can be reused because whenever a piece of information in changed in any of the forms or tables, the reports are automatically updated. I am going to make mail merged letters in Microsoft Word because Mr. Long wants an easier and more efficient way of sending letters. For the mail merge letters, I am going to put: Lees Holidays at the top of the letter. Then I am going to put the logo on the top left of the page. This is so that when the customers receive the letter; they will know who its from straight away. I am then going to insert the date on the right hand side so that every time the letter is needed, the date on the letter is automatically changed. This is another automated process which makes it easier for the user to use. I will also make a margin on the left, running all the way down the page. In the margin, I will have the name of the owner, the address, the telephone number and the fax number. After that, I will include the fields: Customer ID, First Name, Surname, Address, Area and Telephone using the mail merge help feature. Then I will write up the contents of the letter talking about the special offer Mr. Long is offering. At the bottom of the letter, I will put Mr. Longs signature. He requested this. The font of the letter will be Papyrus and the font size will be 10. All of this will fulfil the performance criteria for the mail merge letters. These mail merge letters are reusable because the template can be used over and over again. The query just needs to be changed and then the mail merge letters will change. I will make a first draft of the database a show it to Mr Long so he can give me some feedback about it. He will also be able to give me any preferences that he would like to have such as the layout the functions of the buttons. Why Microsoft Access is suitable for this project: Before I use Microsoft Access to actually build the tables, forms, and other objects that will make up the database, it is important to take time to design my database. Whether I am using a Microsoft Access database or a Microsoft Access project, good database design is the keystone to creating a database that does what you want it to do effectively, accurately and efficiently. In Access, I am able to: * Make queries to filter information * Make sub forms to display information in related forms * Make command buttons to link to other forms and carry out tasks for the user * Make a main menu for my travel agency database * Make validations to stop wrong DOB from being entered and to stop wrong departure date being entered Why Microsoft Word is suitable for this project: 1) Input text include fields and relevant addresses 2) Merge text from databases include information the customer requests 3) Importing and editing pictures make the letter look interesting and provide any information only pictures can give. 4) Use colour make the letter look more attractive and interesting 5) Use clip art make the letter look more professional 6) Font, font size and colour make the letter look more professional and interesting. Also, make certain important information stand out more. 7) Add borders make the letter look more professional. I will draw the design of my on forms and tables a piece of A4 paper. After I have done all this, I will test it to see if it works properly. Also, I will need to decide on the colours I will use for the database and see if the colours are acceptable to the client. The colours the client wants should be used for the background and the name of the travel agency. Testing When I have finished the database, I will carry out this test and give it to someone else to do just to double check it to see if I missed anything. I will need to check that: All the hotels, customers and destinations are correct recheck to see if there are any mistakes or missing pieces of data The validations to see if it comes up when an inappropriate date is entered enter a future date for the DOB field and see what happens, enter past date for the Departure Date field and see what happens Command buttons to see if they work properly click on each button and see if the right process is carried out The password works correctly entering the password and seeing if the database opens after All the queries give the correct results carrying out the queries myself All the results of the DOB query goes onto the mail merge letters check the query results and letters All the desires and performance criteria has been fulfilled check the performance criteria and desires and then seeing if my solution has done all of this The end user is happy with the solution asking Mr. Long User Feedback Questionnaire 1) Do you like the current colour of the database? If not, please state the colour desired. Yes No, change to _____________ 2) Is the database easy to use? Yes No 3) Are you happy with the logo and name or do you want me to change the sizes and positions? Yes, happy No, change it 4) Are you happy with the way the letter looks? Yes No 5) Would you like more buttons on the forms? Yes No 6) Are there any particular queries you would like me to make? Yes No 7) Are there any other additional things you need the database to have or do? If so, please state on the lines below. ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ User Feedback: Having showed my initial design to Mr. Long and giving him my questionnaire, he has provided me with the following input to improve the design and layout, making it more user-friendly and appropriate to his needs. * Take off the current plain colour background and change it to a photo * Change it to a nice photo that is blue because his favourite colour is blue * Make the logo bigger on the forms and put it at the bottom of the forms * Make more buttons on the forms to make it even easier to use * Stretch out the bookings sub-form a bit more so he doesnt need to scroll much

How to Write a KILLER LinkedIn Profile Raffle Drawing!

How to Write a KILLER LinkedIn Profile Raffle Drawing! How to Write a KILLER LinkedIn Profile Raffle Drawing! Did you know that last week (February 9-15, 2015) was International Random Acts of Kindness Week? Neither did I, until a woman named Ann Terry Gilman from Germany purchased my LinkedIn e-book- 3 times! I wrote to Terry to find out whether she intended to purchase the book in triplicate, and she responded that no she did not, but would I please give away the two extra books to an organization in need- in honor of RAK week! Terry took the message of RAK to heart and I am happy to announce that The Essay Expert will be holding a drawing on March 1 for an organization to receive a free lifetime subscription to the PDF version of How to Write a KILLER LinkedIn Profile. If you know a job club or an educational institution that would benefit from the information in the 11th edition of How to Write a KILLER LinkedIn Profile, please send the following information to teesupport@theessayexpert.com: Name of contact person Name of organization/institution Description of the mission of the organization/institution Email address the book (and lifetime updates!) will go to We will hold a drawing for 2 winners on March 1, 2015 and the winners will be announced through my e-list! Random Acts of Kindness Life Of course now that I know last week was RAK week, I’m thinking about whether I do enough RAKs in my life. Last week, one day I brought a smoothie to a friend who is a nurse and would miss dinner that day due to working long hours. I tried a new salmon recipe. I drove to Chicago to see people in my class person instead of attending, as I usually do, on the phone. I made 50 phone calls for people to assist on the Transform Training while the other people in my group were making 15-20 calls each. I brought my teddy bear to yoga class and talked to people I would not normally have talked to. I did all these things without knowing it was RAK week! Did you perform random acts of kindness last week too? Here are some ideas: Feel free to take these ideas and run with them on any day or week of the year! When recently have you put a smile on someone’s face or contributed to a good cause? Please share about it below! And if you know of an organization who would benefit from a lifetime subscription to How to Write a KILLER LinkedIn Profile, remember to send their name, organization name, organization mission, and e-mail address to teesupport@theessayexpert.com! Category:Archived ArticlesBy Brenda BernsteinFebruary 23, 2015 1 Comment David Walker says: February 24, 2015 at 10:48 pm Dear Brenda, Contact: Melinda Organisation: Counselling @ Macquarie University Mission: The Student Counselling Team at Macquarie University has a focus on helping students go into/return to the work-place and the Team (Melinda) made it clear that LinkedIn has to be an essential and effective part of my job-seeking strategy. eMail: Counselling@mq.edu.au I purchased your eBook (.pdf) yesterday following an extensive research exercise based upon Melindas advice and I am working my way through your great guidance to update my LinkedIn profile prior to sending out job applications (Ive temporarily turned off access until I make significant (it is a re-write job) changes to that profile. Thank you for some great advice. Ive now established profile access as: linkedin.com/in/davidjwalker01 and a separate complementary job-seeking email address: davidjwalker01@bigpond.com Thanks and great advising David Walker david.walker1@students.mq.edu.au Log in to Reply

A Virtual Battlefield

Cyber warfare is an oncoming threat that will result in devastation. Cyber weapons can seriously hurt a country, and cause chaos that will match Pearl Harbor. Picture this- the click of a mouse could disable air traffic control screens, explode fuel refineries, steal valuable information, derail trains, and fry power grids. All capabilities of a cyberattack. And the bad news is the United States is not as prepared as it should be (for this new kind of warfare), and it’s happening right now. I can’t believe that the United States’ cybersecurity isn’t faring that well. We have known of the threat for a long time, yet defensive measures haven’t been taken. We seriously need to end this threat-our whole nation is at risk. Of course, CYBERCOM is a good start, but there really should be more members, which would result in a larger task force, and a stronger cyber defense. Not all cyberweapons are on a nation crippling scale, however. There have been some attacks on Google and Western Energy Companies, and investigators believe China was the aggressor, and Google declared Cyber War on China. Don’t believe that Google, of all companies, got cyberattacked? Check out http://gpsanalysis.com/?p=41 But, of course, some nation-scale warfare has happened, to the United States, too! In April of 2009, cyber spies infiltrated the Pentagon’s Joint Strike Fighter Project, an approximate three-billion dollar project, and were able to escape with huge amounts of data that was related to the aircraft’s design. Again, officials point to China. Ok†¦maybe Google, but the Pentagon got cyberattacked? Check again! http://www.popsci.com/military-aviation-amp-space/article/2009-04/hackers-breach-joint-strike-fighter-program Although China seems to be the most active offensive cyber attacker, America isn’t just a passive victim. In 2010 Israel and the United States hatched the Stuxnet virus, which targeted Iran’s nuclear enrichment facilities and basically destroyed thousands of centrifuges that were used to purify Uranium. Another cyberweapon hatched by the United States was the Flame virus. This virus seeped through the computers of Iran’s high-ranking officials, and collect information. http://topics.nytimes.com/top/reference/timestopics/subjects/c/computer_malware/stuxnet/index.html Iran has been receiving some heat from the United States and Israel ever since they began their nuclear weapons program. Yet Iran has been on the offensive side too. A cyberattack shut down RasGas, a producer of liquid natural gas in Qatar, and destroyed valuable computer data at Saudi Aramco- the world’s most valuable company. US intelligence confirmed that the aggressor was Iran. Many more cyberattacks have happened around the world though. I’m not going to sit here typing every single cyberattack. Hopefully you get my main point- Cyber warfare is happening RIGHT NOW. Although cyber warfare can really only frustrate and confuse temporarily, a nation can not win a war if the other side has it. That is why not only offensive measures, but defensive measures, are important. Blocking a cyberweapon from destroying data could cost you the outcome of a war, and bring victory to your side. But cyber defense is hard. Now, the enemy is in virtual space and an attack could come from anywhere. How could we possible set a good defense for that? The United States is scrambling to get good new Cyber Warfare tasks. U.S. Cyber Command (CYBERCOM) is America’s Cyber offensive and Cyber defensive military command. CYBERCOM has many tasks that can detect and patch security holes as well as creating new network systems for the military’s computer systems. CYBERCOM engages in offensive warfare and work on cyber weapons that can be combined with Special Operations Missions, or airstrikes. This is the first step to the protection of our great nation, and will prevail over our enemies when it gets the support it needs. New warfare means new tactics. I think that education is really the best way to go with this oncoming threat. Educate the citizens through websites and other essays like this one, and they will respond. Some will understand computer code, some won’t. But that can change through education. Another advantage is that physical strength is no longer a requirement- and we can face this cyber security threat head-on, to protect our nation and its citizens. Again, cyber warfare is happening right now, and is a serious threat. We need to prepare for this new weapon, and prevent our nation from another Pearl Harbor.

Article _(Have Gun) Essay Example | Topics and Well Written Essays - 1250 words

Article _(Have Gun) - Essay Example As said thesis points out, the crafting of government policies has become a sticky process of compromises and negotiations that involve the three major institutions in the American political system: congressional committees/subcommittees, executive branch agencies and interest groups. Sometimes called by various names as policy subsystems, issue networks and iron triangle, the three entities function essentially by staking out a claim over a specific area of public concern. Politics come into play when the executive branch agencies or bureaucracies go out to compete for scarce resources in the policy making arena in a bid to establish and maintain a â€Å"policy domain.† Apart from being specialists or technocrats, present realities thus require that the bureaucrats be also consummate politicians. It was believed to be the politicians more than the technocrats in CDC in action when the bureaucratic agency started to stake out a claim over gun-related violence as its administrative domain in the early 1990s. The agency found as window of opportunity the growing concern of Americans about the corrosive effects of escalating violence caused by firearms. 1) Firearm-related violence is a public health issue. As such, this kind of violence is CDC’s legitimate domain owing to its expert knowledge in the health care arena. The problem needs to identify risk factors, to develop, test and implement appropriate interventions. Violence was defined as â€Å"the intentional use of physical force against another person or against oneself, which either results in or has a high likelihood of resulting in injury or death.† It encompassed such acts as suicide, homicide, rape, assault and child or elder abuse which are intentional. 2) CDC has the necessary expertise in this area. Gun-related violence causes an estimated 35,000 deaths yearly in the US which translates into tremendous health care costs,

Corporate Social Responsibility Research Paper Example | Topics and Well Written Essays - 1000 words - 1

Corporate Social Responsibility - Research Paper Example This essay stresses that for a long time the key areas of corporate social responsibility haves been the well-being of the company’s employees and the protection of the environment. The civil society and the surrounding community focus on corporate social responsibility. The idea behind corporate social responsibility is that companies should not operate in isolation and detached from the broader society in their economic processes. This implies that such views as profitability, competition and survival that traditionally drove business missions are slowly losing ground to corporate social responsibility. New drivers have come because of CSR. It is necessary to explore some of these drivers and analyze how they affect business enterprises. This paper declares that the government’s diminishing role in businesses is one great driver. In many jurisdictions, citizens rely on their governments to provide the relevant regulations and legislations for the delivery of environmental and social objectives among the business communities. However, over the foregoing decades, most countries have witnessed the shrinking of their administration resources and distrust of the regulations set aside. Consequently, companies have resorted to carry out their own exploration non-regulatory and voluntary initiatives for restoring their confidence to the communities of operation. Customers have increasingly developed an interest for accountability and responsibility assumption by business enterprises. ... Customers have increasingly developed an interest for accountability and responsibility assumption by business enterprises. It is evident that the companies’ ethical conduct plays a big role in influencing the customer’s purchasing decisions. It is evident that more than 20 per cent of a company’s clients will likely to reward or punish them based on their perception on the company’s social performances. Besides, there has been an increasing pressure from investors. Lately, many investors assess the performance of companies on matters of ethical concerns before making their decisions on whether to work with the company. According to a report by the Social Investment Forum, there were assets worth more than $2 trillion that were invested in business portfolios that had social and environmental responsibility screens in the year 1999. Besides, more than 25 per cent of American customers considered ethical considerations of a company before purchasing or sell ing stocks with them. This was a survey by the Environics International. The labor market is also very competitive. Nowadays, most qualified and competent employees have increasing focusing on extra benefits beyond their paychecks. In the end, they seek out employers with operating practices and philosophies that coincide with their own doctrines. For a business enterprise to employ and retain these kinds of skilled and competent employees, they are left with no option other than improving their working conditions in terms of corporate social responsibility. Corporate social responsibility is also for the improvement of relations between supplies and business enterprises. This is because stakeholders are increasing

Favourite Movie Essay Example for Free

Favourite Movie Essay My favourite movie is 3 idiot. 3 Idiots is adapted from a Chetan Bhagat’s novel. It is not just a story of 3 engineering students. The movie also presents the struggles of life that people have to face in their lives. The movie portrays how the human struggle for existence begins with the birth of a child. The child opens his eyes in the world to see the expectations floating in the eyes of his parents who want their children to become Engineer, Doctor, IAS, or some other officer, and glorify their family name. The movie effectively highlights the problem of parents pushing their children to choose what they don’t like and make them forget or ignore their hobbies that could have become a great profession for them. This happens overhere with Farhan who wanted to be a wildlife photographer. He could never do well in engineering but once he took up his hobby as profession he never looked back and established new milestones of success. On the other hand, Raju represents the class of children who under the burden of expectations of their parents start to fear failure. This ultimately kills their confidence and leads to their failure. This fear of failure sometimes forces them to take extreme steps as it happens with Raju who tries to commit suicide. But once he gains back his confidence he starts to taste success in whatever he endeavors. The film also depicts that life at engineering colleges is not fun; they have to deal with some serious problems including struggle to get good grades, ragging and mental pressure that forces a student to commit suicide. So I learnt a lot of things from this movie and the most motivating dialogue of this movie told by Rancho â€Å"Don’t run after success, be capable and success will come running after you† motivated me a lot in my life. Last of all I want to say that individual performances, screenplay, direction, editing to cinematography, especially melodious songs gave a perfection to this movie and made this movie, my favourite movie.

Fraus with Plows: The 19th Century Development of Skokie :: Essays Papers

Fraus with Plows: The 19th Century Development of Skokie On the corner of Lake and Wagner Roads in Glenview, nearby an Audi dealership, the Glenview Tennis Club, and an Avon plant, nestled between rows of residential developments, is an 18-acre farm. As if its presence wasn’t anachronistic enough, the cows grazing in the field attest to the fact that the farm, which sits on the border between Chicago’s self-christened North Shore and its inner suburbs, is still in operation despite decades of efforts by developers to purchase it and convert the land into something more profitable for the north suburban niche. In fact, until 2000, the farm was owned by the Wagner family and run for profit, though it has since been purchased by the Glenview Park District and is now maintained as a museum to showcase the village’s historical roots. The rationale behind the village’s $7.2 million investment in the land was, as Park District Board President said, â€Å"...that this is a part of Glenview, and if we don't acquire it, it won't be there to show the children what Glenview was like.† In some ways, perhaps Wagner Farm’s presence is most fitting as a historical division between the two sets of suburbs directly to the north of the city. While both regions began developing simultaneously as outgrowths of the rapidly expanding and industrializing urban metropolis to the south, the lakeshore settlements were almost immediately identified as centers to serve the needs of affluent urban commuters, and their subsequent development was largely directed towards this goal, whereas the inland settlements were abruptly awakened to their similar potential only in the real estate boom of the 1920s. The explosion of road and highway construction after WWII would eventually level the playing field for development between these competing areas and render their boundaries nearly indistinguishable, but until then, towns like Glenview, Morton Grove, Niles, Park Ridge, Lincolnwood, and Skokie (then known as Niles Center) , would develop along a very different trajectory than th eir lakeshore neighbors, one that had much more in common with Wagner Farm than with the elegant single-family homes arranged in well-maintained subdivisions that now surround it. The development of Niles Center in many ways embodies a regional pattern of suburban development in 19th Century Cook County. With the exception of a few showcase towns like Riverside, Hyde Park Center, and the settlements along