Page Title Here

asdeducation.net

Access

Advanced Access Skill Sets

Basic

Intermediate

Advanced

Queries III

Using text for a query

selecting only the top n values

creating crosstab queries

creating find duplicates queries

creating find unmatched queries

Building criteria

the like operator

the between ..And operator

the in operator

the null operator

understanding operator precedence (order of operations)

Criteria for Queries

Using numeric data in criteria

Using AND criteria

Using OR criteria

using logical criteria

setting up a calculated column

calculating discounted invoice totals

using built in functions

using math functions

using financial functions

working with the expression builder

Working with Multiple Queries

What are relational database

how to use relational design

types of relational models

the one to many model

the many to one model

enforcing referential integrity

establishing table relationships

join lines

types of join lines

adding multiple tables to a query

creating a unique values query

Advanced Queries

creating a totals query.

setting up a totals query on a field

grouping on multiple fields.

creating totals query using a calculated field.

Advanced Forms

how to create efficient data entry forms

how to use check boxes

How to use drop down boxes

how to use option buttons

using the option group wizard

using lists to present a large number of choices

verifying user entries.

Specialized Forms

creating a multiple table form

creating subforms (wizard)

creating subforms (design view)

subforms from other tables or queries

creating a switchboard form

how to create a popup box

how to create a pivot chart form

Creating Data Reports III

grouping options

sorting and grouping using an expression

inserting a text box

using text boxes as calculated controls

adding calculations to a report

how to avoid windowed records

Working with Macros

How to make a macro

Sharing Databases

Publishing a database to the internet

sending by email