Page 215 - Computer - 10(A&B)

Binary Data Types

Binary data type is used for storing data in binary formats. Binary data types in a database can be used for storing
photos, music files, etc. In general, files of any format can be stored using the binary data type. The different
types of binary data types available are:

Name Data Type Description
Longvarbinary Image Stores any array of bytes (images, sounds, etc..
Binary Binary (fix) Stores any array of fixed number bytes.

Varbinary Binary Stores any array of bytes.

Date/Time Data Type

Date/Time data type is used for describing date and time values for a field used in a table. Date/Time data types
in a database can be used for storing information such as date of birth, date of admission, date of product sale,
etc.

The different types of Date/Time data types available are listed here:
Name Date Type Description
Date Date Stores month, day, and year information eg. 1/1/99 to 1/1/9999
Time Time Stores hour, minute, and second information eg. Seconds since 1/1/1970

Timestamps Date/Time Stores date and time information

Name the following:
1. A data type used to store data in binary formats. ___________________
2. A data type used to store information like date of birth or date of admission. ___________________
3. A data type used to store a short string of text. ___________________

Session 3

Perform Operations on Table

In Base, you can easily insert, modify, and remove some field values stored in tables using appropriate options.

Entering Data in the Table
Once the table structure is defined, we can store data in it. You can enter data in the Datasheet View.
Step 1: Double-click the table name under Tasks section in the Database Window.

Knowledge Plus
Knowledge Plus
Press ESC Key to cancel
data entry.

97