How to create your own reports using MS Access.
 
Things you will need before you can create your own reports.
 
1.  MS Access Installed. The location of your "Contract.mdb" file.

2.  The file will be either on your hard drive on the network. 

3.  The appropriate network permissions. Contact your network support for help.
 
Part A

1. Open MS Access, Create a blank database. Select a name for your new database. Remember the name, you will use this database as your interface to Contract Management Software.
2. In MS Access select "File" from the Menu.
3. Select "Get External Data", and then select "Link Tables".
4. Browse to the location of your "Contract.mdb" file. By default the file in stored in the following location "C:\Program Files\Contract Management Software\Contract.mdb".
5. Select the "Contract.mdb" file.
6. Select the "Select All" button. Next, Select "OK". The link to the table should appear in your new database.

Part B

1. Next, import the "Contractual Query" by selecting "Get External Data", and then select "Import Data".
2. Browse to the location of your "Contract.mdb" file. By default the file in stored in the following location "C:\Program Files\Contract Management Software\Contract.mdb".
3. Select the "Contract.mdb" file.
4. Select the "Queries" Tab. 
5. Select the "Contractual Query". Next, Select "OK." The queries will now be imported to your new database.
6. You can now use the Microsoft Access Report Writer by selecting the "Reports" Tab and Selecting the "New" button.
7. Refer to your MS Access documentation for creating Queries and Reports. Below is a sample of how to use MS Access Report Wizard.

Create a report with a wizard

1. In the Database window, click the Reports tab.
2. Click New.
3. In the New Report dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.
4. Click the table or query that contains the data you want to base your report on. Note Microsoft Access uses this table or query as the default record source for the report. However, you can change the record source in the wizard and select fields from other tables and queries.
5. Click OK.
6. If you clicked Report Wizard, Chart Wizard, or Label Wizard in step 3, follow the directions in the wizard dialog boxes. If you click AutoReport: Tabular or AutoReport: Columnar, Microsoft Access automatically creates your report.
7. If the resulting report doesn't look the way you want, you can change it in Design view.