Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: 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
A: 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.
25,789,965 questions answered
Popular Conversations
Aristotle was a student of Plato's. True False
Weegy: Aristotle was a student of Plato's. TRUE.
7/9/2017 6:34:10 PM| 1 Answers
Most collisions are caused by __________ A. drivers falling asleep at ...
Weegy: Most collisions are caused by driver's attitude.
7/9/2017 4:51:29 PM| 1 Answers
k2 + 3k + 2 = (k2 + k) + 2 ( __________ )
7/8/2017 8:58:45 AM| 1 Answers
Parasite can be Protozoa,fungi, or multicellular organisms. TRUE or ...
Weegy: Parasites can be protozoa, fungi, or multicellular organisms. TRUE.
7/7/2017 6:41:18 PM| 1 Answers
Development disabilities cannot be cured. TRUE or FALSE.
Weegy: Developmental disabilities cannot be cured. TRUE.
7/7/2017 6:00:57 PM| 1 Answers
. Classification of living things takes into consideration all of ...
Weegy: Classification of living things takes into consideration all of the following except: presence of cell ...
7/5/2017 12:07:33 PM| 1 Answers
What type of disorder is myasthenia gravis? A. Inflammatory ...
Weegy: Myasthenia gravis is a type of immune disorder. User: What surgical procedure involves breaking an ankylosed ...
7/5/2017 9:35:49 AM| 1 Answers
The lungs are the primary organ of the: digestive system respiratory ...
Weegy: The lungs are the primary organ of the: respiratory system. User: Endorphins are manufactured by the brain to ...
7/5/2017 6:54:42 AM| 1 Answers
During puberty you need more food and _____ to grow. oxygen carbon ...
Weegy: During puberty you need more food and oxygen to grow. User: Each cell in your body contains chromosomes.
7/5/2017 6:43:00 AM| 1 Answers
The condition of equilibrium that results in the displacement of the ...
Weegy: The condition of equilibrium that results in the displacement of the mantle by the continental and oceanic crust ...
7/10/2017 1:50:08 PM| 0 Answers
What is another name for the Circum-Pacific Belt? A. Pacific Ring ...
Weegy: Pacific Ring of Fire is another name for Circum-Pacific Belt
7/10/2017 1:47:35 PM| 0 Answers
Weegy Stuff
S
Points 29 [Total 30] Ratings 0 Comments 9 Invitations 2 Offline
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 4 [Total 4] Ratings 0 Comments 4 Invitations 0 Offline
S
P
P
L
P
P
P
Points 4 [Total 1734] Ratings 0 Comments 4 Invitations 0 Offline
S
Points 3 [Total 3] Ratings 0 Comments 3 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
S
Points 2 [Total 2] Ratings 0 Comments 2 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.