Introduction to Microsoft Access

A spreadsheet is easy to maintain. You can sort filter and format data quite easily and quickly. But spreadsheets are not to deal with big amount of data. Microsoft Access is a relational database management system that helps to manage large datasets in a relational design. It helps to avoid data duplication. It’s the most widely used database by beginners in the world.

Microsoft Access is a menu-driven database program that includes a graphical user interface enabling novice users to enter, manage and report on their data. Data can be entered using a familiar spreadsheet or table interface and the program will automatically generate forms based upon the data and labels that have been entered.

Microsoft Access users can easily create and modify database queries and reports using the graphical user interface, and a menu-driven macro recorder to automate repetitive steps. Advanced users can customize Access applications using the Visual Basic for Applications "VBA" programming language common to all Microsoft Office applications. Access also includes many templates that can be easily modified by end users.

Microsoft Access is important because it dramatically decreases the amount of time required to exchange and leverage information between Microsoft Office applications. Access provides database management functionality for novice end users and is highly extensible with enterprise systems by professional developers.