Microsoft Access is the one Microsoft Office application that I’ve had very little experience using. Basically it’s a lot like Microsoft Excel in the sense that is used to store large amounts of data. In other words, it is a database. Access is more convenient than Excel when it comes to organizing a colossal amount of data into related groups called fields.
All data within Access is stored in tables. Each column within a table contains a specific field of unique information. The way a user interacts with the data in Access is via a query. While using a query, a user can perform four basic operations on the data: create, retrieve, update, or delete. This really is where Access has the advantage over other databases, like Excel, because here you can sort data in relational fields for easier data updating or data retrieval. After data is entered into the database it can be manipulated into reports for use in presentations.
No comments:
Post a Comment