For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

Test-driven software must often drop, create and populate database tables with records before it runs a suite of unit tests. For this reason, the ability to have JPA frameworks -- such as EclipseLink ...

I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...

It is rare to find an implemented database devoid of reference tables. Reference tables provide valid values for drop-down lists and in a slightly obtuse way, also allow for expression of a domain or ...

How to create a database and add a collection with MongoDB GUI Compass Your email has been sent Now that you have the MongoDB Compass GUI installed, you might be ...

You have created a new database in the first part of this tutorial, and you've chosen to create a table in Design View. Below is a portion of what you should have on your screen. It's a view we call ...

We have users who cook up little Excel sheets for simple things such as logging a bit of data or events (e.g. products received from suppliers that are non-conformant). It usually starts as 1 person's ...

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...

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 ...

Last month, we continued our look at the iCalendar standard, which makes it possible for programs to exchange calendar and appointment information. As we saw, an iCalendar file contains one or more ...