This application was designed using each of the product's facilities and development tools. These applications use NSTL's standard book order entry system test database, residing on SQL Server, which contains data for books and their authors, and for orders that customers have placed. The applications allow users to browse existing orders and enter new orders. The order browsing form loads 50,000 records from the orders table and allows the user to view a record at a time, along with five matching entry records which indicate the books that are associated with the order. A second form allows order entry.
Users can also run two reports.
One lists all orders for customers within a user-specified range of zip code values, listing the order number, customer names, and payment and shipment status. The other lists all orders within a range of order numbers, and for each order lists all books ordered including the title, and for each book lists all co-authors. Users can preview a report, browse it page by page, and print a specified page range. For non-database functionality, NSTL's test application includes a string parsing test. The program reads a test results file consisting of multiple records per product, one record per test per product.