Submitted by: Submitted by AlexisOnnenga
Views: 333
Words: 416
Pages: 2
Category: Other Topics
Date Submitted: 03/27/2012 09:23 AM
|
Databases |
Using Microsoft Access |
|
David |
10/11/2011 |
When I decided to take this course I didn’t know what to expect. After ten weeks of intense study of MS
Access I have learned how crucial a database can be to an office and company website.
Databases create a secured and organized library of data that allows an individual or company to
Store multiple pieces of information and separate them according to the company and user needs. I can
create a database for a company that would keep track of employee hours, paychecks, inventory,
shipping and receiving products, the specific amounts sold, compare sales to other sales in the same
region, and so on. The possibilities are endless. The great thing about a database is it is never redundant
when storing information.
This is because referential integrity enforces and eliminates redundancy. You can store tens of
thousands of bits of data and never repeat the same thing twice. Moreover you can extract data and
incorporate it into MS Access and create a database. For example you can import a MS excel
spreadsheet and turn it into a database or you can import another database to create new databases.
In my carrier, Litigation Support, requires you to keep track of a lawyer (s) clients case (s), accounts,
retainers, and court dates. Additionally with each client’s case (because they are all different but similar)
comes motions, proceedings, interrogatories, depositions, hearings and judgments. This is where MS
Access becomes much more useful rather than MS Excel. Knowing how to use a database and create
one would help a law firm out enormously, especially with the query option. I can find and relate a
client’s technical data.
For example I can look up a client by code and find out when their next court date is, the time, the judge
presiding, and courtroom #. If I want to get even more technical I can determine what type of case it is.
Wither it’s a Criminal,...