Incorporate ADO.NET access to at least three Microsoft Access data tables.
These tables should include Customers, Products (the kinds of products offered, cost, sales price, and quantity on hand), and Sales information (a combination of customer and product with a date and other pertinent information).
Use at least three user input forms that allow the user to add, edit, and delete records in the database.
The sales screen should allow you to select a customer and a product from a dropdown list box.
One screen should allow the user to see a list of all products sold to a specific customer, sorted by date.
The customer that the data is displayed for should be selectable from a list box. Consider this to be a report screen.
Include Structured Error Handling in appropriate places in the program.
Create a nice, intuitive user interface with a full menu structure.
Add a form that includes the RichTextBox control and several predefined template letters. This part of the program would be used to write letters to your customers when there is a specific issue you would like to address with them, so use your imagination here.
Be sure to document the programming, designs, the preliminary specifications, and system requirements. This documentation should be in the form of an MS Word document and additional comments in the source code.
Ideas for incorporating three access data tables are included.