You will need to use internet resources to collect data about computing hardware (computers, tablets and phablet combinations). You will use Data visualization techniques to display the data support for a hardware purchase recommendation. • • • • Your Task: You are asked to provide data to assist a college bound student (Friend) in selecting a computer to complete course assignments. Find data about computers/ tablet hardware; from at least 3 vendors. Display your data for speedy and actionable insight. Some factors to include are: Power – ports – compatibility – features (keyboard, number key pad, screen size) –footprint – cost – warranty. Include a decision as to which computing device(s) you will recommend to your “friend”. BUDGET: Friend has a maximum of $921 to spend for this device. Provide at least one graphic and one table. Send a copy of your recommendations and supporting data displays (Excel spreadsheets, Tableau maps). you will design a relational database, enter records, create queries, and reports. You may design a relational database for your own data Background storyline: You are asked to design a relational database for an organization or business. Clients log on to the site and provide their first and last names, address, phone number, email address; you keep data on products and sales amounts; you could also want data about your employees, date of hire, their first and last names, address, phone number, email address. Be realistic – consider the entities and attributes you choose when a business designs a database. • o o o • o • • • your Task: • You will use your own data You will invent data based upon the above storyline including At least 3 entity tables At least 3 attributes for each entity At least 6 records for each entity You will design a relational database in Access. Build a table for each entity, all fields and the primary Key. You will input your invented data into Access tables. You will want to invent data so you may create queries and generate reports to be used by management. (what style/sizes are/are not selling well; best customers, longest employee history. . .) Send your entity relationship diagram, tables, and summary reports
The post MS Office Excel and access problem first appeared on Assignment writing service.