Skip to content

Notes on science, software and the craft of support

Martin EvansNotes and resources

Databases

Microsoft Access for small databases

Microsoft Access combines a relational engine with a graphical interface, so teams can build small databases, forms and reports without a server.

Microsoft Access is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is part of the Microsoft Office suite, included in the Professional and higher editions or sold separately. It is used to store, manage, retrieve and manipulate data.

Access is used to create and manage a variety of databases, including relational databases, web based databases, data warehouses and client server databases. Access includes a query language called Structured Query Language, which is used to interact with the underlying data sources.

For users and developers

Access is a popular choice among end users because of its simple interface. It provides a wide range of features that allow users to manage data quickly, including the ability to create relationships between tables, write queries, generate forms and reports and set up security features. Access is also popular among developers because of its development tools.

It offers object oriented tools such as Visual Basic for Applications, which can be used to create applications. Developers can also use Access to create custom forms, reports and queries.

Analysis and value

Access is a popular choice for data analysis. It offers features that allow users to analyse data, including pivot tables, charts and graphing. It also offers statistical analysis tools such as linear regression and logistic regression. Access is popular among businesses because of its cost effectiveness and scalability. It can be used to create a variety of databases, and it is relatively inexpensive compared with other database systems. It can also be scaled up to meet the needs of larger businesses. Overall, Access is a strong choice for data management, development and analysis.