Data Manipulation Essay Example for Free

Data Manipulation EssayThe prorogues undeniable in the agreement will be Customer, Products, module and salary. The individual fields in each give in will be as followsCUSTOMER (CustomerID, Surname, FirstName and customer address)PRODUCTS (ProductID, Title, Description, Type and Amount)stave ( moduleID, Name, address and contact number)STAFF SALARY (wages per hour, hours per day and age per week) in that location will be devil topics produced. To produce a report for the ingatherings purchased a query will be place to combine the selective in trackation from the customer add-in and the increase table. The drug user will be able to specify the products bought by a customer with the entire number calculated to give the customer benefits of getting more offers.The second report will print the amount of salary each staff earns per hour, hours/day and days/week. The user is asked to enter the StaffID and name to enter its informationbase.OutputThe two reports should b e able to be viewed on screen with an option of printing it as well. The product purchased report should be printed so that they go off give some discounts on particular customers who shop a lot at the store. The staff salary report should also be printed before any meetings so that they can decide on who to get paid more and who shouldnt.Backup / Security StrategyThe main(prenominal) computer that has all told the data needed should be backed up on a CD every week or even when a large amount of data has been input to the system. This CD should be kept away the main computer incase of a fire, theft or flood.There should be password security on the system so that people cannot hack into it. approach has a password protection before entering the data so that no one can hack into it.Part ThreeInitial DesignsForm DesignThere will be 4 forms for the data entry.Frm CustomerThis form will be used for entering customer items. My initial design is shown belowFrm ProductThis form is used to enter all the products available at the store and the prices of each product.Frm StaffThis form will be used to enter the staff details.Frm SalaryThis form will be used to enter the salary of each staff working in the store.Report DesignThere will be 2 reports. These can be either printed or viewed on screen.Report customer listThis report will come from a query, which combines data the customer table and the product table. The user will be able to enter the Customer name to enter the report for the customer reportThis initial design is shown belowReport Staff SalaryThis report will show how a staff details and how much they earn and how are they rated between 1 to 5 stars for working. Mr. Smith can rate this every week.Menu DesignThe menu structure for this system will look like thisUser Feedback on Initial designsThe initial designs were shown to the omnibus of the store for his feedback and approval. Mr. Smith had the following comments and suggestions I have looked at your designs very carefully and they appear to be useful for me and I did however think of 1 or 2 changes that could perhaps change1) The product sheaths should include which category it is in such as racing, shooting. It would also be easier and helpful if everytime you dont have to type in what category it is in.2) Can the 2 reports be printed all together with a click of a button because it can be time go through3) Can you also do something that can calculate the amount of the products and salary for the staffFinal DesignTable designFour tables are required in this system. They are related as followsThe tables are defined as followsForm DesignThe form designs were amended in accordance with Mr. Smiths suggestions and final designs are shown below. There is a combo box added for the category of the product, which can be easier to select the category instead typing it all the time.Query DesignI will need to create 2 different queries. These will form the sources for my reports.QryCus tomerlistThis query will combine data from 2 tables. Using the customer table and product table. It will ask the user to give the customer name. This will past be asked to find out the customer details or the product details.For e.g. Enter Customer name QryStaffSalaryThis query will combine from the two tables, which are the staff table and the salary table. It will ask the user to enter the staff name to see the list of that particular staff detailFor example enter staff name ImplementationWe will be using Ms Access to make the system needed. I will show in steps how to create this type of a system.First readable Ms Access then you will see promptly the very(prenominal) way I need to enter 30 customer listat once we can type the detail of 30 customers without entering the product IDWith the same way I also need to create the product table. subsequently creating it the design looks like thisNow I need to enter the details of the productsNow we k in a flash the product ID so then I will need to add them in the customer table which does not need to be in an order because a customer may want something else.Now we need to create the relationship between these two table.Like these tables I created I will need to create another 2 more. After creating the table page will look like thisAfter creating the staff tables I now need to create the details of them.Now for the staff salary table I need to enter the detailsNow I need to create the relationship between the Staff and the Staff Salary the same way as I did for Customer an Product. So open the relationship windowNow as I have created the relationship between the staff and staff salary when I will open their table it will showAfter creating the tables I now need to create 2 query.Now I need to create a edict for which the system can calculate the total amount of the product from the quantity boughtNow for calculating the VAT on these products I will doNow I need to calculate the bill amount, which is, Amount a dds the VAT.To check if these formulas work I will now test the systemAfter seeing the amount formula working I will now need to save the work and so I willThis is how it will look like when it closes the queryFor the same way I need to create another query, which relates with staff salary and after it has been done it will look like thisNow that Tables and Querys are end I now need to create forms.Now need to align these in orderNow I need to create title for the form . so I need to open the toolbox.It will look like this when I open the toolboxthen where it says Aa click on it and make a box on the formNow I need to type in the title name.Now I have to organize the cheek and the font sizeNow I need to create command buttons for the system.After creating the commands I now need to create a the background colournow I need to save this formFor the same way I will create another 4 forms and after I created it, it looks likeNow I need to create reportsNow finally I need to create a main Menu, which indicate the user to use the system easily. Main Menu will also be create in the Form