Sunday, August 16, 2009

Relational Database Management System - Access

Can create queries & reports from Access Database

Table contains:
Columns are knows as "fields"
Rows contain "records"

Declare the datatype for field

ID is used a lot in databases - if you know the ID, that's all that is needed to know to access a record

ID can be the Primary Key - only one field can be the Primary Key

No comments:

Post a Comment