Posts Tagged 'Database'

11 Best Database Management Systems (2024) [FREE]

1. Introduction In today's digital age, data is the lifeblood of businesses and organizations around the globe. The ability to efficiently manage and process this data sets successful enterprises apart from the rest. This is where Database Management Systems (DBMS) come in. 1.1 Importance of Database Management System A Database Management System functions as an interface between users and databases, ensuring that data can be easily stored, retrieved and manipulated. It organizes data in...

Read more »

How to Get the User Name of the Person Currently Using the Database via VBA

Need to know who in your business added a particular record? Or who updated it last? It’s a pretty common requirement, but unfortunately not one that Microsoft Access has built in functionality for. Simply adding a "last updated by" field to your table can (in many cases) be enough to meet most needs, but just how do you know who updated the record if Access can’t tell you? A little VBA code is all you need, as this article will show you. No need to create your own “login” form to capture user...

Read more »

5 Basic Facts about MDF and LDF files in SQL Server

This sections aims to explain in brief the functions of MDF and LDF files in an SQL server database. Other than that, the post also explains basic differences between the two. MDF and LDF Files in SQL Server Database All the companies need a system to store/retrieve information. The information can be anything from customer data, to market research, inventory of supplies, accounts information, etc. But, where do companies store that data and how do they retrieve it? Well, they use databases...

Read more »