ACC2: List of Categories and Examples in SOLUTION.MDB

MORE INFORMATION

   Build a Microsoft Windows interface
   -----------------------------------------------------------

    - Change toolbars in response to events
    - Close all database objects when you exit the application
    - Create a custom menu bar for a form
    - Create a main menu form
    - Create a startup form
    - Create a toolbar that has custom buttons
    - Create an About dialog box
    - Create an informational form that users can turn off
    - Get information from a user in a dialog box

   Sample forms
   ----------------------------

    - About Solutions
    - Add All To List
    - Add Category
    - Edit Products
    - Employee Sales Dialog Box
    - Enter or Edit Products
    - Find Customers
    - Limit List Contents
    - Reattach NWIND
    - Sales Totals
    - Show Sales
    - Solutions
    - Solutions Intro
    - Startup

   Work with forms and controls
   ------------------------------------------------------------------

    - Capitalize one or more letters in a field automatically
    - Change the color of a control based on the value in the control
    - Change the color of a section and control at run time
    - Clear the values in unbound text boxes and a subform
    - Control when you go to a new record
    - Create a form in which you can edit but not enter records
    - Create a form in which you can enter or edit data
    - Create a main menu form
    - Create a startup form
    - Create an About dialog box
    - Create an informational form that users can turn off
    - Get information from a user in a dialog box
    - Remove the minimize and maximize buttons from a form
    - Update a list to show current data

   Get more mileage from combo boxes, list boxes, subforms and subreports
   ----------------------------------------------------------------------

    - Add "(all)" to a list
    - Add a new record to a list
    - Find a record based on a value you select from a list
    - Limit the contents of a list based on the value selected from an
      option group
    - Limit the contents of a list based on the value selected in
      another
    - Show totals in a subreport
    - Update a list after you change its contents
    - Use a custom function in a subform's SELECT statement
    - Use criteria from the main form to set the subform's RecordSource
      property
    - Use two subforms on a form

   Query by form
   --------------------------------------------------------------------

    - Find a record based on a value you select from a list
    - Find records based on values in one or more fields
    - Show progressively more detail about a subject
    - Use a custom function in a subform's SELECT statement
    - Use criteria from the main form to set the subform's RecordSource
      property
    - Use part of a value to specify criteria
    - Use two subforms on a form

   Using queries with forms and reports
   --------------------------------------------------------------------

    - Create a crosstab query for a report
    - Create a SELECT statement for a form based on user input
    - Limit the contents of a list based on the value selected from an
      option group
    - Limit the contents of a list based on the value selected in
      another
    - Use a custom function in a subform's SELECT statement
    - Use a parameterized query in an event procedure
    - Use a totals query as the record source for a subform
    - Use criteria from the main form to set the subform's RecordSource
      property

   Sample reports
   ----------------------

    - Customer Phone List
    - Employee Sales
    - Invoice
    - Sales Averages
    - Sales Letter
    - Shipping Log

   Create advanced reports
   --------------------------------------------------------

    - Create a crosstab report with dynamic column headings
    - Create a form letter
    - Create a multiple-column report
    - Create a multiple-fact crosstab report
    - Create a report for a preprinted form

   Control what you print on reports
   ----------------------------------------------------------------

    - Draw a circle around data to accentuate it
    - Hide a section when it falls at the top of a page
    - Hide and show controls based on the value in another control
    - Hide and show sections that print on a preprinted form
    - Print "Continued" at the bottom of a preprinted form
    - Print report criteria that was entered in a dialog box
    - Print the first and last entries on a page in the page header
      Repeat a group name at the top of a column or page

   Calculate totals on reports
   -------------------------------------------------------

    - Calculate row and column totals on a crosstab report
    - Show totals in a subreport

   Use multiple databases
   ---------------------------

    - Attach tables at startup