MICROSOFT ACCESS 2003
It is a Relational Database program that allows us to group its data into one or more distinct tables that can be related to one another by using fields common to each related table. These relationship can that be used to perform complex searches and produce detailed reports.
Another important factor of access 2003 is its use of Indexing. An index is an ordered list of data contained in a field or a group of fields within a table. Access uses index to assist in performing the searches or lookups.
MAIN FEARTURES OF ACCESS DATABASE
· Forms
· Macros
· Modules
· Pages
· Queries
· Reports
· Tables
FORMS
You can create forms for entering the data for the database. This helps in displaying the data in structural manner and can be entered easily.
MACROS
As in other office software, macros are used for repetitive commands. These commands can be stored in macros and performed collectively using macro.
MODULES
These are user written functions using Visual Basic.
PAGES
These are the HTML documents that can be bounded directly to data in database.
QUERIES
A query is used to extract information from the table. These can be used to select, change, add or delete records.
REPORTS
A query is used to extract information from the table. This information can be printed using reports.
TABLES
A table is used to hold the raw data of the Database. Your data is entered into the tables. It is then organised into raws and columns.
No comments:
Post a Comment