
Queries can also be considered as an essential feature of MS Access.Any user can use the templates which are available in software MS access. Another important feature of MS Access is the template.One of the important features of MS Access is Forms.For creating a report, users need to click on the Report Wizard icon available in the toolbar. The users who work with MS Access can easily create a report from the table which is selected by them.Any user can easily import the information in the created table of MS Access from the other applications of Microsoft.There is a Tell Me Function in MS Access, which allows you to create queries, tables, reports, and forms easily.tables) which stores the data or information in the database. Any user can easily create the framework (i.e.It is also used to link directly to those data which is stored in following different databases and applications:įollowing are the different features or characteristics of Microsoft Access:.Any user can easily import data from and export data to word processing files, or spreadsheet files.Because these three databases support the (ODBC) standard. This software works with the SQL Server, DB2, and Oracle databases.Various software developers also use this software for developing the application software. It allows users for developing web applications.Any user can access the data or information quickly with the help of commands.In MS-Access, repetitive tasks can be easily performed by the help of macros.It is also used to create user-friendly front ends.Any user can easily insert the data in the database of MS Access.It is a software program which can be used in schools for making the schedules.Those users who have a basic knowledge of computers can easily create and manage the database in Access.Uses of MS Accessįollowing are the important uses of Microsoft Access: For the large databases, Microsoft provides the SQL server database engine. It is not used to create large or enterprise-level databases but mainly used to create small databases.

Users can easily analyze the large amount of data stored in it. It helps the users for managing the related data more efficiently than Microsoft Excel or other applications of spreadsheets.

It mainly provides the graphical user interface for accessing the data and the tools for software development. It actually stores the data on the basis of the relational Jet Database Engine. It is released by Microsoft in November 1992. MS-Access is application software for managing the databases. Microsoft Access Tutorial What is MS Access?
