Access 2003 User

Course content

• Access database features and objects, the Access screen, the database window, common terminology, comparison of relational and flat file databases.
• Using the Table Wizard, creating tables manually to store data, creating and changing table field properties, creating relationships between tables, indexing fields to speed up record retrieval, setting a primary key field.
• Creating rules and input masks to validate data input, navigating through the data in a table, finding and replacing data, sorting columns in tables, applying and removing filters, filter criteria, saving filters as queries.
• Retrieving records from a table or from several tables by designing queries, adding search criteria to restrict the records that are retrieved, using parameter queries to allow the user to input query criteria.
• Changing the joins between tables in a query to control the selection of records retrieved, creating calculated fields in queries, summarising data using query totals and crosstab queries, using action queries to enable repetitive updates or deletions in tables.
• Using name autocorrect to track and manage changes to database object names.
• Creating forms using the Form Wizard and the autoform options, manually editing forms to format the appearance of data for editing or viewing and using Control Wizards to add combo boxes to forms.
• Producing printed reports using the Report Wizard, creating reports grouped or sorted on one or more fields, producing summary information in a report and using the expression builder to generate calculations on reports.