Latest Blog Posts for Database Tips

• Database Corruption & Repair
  on Nov 15, 2009 in mysql access mssql database oracle
  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
  on Nov 11, 2009 in mysql access mssql database oracle
  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
  on Nov 10, 2009 in mysql access mssql database oracle
  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
  on Nov 10, 2009 in mysql access mssql database oracle
  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
  on Nov 8, 2009 in mysql access mssql database oracle
  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
  on Nov 4, 2009 in mysql access mssql database oracle
  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...
• Access Database Repair and Recovery Software
  on Nov 3, 2009 in mysql access mssql database oracle
  AccessFIX is a Microsoft Access database repair and recovery software that restores damaged MS Access files, rebuilding the table data. This utility works with MS Access 95, 97, 2000, XP, and 2003: When a Microsoft Access database shows an error w...
• Microsoft Access Database Security
  on Nov 1, 2009 in mysql mssql database oracle
  To control what an individual user or group of users can do with database objects, you can secure a Microsoft Access database. As you create database objects, you might consider who will use them and what types of activities the users should be allow...
• Defining an Attribute Makeup
  on Oct 27, 2009 in mysql mssql database oracle
  Once you have decided on your initial attributes (database fields), you may need to look into how to break this attribute down, a process more commonly known as decomposing attributes. Decomposing an attribute takes the attribute from its original fo...
• What Makes a Good Primary Key?
  on Oct 27, 2009 in mysql mssql database oracle
  Good primary keys are essential to good database design. They let you query and modify each table row individually without changing other rows in the same table. When you evaluate candidates for a table's primary key, follow these rules: * The pri...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment