The Scenario
You are hired to write a program for a company that sells a variety of computer-related products, including hardware and software. As sales are made, they are automatically posted to a central database where they are organized in a table that contains date, category (hardware or software), and amount fields for each sale. This table is shown in Figure 25.1. The database name is ProductSales and the table name is DailySales.
Figure 25.1. The data table that serves as the data source.
The firm's sales manager wants to be able to view recent sales figures, as both numbers and a chart, and needs to be sure that the data is always up-to-date. ...
Get Office® XP Development with VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
