Skip to main content

Posts

Showing posts from August, 2020

LEARN MS-ACCESS : 2ND STEP - BY - STEP

  MS ACCESS Tutorial: Learn with Example What is Microsoft Access? MICROSOFT ACCESS  is a Database Management System offered by Microsoft. It uses the Microsoft Jet Database Engine and comes as a part of the Microsoft Office suite of application. Microsoft Access offers the functionality of a database and the programming capabilities to create easy to navigate screens (forms). It helps you analyze large amounts of information, and manage data efficiently. What You Will Learn:   [ show ] Important Terms and Basic Objects Database File: It is a file which stores the entire database. The database file is saved to your hard drive or other storage devices. Datatypes: Datatypes are the properties of each field. Every field has one datatype like text, number, date, etc. Table A Table is an object which stores data in Row & Column format to store data. A Table is usually related to other tables in the database file. Each column must have Unique name We can also define Primary Key in a tabl