Importing data enables you to read data from an existing external file and create a SAS table from it. In this section, you import the file that was created in the previous section. Note that when you ...

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

In this flat file database, the data on each member of staff is held together with all data for each department. This is unnecessary as some information is stored more than once (eg the same phone ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

We have multiple users accessing a flat file database -- specifically an Access 97 database.<BR><BR>We've got a few problems with it:<BR>An Access 97 user and an Access 2000 user can access it at the ...