Page 90 - iPlus_Ver_2.0_class_7
P. 90
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 is created.
Info Byte
Templates are the inbuilt format of databases that focus on specific tasks. These can be
downloaded or used instantly.
i + DATA TYPES IN ACCESS 2016
The data types are used to declare the types of the fields in the database. Access 2016 provides
the following data types:
Data Type Description
Short Text It is used to store text. It can have a maximum of 255 characters.
It 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 stores up to 63,999 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 information like date of birth, date of joining,
etc. The maximum size of the field is 8 bytes.
Yes/No It is used in places where the fields can have a boolean values. It
can be either True (T) or False (F).
OLE (Object Linking It is used to embed an object created in another application,
and Embedding) such as Word, Excel, or PowerPoint.
88
iPlus (Ver. 2.0)-VII

