Week 11 Clear: Skills Track Access

This week we learned the generals of Microsoft Access. It's a great program for business use, but as far as personal use...it is a program that I haven't used very much. The videos discussed this week went over tables, queries, forms and reports. I will discuss each of them briefly below.

Tables

Tables in access are used to store the information in its most basic form. The table wizard can take information that was from an external source and sort it for you automatically by asking just a few questions about how you want the information sorted. Once everything's on the table it is there to be modified and formatted anyway you choose.

Brad Amidon

Queries

These basically are ways to get details on the information in a database. For example, if you wanted to know the seasonal sales for female shoppers in December, you could create a query to give you those detailed results back (if you had the information). 

Brad Amidon

Reports

Reports are used to create information from a source, whether it be from a table or query, and turn it into something that is printable and that can be easily understood by people who need to make decisions.

Forms

They make is simple to enter information so that it can be done quickly and easily without having to waste as much time moving from cell to cell. It also helps prevent wrongly entered items because there is not as much confusion. Microsoft Access gives you the ability to design very nice forms or just very simple ones.

Brad Amidon