What is it for?
Access is a database tool for gathering
and understanding all information such as phone numbers,
inventory, guest lists or whatever that we're tracking—and
providing a convenient way to enter, navigate, and report out the
data.
As for this week, we learnt that Microsoft Access 2010 stores all database tables, queries, forms, reports, macros, and modules in the Access Jet database as a single file. However, for the purpose of this subject, En. Razak said that we limit ourselves on creating database on tables, queries, forms and reports only.
As to what I gathered on what have been tolf in class, the use of each database are as follows:
- Tables: to add / edit / delete raw data
- Form: to create a more user-friendly for entering data
- Query: a request for data results to supply data for a form or report
- Report: To view on what have been requested using Query.
As for this week, my groupmates and I have completed our individual part of creating Table that consists of data on the lists of book and non-book materials that we have completed in Assignment 1.
En Razak asked us to develop 2 types of tables to be used in later stage. The extract of tables created are as follows:
 |
| Table 1: Material Data |
 |
| Table 2: Publication table |
Video tutorial on how to create Table using Microsoft Access 2010 can be obtained here:
0 comments:
Post a Comment