: Write a paragraph to reflect on what you have learned about Microsoft access in terms...

: Write a paragraph to reflect on what you have learned about Microsoft access in terms of the difference between relational databases versus spreadsheets. Discuss ways in which a relational database could be useful for your work (if you have a job) or for your personal or professional projects (if you are a full-time student)

Expert Solution

A spreadsheet is not a database. These are 2 separate tools that complement each other. A database and a spreadsheet work in tandem with each other. The data contained in a database is viewed in and orderly, formatted manner by exporting it to a spreadsheet. A spreadsheet allows many calculations on it and thus helps the user make more sense out of the data by using charts, graphs, calculations, etc.

In a relational database (RDB), data is collected from various sources and stored into what is known as tables. These tables will have some kind of a "relationship" amongst them. A well defined relationship between tables can be maintained to enforce the data integrity. An RDB can store all kinds of data and from various data sources in very high volume.

Student Expense RDB

For eg. You can have tables containing the list of all the various types of expenses (Rent, Food, Medical, Entertainment, Utilities,etc) incurred along with a unique expense code for each type. Second table containing the entries for all daily expense amounts along with the respective expense code. "Expense Code" is the relationship between the tables. The data from this example can be exported to make a spreadsheet indicating which category of expense has the highest amounts, and a monthly graph can be built using this information to see the trending months with highest expenses. Furthermore even a trend of daily expenses can be made to indicate what part of the month sees the highest expenses.

Employee @ NESTLEX using an RDB

Consider an employee using SAP (an ERP system) in his company say, Nestlex . The company manufactures and sells food products. There are relational databases that store all the data starting from Customer Interaction, Purchasing, Sales Orders, Warehousing, Manufacturing,Finance and Waste Disposal. From the customer facing sales executive, the factory manager, the accountant, the warehouse manager, the HR and the CFO all make use of the SAP based ERP system to meet their work requirements.

venereology answered 18 hours ago

Write a paragraph to reflect on what you have learned in this assignment in terms of...

Write a paragraph to reflect on what you have learned in this assignment in terms of the difference between relational databases versus spreadsheets. Discuss ways in which a relational database could be useful for your work (if you have a job) or for your personal or professional projects (if you are a full-time student)

Reflect on what you have learned from this part of the course. Write two paragraphs about...

Reflect on what you have learned from this part of the course. Write two paragraphs about how the knowledge you have gained will help you to "assess, evaluate, and apply emerging information technology to business." Shape your writing around the kind of job that you want to obtain upon graduation or your current job.

As you read the chapters and review the videos reflect on what you have learned about...

As you read the chapters and review the videos reflect on what you have learned about government intervention to redistribute income and assist with retirement and healthcare funding.. Write a two page presentation of your own views in your own words about the sources of inequality in wealth and income and whether this inequality should be reduced and how.

Write a paragraph (4 - 6 sentences) that summarizes the information that you have learned about...

Write a paragraph (4 - 6 sentences) that summarizes the information that you have learned about Television. This summary should be in your own words, do not directly quote the source. Write a thesis statement based on the information written in your summary. Be sure to create a thesis statement that is clear, specific, and thought-provoking. Create a thesis statement that argues a controversial position. READ THIS ARTICLE: Television is one of the most significant communications inventions. Television has fundamentally changed the...

Review the chapters and videos and reflect on what you have learned about the "sustainability" problems...

Review the chapters and videos and reflect on what you have learned about the "sustainability" problems with our economy and conventional economics. Write a two-page presentation of your own views in your own words about whether you agree that such problems exist, and if they do, whether the proposed solutions are adequate, appropriate, and sufficiently detailed and capable of being put into practice.

Take a moment to reflect on what you have learned in this module about hypothesis testing...

Take a moment to reflect on what you have learned in this module about hypothesis testing in general and A/B testing in particular. - In what other scenarios or industries do you think this type of analysis would be helpful? - What precautions should you take when designing such tests? - How can you ensure that your results are representative of your target population?

Reflect on what you have learned about living arrangements for the aging population. What has changed?...

Reflect on what you have learned about living arrangements for the aging population. What has changed? What has remained the same? If you had to live in a facility for the aging, what would be your primary concern?

Reflect on what you have learned about government intervention to redistribute income and assist with retirement...

Reflect on what you have learned about government intervention to redistribute income and assist with retirement and healthcare funding. Write a two page presentation of your own views in your own words about the sources of inequality in wealth and income and whether this inequality should be reduced and how.

Reflect on what you have learned in this module by answering these questions: As a Human...

Reflect on what you have learned in this module by answering these questions: As a Human Resource Manager, what can you do to ensure that your organization is considering current trends and meeting the needs of your employees? What techniques will you leverage to ensure that employees are performing appropriate job functions? What can you do as a Human Resource Manager to overcome challenges identified during job analysis?

Reflect on what you have learned in this module by answering these questions: As a Human...

Reflect on what you have learned in this module by answering these questions: As a Human Resource Manager, what can you do to ensure that your organization is considering current trends and meeting the needs of your employees? What techniques will you leverage to ensure that employees are performing appropriate job functions? What can you do as a Human Resource Manager to overcome challenges identified during job analysis?

Question

: Write a paragraph to reflect on what you have learned about Microsoft access in terms...

Solutions

Expert Solution

Related Solutions

Write a paragraph to reflect on what you have learned in this assignment in terms of...

Reflect on what you have learned from this part of the course. Write two paragraphs about...

As you read the chapters and review the videos reflect on what you have learned about...

Write a paragraph (4 - 6 sentences) that summarizes the information that you have learned about...

Review the chapters and videos and reflect on what you have learned about the "sustainability" problems...

Take a moment to reflect on what you have learned in this module about hypothesis testing...

Reflect on what you have learned about living arrangements for the aging population. What has changed?...

Reflect on what you have learned about government intervention to redistribute income and assist with retirement...

Reflect on what you have learned in this module by answering these questions: As a Human...

Reflect on what you have learned in this module by answering these questions: As a Human...