Microsoft Access is a Database Management System software of Microsoft Office, which help us to store data, manage data and processed the stored data in a computer database.
MS Access files extension is .mdb for older versions. For New versions its extension is .accdb.
General View of MS-Access:
Database is a collection of tables. Data base is used for collecting and organizing data and information. Databases can store information about persons, products, student details or anything else.
A computerized database is a collection of objects. One database can contain multiple tables. For example, a Payroll system that uses 4 tables is not 4 databases, but one database that contains 4 tables.
Work done in MS Accesss:
• Add new data to a database, such as a new employee details in Payroll system
• Edit existing data in the database, such as changing the salary of an employee.
• Delete information, perhaps if an employee left the organization.
• Organize and view the data in different ways
• Share the data with others via reports, e-mail messages, an intranet , or the Internet
Parts of Access Database:
The parts of an Access Database are as::
The tables are the main element of MS Access storage container of the data entered into the database. A database table is look like a spreadsheet, in that data is stored in rows and columns. Were Rows referred as a record and columns referred as Fields.
Relationships are the links between the tables. These links used to join the tables. For this there is a field in each and every table, which is linked to each Other, and has the same values.
Queries are the means of manipulating the data to display in a form or a report. Queries can sort, calculate, group, filter, join tables, update data, delete data, etc. Queries are the real workhorses in a database, and can perform many different functions. Their most common function is to retrieve specific data from the tables.