When you make a database, you of course have it chock full of data.
Contractor name, Contractor pay rate, Number of hours the contractor worked, etc.
Invoice ID, Item price, Number of items purchased, etc.
Now, let's say you want to figure out something based that data. The pay rate times the hours to equal the total amount paid, for instance.
To do that, you make a query.
1. Create a database. (File > New > Database, select the first radio button in that window and continue.)
2. Create or add a table. (Choose the Wizard or design view.)
3. Open the database file. (File > Open and find the .odb file.)
4. Click the Queries icon at the far left.
5. Click Create Query in Design View.
7. The table will appear in its own separate window. Add all the fields that you want in the query -- you might all of them. To add a field, double-click it. It will appear in the design area at the bottom.
8. To add the calculation, click in the top cell of the first blank column. Type fieldname*fieldname
For instance, to multiply the contents of Payrate by Hoursonjob, type
In the cell below that, the cell to the right of the Alias label, type the name you want to use to refer to this calculated field, like TotalPaid.
Then click the Run Query icon to run the query.
For any of the columns, including the result, you can apply currency formatting. Right-click on the column heading and choose Column Format.
Select the format you want and click OK.
The formatting is applied.
Now you can:
- Just view the data
- Run a report based on the query
- Create a mail merge of some sort based on the query