Introduction to MS-Access

 

MS-Access is a Relational Database Management System (RDBMS) that is used to store and manipulate large amount of information. The extension name of Ms-Access file is .mdb.

 

An Access Database consists of 7 different Database objects.

1. Tables : Store database data in Rows (records) and columns (fields). Every row represents a Record. Each piece of information in a record is called a Field.

Ex: A table can contain personal information about all the students in a college. Every row containing information about a student represents a record. The records in the student table can include fields such as Admission number, Student name, Address, Phone number etc.

 

2. Queries : used to retrieve information from a database based on specific conditions.

Ex: A Query can be used to extract details about students studying in a particular class.

 

3. Forms : used as interfaces for users to enter, view and modify data in a Table.

 

4. Reports : used to present data from tables or Queries in a format of our choice. i.e the printable form of the table or query or form. We cannot make changes to the data in a report. We can format the data in a report.

 

5. Pages : display shortcuts to data access pages in the database. A data access page displays data stored in a database over the internet.

 

6. Macros : used to automate frequently performed tasks.

Ex: we can create a macro to print a report automatically.

7. Modules : used to perform advanced database operations, such as validating data against complex conditions.

 

 

References

http://office.microsoft.com/en-in/access-help/introduction-to-tables-HA102749616.aspx

http://office.microsoft.com/en-in/access-help/introduction-to-access-programming-HA010341717.aspx

http://www.functionx.com/access/Lesson01.htm

http://www.gcflearnfree.org/access2010/1

http://www.cs.rochester.edu/~pawlicki/ECOMM/tem/rb/IIIA.htm

http://databases.about.com/od/access/a/Microsoft-Access-2013-Fundamentals.htm

http://www.opengatesw.net/ms-access-tutorials/What-Is-Microsoft-Access-Used-For.htm

http://blogs.office.com/2012/07/20/introducing-access-2013/

http://www.lowestoft.ac.uk/employers/courses-for-business/information-technology/introduction-to-microsoft-access.aspx

http://office.tizag.com/accessTutorial/accessdatabase.php

https://www.udemy.com/introduction-to-microsoft-access-2013/

https://archive.org/details/ms_access

http://www.learningtree.com/courses/970/microsoft-access-introduction/

 

Registration


A password will be e-mailed to you.

Feedback Form

Name (required)

Email (required)

Feedback