Please enable JavaScript.
Coggle requires JavaScript to display documents.
Introduction - MS Access - Coggle Diagram
Introduction - MS Access
-
Objects
Queries
Queries let us find and work on the data resulting from one or multiple tables based on specified conditions.
Reports
If forms are for input then the reports are for output.
Reports are used to display the data stored in database tables in a professional format for printing purposes.
-
Table
They are used to store data in the form of records and fields. A table is also reffered to as relation.
-
-
-
Components of a table
-
Field Data Types
-
-
OLE object
It stores different documents of word, excel, pdf so on.
-
Yes/No
It stores only one option from this different values such as Yes/No, True/False and ON/OFF.
-
-
-
-
-
Long Text
It can store 65, 536 characters
-
-
-
-