In my case the first election did not need to be changed so I clicked on ‘Find Next’ again. This time it selected an entry that needed to be changed so I selected ‘Replace’ and continued this process until all changes had been made. To change the name of Pl to PI-Turbo I followed the same process, and once I found the first instance of Pl after September 2011 1 started making the necessary change. Question 1 -C l. To make hundreds of changes in this way could be a very time consuming effort.
To change this I would potentially use a filter to narrow down the results on my screen and then Just enter the correct data In the first cell and then using the 4′ In the corner of the cell drag It down to the bottom of the appropriate cells. In this case, but once the company grows, so will the amount of customers, staff and products. Making it difficult to keep up with manually entering all of the data and fixing any mistakes that may occur. Question 2-A Question 2-8 Question 2-C In this case, only 1 item gets changed (only one instance of Champion Location being Sydney, as pictured above).
Question 2-E My results after updating queries. Question 2-F To normalize the data within a database a few things would need to occur to reduce or remove repetition, redundancy and inconsistencies in the data. While databases are a great way to make a large amount of data more compact and using queries’ be used to initially setup the database. To remove repetition and redundancy the user must be concise with what they are using in the queries. To reduce inconsistencies, once again the user must be concise with what they are entering into the spreadsheet. Question 2-G
Spreadsheets and Databases both have the opportunity to help the user get a desired result, but they both also have short comings. Spreadsheets are often more popular and easier to navigate than Databases, and provides users with the ability to be able to create charts, formulate equations and create multiple pages within one spreadsheet. More often than not, spreadsheet programs such as Excel can be ubiquitous, and can be used by all people for ‘exploratory data analysis’ (Appaloosa, S, 2010, up 191) and is Very easy to handle but are not well-suited for more complex applications’ (Baler, T & Inherits, E, 2007, up 91).
Databases use the information within the spreadsheet to create relationships between data, create queries to make information more concise and allow the user to get more relevant data. Lillian et al (2004) found that when they conducted research on “decisions made and the decision processes that lead to those decisions…. Found that decision makers who use high-quality model-based databases make objectively better decisions than do decision makers who only have access to a generic decision tool (Microsoft Excel)”.
