Family Law

|

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,...