Microsoft Access Training – Level 2


ADVANCED TABLE DESIGN

Modifying Tables

  • Formatting tables

  • Controlling table data entry

  • Moving fields

  • Adding or deleting fields

Advanced Fields Properties

  • Specifying field size

  • Displaying different text formats

  • Displaying different number or currency formats

  • Customizing date/time display

  • Entering input masks

  • Controlling a field name display with caption

  • Setting validation rules

  • Specifying default values & required fields

  • Creating lookup fields

  • Indexing fields

RELATING MULTIPLE TABLES

Types of Relationships

  • Understanding relationships

  • One-to-one relationships

  • One-to-many

  • Many-to-many relationships

Using Relationships Effectively

  • Enforcing referential integrity relationships

  • Using the cascade updates related  fields

  • Using the cascade delete related records

  • Editing relationships

EXTERNAL DATA

Importing Data

  • Importing data to a new table

  • Importing data as a linked table

The Office Clipboard

  • Using the Office clipboard

DATABASE MAINTENANCE

Backing-Up a Database File

  • Backing up & restoring a database

  • Compacting & repairing a database

  • Viewing object dependencies

ADVANCED FORMS

Creating Forms Using Automated Form Tools

  • Detail forms

  • Datasheet forms

  • Split forms

  • Multiple items forms

Modifying Forms

  • Customizing sections

  • Sorting in a form

  • Selecting multiple controls

  • Adding a calculated control

  • Working with a form in layout view

  • Working with a form in design view

  • Adding controls in layout & design views

  • Aligning & sizing controls

  • Reposition controls & labels

  • Separate controls & labels

  • Inserting a picture to a form

  • Changing form properties

Formatting Forms

  • Working with themes, fonts, & colours

  • Applying background images to forms

Subforms

  • Create a form with two tables

  • Creating & modifying subforms

  • Adding a subform control

  • Changing subform size

ADVANCED QUERIES

Modifying Queries

  • Adjusting fields

  • Sorting or hiding query fields

  • Adding calculated fields

  • Adding comparison operators

  • Displaying totals

  • Designing queries with aggregate functions

  • Refining a query using filter by selection

  • Refining a query using filter by form

  • Creating advanced filters

  • Grouping & summarizing records

Creating Specialized Queries

  • Parameter queries

  • Duplicate queries

  • Unique queries

  • Unmatched queries

Creating Summary Queries

  • Total Queries

  • Crosstab queries

Creating Action Queries

  • Make-table queries

  • Delete queries

  • Append queries

  • Update queries

ADVANCED REPORT FEATURES

Working with Report in Layout View

  • Selecting & formatting Controls

  • Reorganizing labels & controls

  • Adding controls from the ribbon

  • Grouping & sorting

  • Adding calculated controls

Working with a Report in Design View

  • Adding controls from the ribbon

  • Selecting controls

  • Aligning & sizing controls

  • Spacing controls

  • Inserting header & footer

  • Modifying properties

Adding Finishing Touches to Reports

  • Applying conditional formatting

  • Applying themes

Mailing Label

  • Creating mailing label Reports