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. These features help make Microsoft Access one of the easiest database systems to learn.Microsoft Access Tutorial What is MS Access? It also provides an easy way to create forms for data entry, and reports for emailing and printing.Īccess even provides “wizards” that guide you through some of the most common tasks. It allows you to create and maintain relational databases.Īccess provides an easy way for non-technical users to start building databases. Microsoft Access (commonly referred to as “MS Access” or just “Access”) is a relational database management system (RDBMS). Create a macro (so that a multi-step task can be done automatically – at the click of a button).Create a query (so you can “search the database”).Microsoft Access Tutorial (Part 3): Queries, Forms, & Macros Set up a relationship between three tables.Add two more tables (for the relationship).Microsoft Access Tutorial (Part 2): Design View, Field Properties, & Relationships Add four fields to the table, name/rename them, and set up their data type.

Microsoft Access Tutorial (Part 1): Databases, Tables, & Fields This Microsoft Access tutorial will show you how to use Microsoft Access to create a simple database with all the common features such as tables, forms, queries, and macros.

Microsoft access 2013 tutorial 6.3