Sample data - Xtreme.mdb

Seagate Crystal Reports comes with Xtreme.mdb, a sample database you can use when learning the program. Xtreme.mdb is a Microsoft Access database and all of the necessary drivers are included. You should be able to open the database directly and begin designing reports. Virtually all of the examples in this manual are based on Xtreme.mdb data.

Xtreme.mdb is a database that contains data for Xtreme Mountain Bikes, a fictitious manufacturer of mountain bikes and accessories. The database includes the following tables:

• Credit
  Information from customer credit memos, such as credit authorization IDs and amounts.
• Customer
  Data for the customers served by the company.
• Employee
  Company-oriented data for the employees of Xtreme Mountain Bikes.
• Employee Addresses
  Personal data for Xtreme Mountain Bikes employees.
• Financial
  Financial data for Xtreme Mountain Bikes.
• Orders
  Identifying and tracking data for orders.
• Orders Detail
  Line item data for orders.
• Product
  Descriptive data for Xtreme Mountain Bike products.
• Product Type
  Category data for Xtreme Mountain Bike products, including product pictures.
• Purchases
  Identifying and tracking data for product purchases.
• Supplier
  Data for suppliers who serve Xtreme Mountain Bikes.
• Xtreme Info
  Company data for the Xtreme Mountain Bike company, including the company logo.

Xtreme.mdb also includes:

• a Select query (Top Customers)
• a Parameter query (Credit_Limits)
• an Update query (Update Query).

Note:    The sample data has been designed to illustrate various reporting concepts in a training environment, not to teach database design. While there are alternative ways of designing a database, this design was selected to keep the tutorials and examples focused on reporting, not on data manipulation.