Sunday, August 30, 2009

Database

Microsoft Access-is not a database but a system for creating and managing a database. Microsoft Access is what you call DBMS(Data Base Management System).
Things you can have in a database:
-tables
Column is called a field
Data Type: text, memo, date/time, number( e.g integer), yes/no (aka: boolean), currency, autonumber, hyperlink, OLE object (object, linking and embedding), Lookup Wizard
Primary Key:to uniquely define a relationship between a table and other tables in the database

-queries
-forms
-reports
-pages
-macros
-modules

No comments:

Post a Comment