Page 84 - iPro_trackGPT_V5_Class7
P. 84
Creating a Database Using Templates
To create a database by using templates, follow the given steps:
3 Select any template
2 Click on the New option. from the available list
1 Click on the File tab.
A new database with a selected template will be created.
Boost Bits
Templates are pre-designed database structures tailored for specific tasks. They can be used
immediately or downloaded for convenience, providing a ready-made layout that simplifies
database creation and management.
DATA TYPES IN ACCESS 2021
The data types are used to declare the types of the fields in the database. Access 2021 provides
the following data types:
Data Type Description
Short Text It is a text data type that can store up to 255 characters but
cannot be used for numeric calculations.
Long Text It is used to store a large amount of text or a combination of text
and numbers. It can store up to approximately one gigabyte of
text but only displays the first 64,000 characters.
Number It is used to enter numerical values and perform numerical
calculations. The maximum size of the Number field is 16 bytes.
AutoNumber It stores a sequential number automatically for every record
added to a table. The maximum size of the field is 4 bytes.
Date/Time It is used to store date and time information, like date of birth or
date of joining. The maximum size of the field is 8 bytes.
82 TrackGPT iPRO (V5.0)-VII

