Whether you use Microsoft Access to keep track of inventory or to keep a record of customers and clients, managing your tables can become cumbersome as the database grows in size and complexity.

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...

When databases became available for the personal computer in the mid-1980s, they quickly gained a mystique as the ultimate productivity applications. Despite their widespread use, in some ways they ...

How to query a LibreOffice database using the Query Design View Your email has been sent LibreOffice contains a very powerful database tool that is actually quite user friendly. Here's how to create a ...

The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...

Occasionally the database under design becomes more than a one-off project. For example, the data mart or data warehouse might act as a profit center for the organization, and as a solution sold to ...

From performance to programmability, the right database makes all the difference. Here are 13 key questions to guide your selection. Picking the “right” database can often be critical to the success ...

Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create ...