Create reports to summarize data with subtotals and totals as well as print mailing labels. Search for information and link multiple databases together using queries. Microsoft Access is a challenge to learn, but well worth the effort when you can manage your information successfully. Access 2000 will be used in class. Select queries use criteria to display a subset of records.
Join queries to make several tables one large table.
Make-table queries extract information and create new tables. Update queries update table information. Delete queries delete records. Use queries to create pull-down lists. Base a form on a select query and use push buttons to activate macros to perform tasks such as one click printing of a report based on the same select query.