Access 97\2000 User

Course content

• Database features, common terminology, relational database design versus flat file databases, usability issues, database objects, the Access screen and icons, the database container.
• Using the table wizard and creating tables manually to store data.
• Create and change table field properties.
• Create relationships between tables.
• Index fields to speed up record retrieval.
• Create a field known as a Primary Key to avoid duplication of data.
• Create rules that validate data input.
• Navigate through the data in a table.
• Finding and replacing data, sorting columns in tables, applying and removing filters, filter criteria.
• Create forms by using the form wizard, enhancing the design of a form.
• Retrieve records from a table or from several tables by writing queries.
• Learn how to create search criteria to find only the required records.
• Use input boxes known as parameter queries to enter the search criteria when the query is run.
• See the effect of changing join properties between tables in a query.
• Create calculations in fields, summarise data by using query totals and cross tab queries.
• Perform batch updates on data by learning how to use action queries.
• Use control wizards to create a user-friendly form by placing combo boxes, list boxes, radio buttons, check boxes and group boxes onto a form.
• Create bound and unbound object frames to display graphics or documents.
• Use the command button wizard to create buttons to perform actions such as closing, opening forms, saving records, running reports.
• Display data from tables or queries by using the report wizard.
• Create automatic summary reports, use different report types.
• Create a report manually.
• Learn how to create calculations using the expression builder.
• Sort and group data and print a report.