Page 41 - TP_Prime_V2.2_Class8
P. 41
Data Type Description
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 the 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 value. It can
be either True (T) or False (F). WORKING WITH ACCESS 2016
OLE (Object Linking It is used to embed an object created in another application such
and Embedding) as 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 39
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.
Types of Views in Access
There are two types of views in Access: Datasheet view and Design view. We can switch
between these two views by clicking on the arrow of the View command in the Views group
under the Home tab. We can also use the Design View and Datasheet View buttons located
on the right-hand side of the Status bar to switch between two views.
Datasheet View
Datasheet view is the default view of the table. It shows all the fields and the records as
entered by the user. In this view, you can edit records of the table.
Datasheet View

