Floor 4 - Computer Room
Santa Rosa de Lima English Secondary School
聖羅撒英文中學
Colégio de Santa Rosa de Lima - Secção Inglesa
Outline
Outline
What is Microsoft Access
1
Introduce to the interface of Microsoft Access
2
Practice exercises of Microsoft Access
3
What is Microsoft Access?
What is Microsoft Access
Database Management System
What is Microsoft Access
What is DBMS
Table Structure
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Table Structure
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Row
Row
Row
Row
Row
Row
Row
Table Structure
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Column
Column
Column
Column
Table Structure in Excel
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Header
Table Structure in Excel
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Data
Header
Table Structure in Database
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Field
Field
Field
Field
Record / Entry
Record / Entry
Record / Entry
Record / Entry
Record / Entry
Record / Entry
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Data Types in Database
Different fields store different types of data
No. | Student name | Class | Class number |
---|---|---|---|
1 | Amy | F1C | 1 |
2 | Mary | F1C | 19 |
3 | Elsa | F2C | 20 |
4 | Alice | F2F | 31 |
5 | Angela | F2F | 13 |
6 | Angel | F3H | 18 |
ECA student list table
Integer
Short Text
Short Text
Integer
Data Types in Database
Microsoft Access Interface
Microsoft Access - Ex01
Create a table in Microsoft Access
1
Create a table and name it ClassNumber_Name
2
Design the table structure according to stored data types