Microsoft Access
In this blog, we will be showing you the
theories on database design with a commercial
Relational Database Management System called Microsoft Access (MSA). The
program comes with the standard Microsoft Office install.
If you do not have a copy of MSA on your home
PC, you can launch it on any of the lab machines by selecting Start à All Programs à Microsoft Office à Microsoft Office Access 2007
Most
of the information provided in this lab can be accessed in greater detail under
Microsoft Access’s extensive help files. All the information provided in this
tutorial is based on MS Access 2007 unless otherwise
specified. If you have a different version installed on your machine, you
should expect to see some minor differences between what is described here and
what you observe on your screen.
What is a database?
Features of a database
Tables
A
table allows the user to store a collection of data about a specific topic,
such as Customers or Orders
Queries
Queries
allow the user to view, change, and analyze data in different ways, such as
combining data from two different tables (Customers and Orders), in order to
create a custom view (e.g. London orders placed in April). They may also be
used as the source of records for forms, reports, and data access pages.
Forms
Forms
allow users to enter, change, or update data.
Reports
Now
that you have all of your data stored in a database, you need to have a way to
view it; this is where reports come in handy.
No comments:
Post a Comment