Establish relationships between tables by analyzing table relationships and enforcing referential integrity. Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes. Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values. Customize form designs by creating calculated fields, combo boxes, and unbound controls. Interact with data through a browser by creating and using data access pages.
Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.