Create reports that summarize and group data. Perform database maintenance procedures. . This course is not currently scheduled but could be made available during a scheduled Custom Training session. Normalize sample tables by identifying design problems. Establish relationships between tables.
Customize table designs, set field properties and creating indexes.
Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values. Customize form designs, create calculated fields, combo boxes, and unbound controls. Display table information by creating forms that contain subforms. Customize reports by grouping, sorting, and summarizing data, and by adding subreports. . This course is not currently scheduled but could be made available during a scheduled Custom Training session.