Describe the benefits of using microsoft access

Assignment Help Database Management System
Reference no: EM13754335

Scenario: 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 have 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- to 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.

Reference no: EM13754335

Questions Cloud

Describe the results of the bolshevik ascension : Describe the results of the Bolshevik ascension to power as the Kerensky government fell in November of 1917.
Analyze a neuropsychological disorder : Analyze a neuropsychological disorder that is different and select a neuropsychological disorder from the list.
Discussion-supply chain : Understanding supply chain and how the consumer can play a critical role in the supply chain is an important part of developing and implementing a strategy. There are many products and services today where the target customer is part of the supply..
What are budgeted revenues for the fourth quarter : Bugga Corp expects to sell 3,000 units in October, and expects sales to increase 20% each month thereafter. Sales price is expected to stay constant at $8 per unit. What are budgeted revenues for the fourth quarter?
Describe the benefits of using microsoft access : 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
Affiliated group has gross income from operations : Jasper Co. which is not a member of an affiliated group has gross income from operations of $425,000, and deductible expenses of $390,500. Dividends of $275,000 were received from more than 20% owned U.S. corporations.
Type of tax structure in the united states : You are preparing a background report to help you prepare for the seminar. The report will include information about programs supported by tax revenue, the type of tax structure in the United States, primary and secondary sources for tax research,..
Discuss the value of separating duties in the organization : The value of separating duties in the organization. The value of using roles to segregate the data and system access needs of individuals in the organization
Traditional costing activity based costing : Traditional Costing Activity Based Costing-Why a difference in overhead cost between the two systems?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Find the resulting tuples of the given query

What time does it take to find the resulting tuples of the given query: "List the names of all students who are taking a class in the Turing Auditorium".

  Discuss advantages and disadvantages of xml in application

XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss the advantages and disadvantages of XML in this application.

  What would be the total overhead cost

What would be the total overhead cost per delivery according to the activity based costing system? In other words, what would be the overall activity rate for the deliveries activity cost pool?

  1 start with checksalary trigger explain below on triggers

1 start with checksalary trigger explain below on triggers. show that that trigger creates muttating table error. in

  Convert the erd

Using the descriptions of the attributes given in the, convert the ERD shown in Figure P6.2 into a dependency diagram that is in 3NF.

  Implement a program to query and update the text database

Implement a program to query and update the text database for a library using a client/server model allowing multiple clients safe access to the database, and using a producer-consumer model to control the inventory of each item.

  Method to change column name

Hhow can you change column name or what is a different way to write statement in SQL so it displays the amount column as money.

  Build the prototype as a distributed system

You should document a UML design for the proposed system. This should include a description of: architecture, requirements and functionality, detailed system design.

  Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all candidate keys for the relation R

  Design of database systems

Write a trigger that will increment the new field numHours in the Employee table automatically whenever a record is inserted in the Works table - Create a view that shows the eids and managerids in Sales department.

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Develop a use case for each of the major processes

Develop a Use Case for each of the major processes and create the context diagram for the system described

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd