Database-II(Using Access)

Database : II

By Simmy Thengumtharayil

Match

STARTER: Match the following : Data Types & its use

• Text

• Number

• Date/Time

• Currency

• Boolean(Yes/No or TRUE/FALSE)

Stores text & numbers

Represents numerical values

Records Date & Time in different formats

Denotes money values

Data can have only one of the two values

• Stores text & numbers

• Represents numerical values

• Records Date & Time in different formats

• Denotes money values

• Data can have only one of the two values

Data Dictionary

Database developers use Data Dictionary to describe the data items they wish to use in a database table

Demo: MS ACCESS

Practical Activity: Posted in google classroom