When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file. If you insert tab characters into the output data stream, you ...

Spreadsheets, which are similar to databases, can help you visualize and manage data entities and values that make up your company's customer information repository. If that information doesn't reside ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Hey you! Stop loading spreadsheets into Microsoft SharePoint. Excel may be simple to set up but you can do things differently for better results. You won’t have problems with concurrent edits and you ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...