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 338 days ago|8/25/2013 8:05:35 PM
0 Answers/Comments
Ask a question
Not a good answer? Get an answer now. (Free)
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
16,960,326 questions answered
Popular Conversations
What is the equation of the line described below written in ...
Weegy: The line passing through point (4, -1) and perpendicular to the line whose equation is 2x - y - 7 = 0 in slope ...
7/28/2014 12:38:02 PM| 7 Answers
10. In general terms, the heart of any representative democracy is A. ...
Weegy: 10. In general terms, the heart of any representative democracy is suffrage.
7/28/2014 7:29:37 PM| 6 Answers
beliefs of buddhism
Weegy: Read more: Buddhism: Basic Beliefs and Practices | Infoplease.com ]
7/28/2014 4:39:59 AM| 5 Answers
Which of the following is the solution set of 18 - 3n + 2 = n + 20 - ...
Weegy: n > 0.2, n User: Which of the following equations could be used to solve the given equation? 9x + 26 + 7x - 17 ...
7/28/2014 9:25:21 AM| 4 Answers
Fill in the blank with the appropriate number. 2/5* ____ = 1
Weegy: A blank is a type of cartridge for a firearm that contains gunpowder but no bullet or shot. When fired, the ...
7/29/2014 5:56:58 PM| 4 Answers
Find the product. (-7p)^3
Weegy: -21p User: Find the product. (n^3)^2 · (n^5)^4 Weegy: your question? User: Find the ...
7/28/2014 7:09:27 AM| 3 Answers
Given: 3x + y = 1. Solve for y. y = -3x + 1 y = -3x - 1 y = 3x ...
Weegy: Given: 2x + 3y = 6, the y-intercept is (0, 2) User: Given: 5x - 6y = 0. What is the x-intercept? (0, ...
7/28/2014 11:47:06 AM| 3 Answers
What is the solution set of the following equation? -8x + x + 15 = ...
Weegy: Answer is definitely c. B = (R - Ax)/x User: The slope of a line is -1/3. Find the slope of a line that is ...
7/28/2014 1:05:49 PM| 3 Answers
Exerts control over all parts of the body (Points : 4) Nervous ...
Weegy: 1. Peripheral nervous system registers information and controls movements outside the central nervous system. ...
7/28/2014 3:41:02 PM| 3 Answers
features of a simple network and the network infrastructure for alarg ...
Weegy: The simple network consists of two or more connected computers and the basic network components include ...
7/29/2014 5:02:00 AM| 3 Answers
A line has a slope of 1/2 and a run = 50. What is the rise?
Weegy: Slope = rise/ run Rise = slope x run = 1/2x50 = 25 User: Find the next term of the given sequence. 1.31, 2.54, ...
7/29/2014 8:35:14 AM| 3 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
Points 2386 [Total 21386]| Ratings 1| Comments 2376| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
Points 2191 [Total 17320]| Ratings 0| Comments 2191| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
Points 2042 [Total 14597]| Ratings 1| Comments 2032| Invitations 0|Offline
S
L
1
Points 1653 [Total 3836]| Ratings 2| Comments 1633| Invitations 0|Offline
S
L
1
1
1
1
L
1
Points 1411 [Total 7588]| Ratings 2| Comments 1391| Invitations 0|Offline
S
1
L
Points 1145 [Total 3281]| Ratings 7| Comments 1075| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 986 [Total 10594]| Ratings 0| Comments 986| Invitations 0|Offline
S
1
L
Points 853 [Total 4529]| Ratings 2| Comments 833| Invitations 0|Offline
S
P
C
L
P
L
1
Points 802 [Total 5856]| Ratings 4| Comments 762| Invitations 0|Offline
S
Points 162 [Total 166]| Ratings 0| Comments 152| Invitations 1|Offline
Home | Contact | Archive | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.