BIS155 Course Discussions Week 7


BIS155 Course Discussions Week 7
Discuss the differences between storing data in Access and Excel.  Why would you…

SKU: BIS 155 Database Decisions Categories: , Tags: , , ,


BIS155 Course Discussions Week 7

BIS155 Course Discussions Week 7

Database Decisions  All Students Posts – 35 Pages 

Discuss the differences between storing data in Access and Excel.  Why would you use a spreadsheet over a database?  At what point does it become more efficient to store your data in a database rather than a spreadsheet?  If you are deciding whether to use a spreadsheet or database, what questions should you consider? What can a relational database do for a person or company? Access is designed to handle data integrity … How do relational database tables help handle data integrity?

Excel and Access are two applications from the software giant, Microsoft, to deal with tabular data efficiently and conveniently. Access is a Relational Database Management Software or RDBMS that is used to create tables where data can be stored and related to each other. Each of these applications have their own purpose to serve, which they do sufficiently.

Excel is used for paperworks where you can arrange and tabulate data properly for printing or presentations. For this reason, Excel is a staple in offices where a lot of data needs to be collated and tabulated. Access is used as a system of storing data so that it can be retrieved later. It is often set-up so that employees can access it from a few locations and do queries or enter new data when needed. A part of how access works makes this possible. Access does not lock the whole database when it is accessed, it merely locks certain records to prevent the occurrence of errors in the database. Excel locks the whole spreadsheet once it is accessed. Making other people unable to edit other entries or even to add new ones. Because of this, Access can be used by a lot of people at the same time without even noticing any difference.

Excel is also a lot easier to learn since it is meant to be used by a lot of people. The learning curve or Excel  is not really that steep as most of the things you would need to learn are related to word processing. Even the more advanced controls and options do not require a lot of learning. Access is also easy to use when it has been set-up beforehand. But unlike Excel, the learning curve of Access gets pretty steep quickly. To implement the more advanced capabilities of Access, the person who would set-up the database and interfaces would need to know programming.

Knowledge of Visual Basic and SQL is of great help when creating new Access databases.

1.Excel is a spreadsheet application while Access is an RDBMS
2.Excel is usually used for paperwork while Access is used in storing information that can be

accessed by a lot of people
3.Access locks data at the record level while Excel locks the entire spreadsheet
4.Most users of excel do not really know any programming while you need that to take full

advantage of Access