Blog Detail
Recent Posts
Database Corruption & Repair
A Microsoft Access database may consist of data and indexes as well as the database objects: tables, queries, reports, forms, macros and modules. The best way to protect against loss of data and databases due to corruption is to backup your databases...
Microsoft Access vs Microsoft SQL Server
Microsoft Access is a relational database management system (RDBMS) that is packaged with the Microsoft suite of office products to run under the Microsoft Windows operating system. Microsoft Access is a Visual Basic (VB) based application that allow...
Generate HTML Help Files for MS Access
Certainly, documenting any process is part of the job, not only in Information Technology but in many other fields as well. In creating software, one must of course provide some sort of user guide or help file, not to mention technical documentation...
Introduction to Data Modeling
Data modeling is the practice of representing data structures and their relationships through conceptual modeling. The benefits of implementing this process during the design phase of your database project include improved data integrity, a more effi...
Splitting a Microsoft Access Database
One of the important decisions that must be made before a Microsoft Access Database can be distributed is the form that the database will assume after the deployment. In this article, it addresses the pros and cons of splitting the database, and impl...
Normalize the Data
Once you’ve decided upon and drafted the tables and fields you believe that you will require in your database, the next stage is to enter some sample data in the tables and look for any potential problems with maintaining the data. Identifying pos...
