Question and answer
imagine you are an employee of party plates a company that manufactures decorative paper plates and napkins for special events. Your team has been assigned a new project. The president of your
company has tasked you with improving the efficiency of the current information systems used in the sales department, because the current systems are somewhat antiquated. Your organization is currently using Microsoft Excel to track all personnel data, but would like to migrate to a relational database like Microsoft Access. You ahve also been tasked with identifying potential collaborative software that may improve internal communications and help streamline some of the work processes for the sales department. Prepare a 350-700 word proposal addressing the potential implementation of new information systems in your organization. Explain the usefulness of converting data currently held in Microsoft Excel spreadsheets into a relational database using Microsoft Access. Describe the benefits of using Microsoft Access in the work environment. Include suggestions for the future use of collaborative software and how it can help the sales department improve communications and streamline work processes
Yes, it is possible to make Excel as a database and be able to be a databas But of course, there are advantages in using Microsoft Excel as database. [ What are the advantages? First and foremost, if you have the Microsoft Office in your PC, you don't need anything else to be installed in your computer. You are good to go and can start with your programming straight away. Second, if you are a
beginner, you can easily learn the Excel VBA Programming because you are half familiar with the programming platform that you are going to use, which is Excel. Third, you can start with small Excel database application and as the need grows especially on records that are getting huge, you can still use the same Excel application and upgrade your database platform from Excel to other high-end databases like Access, SQL Server, Oracle, MySQL, etc. Fourth, Excel is capable of connecting directly to OLAP databases and can be integrated in Pivot Tables. Fifth, You don't need to create a your own financial modules. Excel is rich in financial functions like Fixed Assets Depreciation, Amortization, etc. Sixth, Excel is portable. You can send it to someone through email. Excel database application also has its disadvantages. But these disadvantages are sometimes have some workaround that can be done to fix or sometimes there are little effect that you can just live with them. Here are the disadvantages: When you develop your application into one file it can be huge and will make your program execution very slow. But as I told you, there are workarounds. Design your program to have compact codes to lessen the bloating of the file. Another way is to separate each application function into more than one files. ] ] ]
Expert answered|mark.emilio@ymail.com|Points 11|
Question
Asked 8/25/2013 8:05:35 PM
0 Answers/Comments
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
Questions asked by the same visitor
how have smart phones incorporated wireless technologies and changed how business is done
Weegy: Advancements in mobile technology, including new devices and methods of communication, have changed the business world and continue to shape its future. [ The integration of mobile devices such as laptops, tablet computers, PDAs and smartphones, along with their various applications and software, make it easier than ever for workers to collaborate and develop products and services. ........... ] (More)
Question
Expert Answered
Asked 8/31/2013 12:40:48 PM
0 Answers/Comments
18,445,982 questions answered
Popular Conversations
Simplify 12A + 2 + A - 1. 14A - 1 13A - 1 13A + 1 User: ...
Weegy: 12(A - B) = 12A - 12B User: Simplify 10x - 3x + (-5x). -2x 2x 18x -18x Weegy: c.18x User: Simplify ...
11/25/2014 3:05:18 PM| 6 Answers
True or false carbohydrates are made up of carton, hydrogen, and ...
Weegy: The answer is True. Here is the source link: User: The two main types of fiber are?
11/25/2014 7:45:43 PM| 5 Answers
x + y = k x - y = k
Weegy: 8 1/3 - 1 5/6 = 25/3 - 11/6; = 50/6 - 11/6; = 39/6; = 13/2; = 6 1/2 User: 5x + y = 6 5x + 3y = -4 Weegy: ...
11/25/2014 9:09:05 AM| 4 Answers
Determine the solution set of (2x - 5)2 = 11.
Weegy: 2x - 3 = 9 2x = 9 + 3 2x = 12 x = 12/2 x = 6 User: Determine the solution set of (3x + 1)2 - 100 = ...
11/25/2014 11:37:07 AM| 4 Answers
20,000 pounds equals how many English tons?
11/25/2014 3:30:36 AM| 3 Answers
Simplify 20 + (2 + r). r + 22 22r 20r
Weegy: r + 22 User: Simplify (5a)(5b). 10ab 25ab 55ab Weegy: (5a)(5b) = 25ab User: Simplify 7.95 - 3.86 + ...
11/25/2014 8:53:09 AM| 3 Answers
Which personal pronoun best completes the sentence? How is it used? ...
Weegy: My father made my sister and ME blueberry pancakes for breakfast. The correct pronoun is: me; indirect object. ...
11/25/2014 9:42:28 AM| 3 Answers
t Object]User: y + 3 = 2x y + 4 = 3x If you use the comparison ...
Weegy: 31/8 and 25/8 User: What is the result of adding the system of equations? 2x + y = 4 3x - y = 6 x = 2 x = ...
11/25/2014 10:32:36 AM| 3 Answers
Which of the following is the correct factored form of the given ...
Weegy: The correct factored form of the given equation x^2 + 3x - 4 = 0 is (x - 1)(x + 4) = 0. User: olve n3 + 2n2 ...
11/25/2014 11:30:00 AM| 3 Answers
Which of the following is the correct factored form of the given ...
Weegy: (x - 3)^2 = 0 written in general form is: x^2 - 6x + 9 = 0 Expand (x - 3)^2 = x^2 - 3x - 3x + 9 = x^2 - 6x + ...
11/25/2014 11:33:47 AM| 3 Answers
The graph of which of the following will be perpendicular to the ...
Weegy: The graph of which of the following will be perpendicular to the graph of y = 2x ? 4? D. 2x + 4y = 1 User: Two ...
11/25/2014 1:29:11 PM| 3 Answers
Weegy Stuff
S
L
1
L
P
C
1
P
C
1
L
P
C
1
Points 2608 [Total 14318]| Ratings 10| Comments 2508| Invitations 0|Offline
S
L
Points 1432 [Total 3718]| Ratings 0| Comments 1432| Invitations 0|Offline
S
L
Points 777 [Total 1298]| Ratings 6| Comments 717| Invitations 0|Offline
S
1
L
1
L
P
P
L
P
Points 761 [Total 14135]| Ratings 0| Comments 761| Invitations 0|Offline
S
Points 687 [Total 719]| Ratings 1| Comments 677| Invitations 0|Offline
S
1
L
L
Points 267 [Total 6661]| Ratings 0| Comments 267| Invitations 0|Offline
S
L
Points 159 [Total 1455]| Ratings 3| Comments 129| Invitations 0|Offline
S
Points 67 [Total 67]| Ratings 1| Comments 57| Invitations 0|Offline
S
Points 50 [Total 50]| Ratings 0| Comments 0| Invitations 5|Offline
S
Points 46 [Total 46]| Ratings 3| Comments 6| Invitations 1|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.