Copyright: Copyright (c) 1997 Corel Corporation
Citation: Copyright (c) 1997 Corel Corporation


About the Household Items database

This database stores information about household items to build a detailed inventory of the contents of your home. You can track purchase and warranty information for all of your possessions.

Table Structure

Corel Paradox stores data in tables. The Household Items database uses one table, HOUSEINV.DB, with fields to hold the following information:

•	Description

•	Manufacturer

•	Model number

•	Serial number

•	Purchase price

•	Appraisal price

•	Warranty period

•	Purchase place

•	Purchase date

Using the Household Items database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Wine List database

This database stores detailed information about different wines to help you keep track of your personal wine collection.

Table Structure

Corel Paradox stores data in tables. The Wine List database uses one table, WINELIST.DB, with fields to hold the following information:

•	Wine name

•	Vineyard

•	Vintage

•	Type

•	Color

•	Origin

•	Quantity

•	Unit price

•	Sweet or dry

Using the Wine List database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Employee Records database

This database stores detailed information about your employees.

Table Structure

Corel Paradox stores data in tables. The Employee Records database uses one table, EMPLOYEE.DB, with fields to hold the following information:

•	Name

•	Address

•	Phone number

•	Title

•	Department

•	Emergency contact

•	Manager

•	Salary

•	Position start date

•	Review details

•	Previous employment details

•	Education

•	References

Using the Employee Records database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. The information in the Employee Records report is grouped by department. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Video Collection database

The Video Collection database can help you organize and store information about your personal video collection.

Table Structure

Corel Paradox stores data in tables. The Video Collection database uses one table, VIDEO.DB, with fields to hold the following information:

•	Title

•	Category

•	Manufacturer

•	Year released

•	Length

•	Director

Using the Video Collection database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Office Supply database

The Office Supply database can help you keep track of equipment and supplies and the people responsible for these items.

Table Structure

Corel Paradox stores data in tables. The Office Supplies database uses a data model to establish a relationship between two tables. These tables are related by the key HolderId, which is the number that identifies each item holder and their corresponding supply items. The Supply table (SUPPLY.DB) contains details about each item, including the holder number. With the Holder number you will be able to find information about the person responsible for that item, stored in the Holder table (HOLDER.DB). This "HolderId" serves as a lookup field.

Using the Office Supply database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Friends & Family database

The Friends and Family database stores information about your friends and family. You can keep track of addresses, phone numbers, birthdays, and other important information.

Table Structure

Corel Paradox stores data in tables. The Friends & Family database uses one table, FRIENDS.DB, with fields to hold the following information:

•	Name

•	Address

•	Phone number

•	Birthday

Using the Friends & Family database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Music Collection database

The Music Collection database can help you organize and store information about your music collection such as group or artist name, album title, and release year.

Table Structure

Corel Paradox stores data in tables. The Music Collection database uses a data model to establish a relationship between two tables. These tables are related by the key AlbumsRecId, which is the number that identifies each album in the database. The Albums table (ALBUM.DB) contains details about each album, including the id number key. With the id number you will be able to find information about the specific tracks on that album, stored in the Tracks table (TRACKS.DB).

Using the Music Collection database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database sorted by album category. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Customer database

This database can serve has a Customer tracking system, which can store customer information.

Table Structure

Corel Paradox stores data in tables. The Customer database uses one table, CUSTOMER.DB, with fields to hold the following information:

•	Name

•	Address

•	Phone number

Using the Customer database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Attendance Tracking database

The attendance database stores information about employee leave requests such as employee id, department, leave type, and date of leave.

Table Structure

Corel Paradox stores data in tables. The Attendance Tracking database uses one table, ATTEND.DB, with fields to hold the following information:

•	Employee name

•	Request type

•	Dates of leave

•	Days absent

Using the Attendance Tracking database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the leave requests in the database, sorted by department. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.


About the Event Agenda database

The Event Agenda database stores data on the event name, type, starting date, and the person to contact for the special event.

Table Structure

Corel Paradox stores data in tables. The Event Agenda database uses one table, EVENT.DB, with fields to hold the following information:

•	Event name

•	Event type

•	Location

•	Contact information

•	Attendance

•	Notes

Using the Friends & Family database

When you selected this project, Corel Paradox created a form and a report in the directory that you specified. Corel Paradox forms and reports allow you to view, enter, and print the data from a table.

The form and report associated with this project are initially launched in Design mode so that you can customize their properties. The PerfectExpert project assistant can help you work with the form and report.

When you are satisfied with the appearance of the form, you can run it to view and enter your data in the database. Click the View/Edit Data button on the project assistant panel to switch to View mode or Edit mode.

When you are satisfied with the appearance of the report, you can use it to view and print the information in your database sorted in date order. Click the Preview button on the project assistant panel to view the report or click Print from the Finish button to print the report.

You can click the Home icon at the top of the PerfectExpert panel at any time to return to the main panel for this project.