Establish relationships between tables by analyzing table relationships and enforcing referential integrity. Customize table designs by setting field properties to maintain data integrity 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 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.
Automate simple tasks by creating macros to open forms and control form properties. Make forms more functional by using macros to provide user interaction and automate data entry. Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar. Create a basic worksheet by entering text, values, and formulas. Create formulas by using Excel's built-in functions.