Question: Using Access and Excel, develop a database (30 records) for a small business (SME) where the business started information system data entry with 30 products/services.

Using Access and Excel, develop a database (30 records) for a small business (SME) where the business started information system data entry with 30 products/services.

a. Design an information stock sheet with IF and VLOOKUP formulae to keep track of their inventory details such as price list, stock available, product details and product code.

b. Export the database to Microsoft Access and generate report using Microsoft Access such as table, query, form and report .

c. Create at least additional 10 records in Microsoft Access to the existing 30 records in EXCEL and generate a different Microsoft Access report.

d. Export ALL the 40 records to Excel, create a PivotTable and analysis chart with quarterly reporting on the sales on the products database. (location, geographical or zone territory)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Using Access and Excel, develop a database (30 records) for a small business (SME) where the business started information system data entry with 30 products/services. a. Design an information stock...

(Will thumbs up if completed, part of assignment already done, case study and previous information provided below for assignment ) (Edit: I need stage 2 completed I provided the previous stage which...

Hard Rock case study: Describe three data elements you would reasonably find in Hard Rocks CRM ( read Special note on metadata) Ward and Little's turnaround strategy for the Hard Rock Caf is...

answer question 1,2 pleaee? 1. Is Doug's Dens a business that can effectively utilize MRP for planning its inventory? Why or why not? 2. Develop a material requirements plan for the next 8 weeks...

please answer question 1,2,3 ? Background - Doug's Dens doghouses Analysis Q1 ( using MRP effectively ?) Q2 Recommedation Q3 (MRP Implementation) 276 PART Tools and Tactical issues CASE STUDY Doug's...

Case Study 1- Properties Das Ist Gut 4U (BI Implementation) Introduction Properties Das Ist Gut 4U (PDIG4U) is Germanys largest diversified property group. PDIG4U develop, own and manage retail...

Capstone Project: Implement a Technical Solution for a Small Business Objectives Part 1: Gather information and determine customer requirements. Part 2: Gather system requirements. Part 3: Plan the...

*PLEASE JUST ANSWER QUESTION 2 WITH THE DATA IN THE FIRST PICTURE* Ao 20 AutoSave OFF Ch7_CaseDocument(1) - Compatibility Mode Home Insert Draw Design Layout References Mailings Review View Developer...

Term Project Every two weeks project discussion in the class and update. Part 1: Presentations are due Week 11, Week 12 project presentations in the class. If you ready earlier you can present...

Assignment-1: (Assume that the new system will be a networked desktop system.) 1.. Develop a list of requirements for the SSL Case Study for a new Information System based on the statements provided...

It is January 1, 2005. Director of Special Projects Rakesh Parameshwar has a planned $20.5 million project, which will require the following expected cash flows between 2005 and 2009: Date Cash...

The outlook for the Australian and global economies is being driven by the COVID-19 pandemic. The necessary social distancing restrictions and other containment measures that have been in place to...

Which of the following is an accurate stmtement about the formation of partnerships? A wrimen agreement that creates a partnership is called the afticles of organiration. An expicit written apreement...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Why is the direct plan acceptable for notifying job applicants that they were not selected for a position? (Objectives 5 and 6)

You are the franchised dealer for Starlight satellite TV. Last week you ran a four-room installation special in the local newspaper that offered free installation, one-month free service, and a free...

Teamwork.Ethics.Working with three classmates with two on each side of the issue, debate the ethics of using the indirect or the direct plan for negative messages. (Objectives 3, 4, 5, and 6)