Form 6 - Computer
2025-2026
Floor 4 - Computer Room
Mr. Peter, Mr Lucas
Introduction to Ms Access
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