Course Content

Table Design

• Learn table design tools within database applications
• Acquire the skills to use field and column features to apply and modify data types and to create and edit lookups, validation rules, input masks, default values and set mandatory data fields
• Demonstrate your skills in using relationships and joins to collect data from different tables and place them into a single form, report or query

Query Design

The syllabus covers a wide range of valuable advanced query design options that allow you to:

• Extract clear, accurate information from databases by using powerful crosstab and wildcard queries to convert large quantities of information into useful formats
• Create and use queries to update data in a table, delete records in a table, save selected information as a table or append records to a table
• Use query formulas to group information and/or use functions in a query
• Use functions available to refine queries into a meaningful, relevant management information

Form Design

• Use the control functions to create bound and unbound controls
• Create and edit a combo box, list box, check box and option groups
• Create arithmetic and logical expression controls and set sequential order controls on a form and create and modify sub-forms

Report Design

• Use calculation functions to create arithmetic, logical or calculation controls in a report
• Calculate percentages in a report
• Create running summaries and use formulae or expressions for calculation purposes in a report
• Use the presentation features of the application to modify report design

Macros

• Record and run simple macros and assign a macro to a form, report or control. Import, export and link data
• Use the powerful data management tools of the database application to import and export text, spreadsheets, csv, database or Paradox files into a database or to link external data to a database

For information on future Advanced Access courses, check our schedule or call your local office now!