Page 89 - iPrime_V2.2_class7
P. 89
Tech Funda
To save the changes in the database, press Ctrl + S keys or select the Save option
from the File tab.
Clickipedia
Templates are the inbuilt format of databases that focus on the specific task. These can be
downloaded or used instantly.
DATA TYPES IN ACCESS 2016
The data types are used to declare the type of the fields in the database. Access 2016 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 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 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 such as
and Embedding) Word, Excel or PowerPoint. The maximum size of the file is 2 GB.
Hyperlink It is used to store the links to web pages, websites, files, etc.
Lookup Wizard A Lookup Wizard helps you to create a field whose values are chosen
from the values in another table, query or list of values. By default,
Access sets the Lookup fields to the Number data types.
Currency It is used to store currency values.
Attachment It is used to store attached images, spreadsheet files, documents,
charts, and other types of supported files.
Database and DBMS—An Introduction 87

