Tables, the building blocks of databases
Tables store data, so they are essential for any database
Every major subject should be kept in a different table to avoid confusion
Each table contains rows called records and columns called fields.
Fields Of Data
Fields are renameable
The data type of a field limits the type of information that you can enter. for example, number or currency
A unique identifier can be used for each record in the table
Additional control over the data are provided by the field properties that are a set of charatieristics
Each Record Is Unique
No two records are the same
The primary key is an identifier that is unique to each record and it should not change frequently
It's All Relative
The ID appears in all tables as a primary key and as a foreign key
A primary key separates similar information and makes each record unique. It also brings information together.
Primary keys link tables together
This is how we avoid repeated information on more than one table
When tables relate, the primary key of one table becomes a foreign key of the other table.
Practice
Test Yourself
Queries
queries can answer your questions by assembling stored data from a database
queries retrieve, sort, filter and assemble data on command
queries can combine wanted data from multiple tables
a querie can perform calculations
a querie can also remove data
Forms
graphic elements are stored in the form's design
forms make the data be viewed easily
http://office.microsoft.com/en-us/training/get-to-know-access-RZ006118141.aspx?section=17
Tables store data, so they are essential for any database
Every major subject should be kept in a different table to avoid confusion
Each table contains rows called records and columns called fields.
Fields Of Data
Fields are renameable
The data type of a field limits the type of information that you can enter. for example, number or currency
A unique identifier can be used for each record in the table
Additional control over the data are provided by the field properties that are a set of charatieristics
Each Record Is Unique
No two records are the same
The primary key is an identifier that is unique to each record and it should not change frequently
It's All Relative
The ID appears in all tables as a primary key and as a foreign key
A primary key separates similar information and makes each record unique. It also brings information together.
Primary keys link tables together
This is how we avoid repeated information on more than one table
When tables relate, the primary key of one table becomes a foreign key of the other table.
Practice
Test Yourself
queries can answer your questions by assembling stored data from a database
queries retrieve, sort, filter and assemble data on command
queries can combine wanted data from multiple tables
a querie can perform calculations
a querie can also remove data
Forms
graphic elements are stored in the form's design
forms make the data be viewed easily
http://office.microsoft.com/en-us/training/get-to-know-access-RZ006118141.aspx?section=17
No comments:
Post a Comment