Advanced Access training

Database Design

• Concepts of Normalisation
• Junction Tables
• Microsoft Access naming conventions
• Indexes
• Multiple Field Primary keys
• Data Validation
• Table Level Validation
• Field types
• Join types
• Lookup fields

Query Types

• Parameter queries
• Summary queries
• Joining tables in queries
• Cross Products
• Creating reverse outer joins
• Concatenation
• Creating and using a query to update data in a table
• Creating and using a query to delete records in a table
• Creating and using a query to save the selected information as a table
• Appending records to a table using a query

Refining Queries

• Backing up your database
• Showing duplicates
• Showing unmatched values
• Showing the highest or lowest range of values in a query
• Parameter queries – allowing query input from a data prompt
• Refining queries using Null and NOT values
• IIF Functions
• Calculating with Dates
• Querying multivalue fields

Advanced Forms

• Creating arithmetic and logical expression controls on a form
• Adding graphics to forms
• Setting sequential order of controls on a form
• Creating a subform and linking it to parent
• Modifying the subform to change records displayed
• Split forms
• Creating a Switchboard form

Access and the Internet

• How Access works with the Web
• Hyperlinks
• Exporting database object to HTML
• Importing or linking to an HTML file

Calculations in Reports

• Applying sorting and grouping to reports
• Creating arithmetic and logical expression controls in a report
• Calculating percentages in a report
• Using formulas and expressions in a report such as sum, count, average, max, min, concatenate
• Creating running summaries in a report

Macros

• Recording a simple macro
• Running a macro
• Assigning or attaching a macro to a form, report, control
• Creating an Autoexec macro

Database Management

• Analysing Performance
• Compacting and Repairing Databases
• The Database documenter
• The Database splitter