1) Write a 400 word summary on when it would be more useful to use Microsoft...

1) Write a 400 word summary on when it would be more useful to use Microsoft Access Database rather than Microsoft Excel when using and storing data.

Solutions

Expert Solution

It would be more useful to use Microsoft Access Database rather than Microsoft Excel when using and storing data --

Excel is used to store complex numerical data, creating charts whereas access deal with database which include - creating, manipulating data.
Access is more better for storing data rather than microsoft excel. access helps to keep the data in organized manner., easy to search, available to multiple users.
For example -- if you want to store more complex customer list which contains billing and shipping address for each and every customer than access can be best.
Where as excel is better in analyization of data which include - calculation, exploring posible outcomes and producing high quality charts.
Access using relational database where the information are organized into multiple tabels.
Each table is flat and contain information only one type of data. for example -- if a customer database is created then the names of the customer should be stored in one table and the data of those customer about billing and shipping address will be stored in separate tables.
local and external data --
The access can be used to connect data form a variety of external data sources, so that the user can easily view, edit and query data without importing.
For example -- access provide commands to connect with exisiting data in microsoft SQL server database.
Data integrity and flexibility --
By using Access, AutoNumber number data type can be used to generate a unique identifier for each record.
this identifier can be used to relate records in one table to one or more record in another table. The access helps to ensure data integrity.
If you want to view your data in different ways then access can be better choice to store and working with your data.
Access uses SQL queries to to retrive rows and columns of data, you want and it also use expression in queries to create calculated fields.
In excel you can use what-if analysis tools to forecast outcome of worksheet. it allows different scenarion in your data like best case abd worst case scenario and compare data.
In acsess, single database can be opened by multiple users at the same time. and all users can edit different records without conflict.
Access provide different ways to collaborate with multiple users on a sharepoint site.
For example -- full database can be uploaded to windows sharepoint services document liabrary.
But excel provide one way to collaborate with multiple users on a sharepoint services site. a workbook can be uploaded in windows sharepoint site.

venereology answered 1 year ago

Next > < Previous

Related Solutions

Read, and write a 1-page reaction on a single topic 400 WORD or more WITH YOUR...

Read, and write a 1-page reaction on a single topic 400 WORD or more WITH YOUR opinion about the topic -Which you choose and whether you support or reject the idea you should use this word : I will discuss the ....... because I believe it is ......... > I also agree or desagree with the book that ...... Finding Growth and Profitability in Bookselling: Barnes & Noble and Amazon Barnes & Noble and Amazon were the bookselling industry’s leading...

Would it be useful to use more or less of β-glucanase or β-xylanase enzyme when testing...

Would it be useful to use more or less of β-glucanase or β-xylanase enzyme when testing flour viscosity? Why?

One page ( on Word, 400 words) summary of the Nobel Prize in Physiology or Medicine...

One page ( on Word, 400 words) summary of the Nobel Prize in Physiology or Medicine at 2012 Please dont send in a hand-written picture.. they are hard to read.

1. Create a Word document in the Documents library. Write a small “summary or review” of...

1. Create a Word document in the Documents library. Write a small “summary or review” of an interesting “technology article” – The topics can be anything related to recent news in technology “Example: Launching of new gadgets of Apple, or Artificial Intelligence and its uses, Amazon Web Services etc” please include workcited

1.Search the Web for a project that was completed successfully. Write a 100-200 word summary of...

1.Search the Web for a project that was completed successfully. Write a 100-200 word summary of the project, including the critical factors that made this project a success. 2.Search the Web for a project that was not completed successfully. Write a 100-200 word summary of the project, including the reasons why you think this project failed.

(IN YOUR WORD) write a 400-word long, five paragraph effect of student cheating. (supported with a...

(IN YOUR WORD) write a 400-word long, five paragraph effect of student cheating. (supported with a clear thesis statement and five well-developed paragraphs)

write minutes of a meeting using Microsoft Word Name of the organization  Date and time...

write minutes of a meeting using Microsoft Word Name of the organization  Date and time the meeting  Those present and those who could not attend  A list of the agenda items/topics  Summary of discussion for each agenda item  The actions people committed to  Summary of any decisions made

write minutes of a meeting using Microsoft Word Name of the organization  Date and time...

Instructions 1- You should use a Microsoft Office Word to accomplish this assignment. SABIC Corporation December...

Instructions 1- You should use a Microsoft Office Word to accomplish this assignment. SABIC Corporation December 01, 2017 Account Titles Cash $18,000 Supplies 3,000 Prepaid Insurance 600 Building 7,000 Account Payable 8,600 Notes Payable 1,200 Unearned Service Revenue 2,500 Common Stock 10,000 Dividends 500 Service Revenue 12,000 Salaries Expense 4,000 Rent Expense 1,200 Assumes the following adjustments data 1. Supplies on hand at December. 31 total $1000. 2. Expired insurance for the month is $100. 3. Depreciation for the month...

Minimum of 400 words and not more than 750 word Reflect on the concept of polynomial...

Minimum of 400 words and not more than 750 word Reflect on the concept of polynomial and rational functions. What concepts (only the names) did you need to accommodate these concepts in your mind? What are the simplest polynomial and rational function you can imagine? In your day to day, is there any occurring fact that can be interpreted as polynomial and rational functions? What strategy are you using to get the graph of polynomial and rational functions?

Subjects