MICROSOFT ACCESS - INTRODUCTION
Microsoft Access is an example of DBMS (Database Management System) and DBMS is a software package that is used to create and manage a large amount of data items.
Microsoft Access mostly stores its data in a tabular format hence it is also known as RDBMS (Relational Database Management System). To create any types of tables we must first create a database.
Run Command To Open The Microsoft Access
Run Command To Open The Microsoft Access
MsAccess
 |
| Microsoft Access Screen |
FEATURES OF MICROSOFT ACCESS
1. Microsoft Access is an example of RDBMS and therefore its store data in tabular format as well as a table consisted of the number of Rows and Columns.
2. Every table contains a special key (Known as a primary key) that used to uniquely identify a record.
3. Two tables can be connected by using of referential integrity.
4. By default Microsoft access file extension is .accdb
5. Every table must contain a primary key.
Database: A database is a collection of tables.
Table: A table is a collection of related records.
Record: A record is a collection of some related fields.
Table: A table is a collection of related records.
Record: A record is a collection of some related fields.
Note: Primary key is a unique value that never contains duplicate values, therefore, it is used to access a record uniquely, there are two characteristics of a primary key.
I. A primary key cannot contain duplicate values.
II. Primary key can’t contain blank space (Null value).
PRIMARY KEY EXAMPLES
Roll number, Employee number, Bank account number
Steps To Create A Database & Table
1. Open the Microsoft Access.
2. Insert database name and save location.
3. Click on "Create" button.
4. Save the database.
5. Right click on "Table1" and select "Design View"
6. Save table with desire name
7. Add require filed with an appropriate data type.
8. Insert Data and save the table.
MICROSOFT ACCESS DATA TYPES
Text: This data type is used to store both types of values (alphabetical and numerical) such name, resident address, etc.
Memo: This data type is used to store long text information such (Product description, Employee details, etc.)
Number: This data type is used to insert only numeric values, such (pin code and contact number)
Date/Time: This Data type is used to insert date and time.
Currency: This data is used to insert currency values.
AutoNumber: This data type is used to insert automatic numerical numbers such (Emp_no, Roll_no, etc.) and by default, it starts at 1 and after it will auto increment.
Yes/No: This data type only for boolean values such (yes-no, true-false)
OLE Object: This data type is used to insert other program files such Microsoft Paint.
Hyperlink: Hyperlinks, such as e-mail addresses.
Attachment: This data type is used to link to another program files such as digital photos. Multiple files can be attached per record. This data type is not available in earlier versions of Access.
0 Comments