Microsoft Access Training – Level 2



access

1. ADVANCED TABLE DESIGN


  • Modifying Tables +


    1. Formatting tables
    2. Controlling table data entry
    3. Moving fields
    4. Adding or deleting fields


  • Advanced Fields Properties +


    1. Specifying field size
    2. Displaying different text formats
    3. Displaying different number or currency formats
    4. Customizing date/time display
    5. Entering input masks
    6. Controlling a field name display with caption
    7. Setting validation rules
    8. Specifying default values & required fields
    9. Creating lookup fields
    10. Indexing fields



2. RELATING MULTIPLE TABLES


  • Types of Relationships +


    1. Understanding relationships
    2. One-to-one relationships
    3. One-to-many
    4. Many-to-many relationships


  • Using Relationships Effectively +


    1. Enforcing referential integrity relationships
    2. Using the cascade updates related fields
    3. Using the cascade delete related records
    4. Editing relationships



3. EXTERNAL DATA


  • Importing Data +


    1. Importing data to a new table
    2. Importing data as a linked table


  • The Office Clipboard +


    1. Using the Office clipboard


4. DATABASE MAINTENANCE


  • Backing-Up a Database File +


    1. Backing up & restoring a database
    2. Compacting & repairing a database
    3. Viewing object dependencies



5. ADVANCED FORMS


  • Creating Forms Using Automated Form Tools +


    1. Detail forms
    2. Datasheet forms
    3. Split forms
    4. Multiple items forms


  • Modifying Forms +


    1. Customizing sections
    2. Sorting in a form
    3. Selecting multiple controls
    4. Adding a calculated control
    5. Working with a form in layout view
    6. Working with a form in design view
    7. Adding controls in layout & design views
    8. Aligning & sizing controls
    9. Reposition controls & labels
    10. Separate controls & labels
    11. Inserting a picture to a form
    12. Changing form properties


  • Formatting Forms +


    1. Working with themes, fonts, & colours
    2. Applying background images to forms


  • Subforms +


    1. Create a form with two tables
    2. Creating & modifying subforms
    3. Adding a subform control
    4. Changing subform size


6. ADVANCED QUERIES


  • Modifying Queries +


    1. Adjusting fields
    2. Sorting or hiding query fields
    3. Adding calculated fields
    4. Adding comparison operators
    5. Displaying totals
    6. Designing queries with aggregate functions
    7. Refining a query using filter by selection
    8. Refining a query using filter by form
    9. Creating advanced filters
    10. Grouping & summarizing records


  • Creating Specialized Queries +


    1. Parameter queries
    2. Duplicate queries
    3. Unique queries
    4. Unmatched queries


  • Creating Summary Queries +


    1. Total Queries
    2. Crosstab queries


  • Creating Action Queries +


    1. Make-table queries
    2. Delete queries
    3. Append queries
    4. Update queries



7. ADVANCED REPORT FEATURES


  • Working with Report in Layout View +


    1. Selecting & formatting Controls
    2. Reorganizing labels & controls
    3. Adding controls from the ribbon
    4. Grouping & sorting
    5. Adding calculated controls


  • Working with a Report in Design View +


    1. Adding controls from the ribbon
    2. Selecting controls
    3. Aligning & sizing controls
    4. Spacing controls
    5. Inserting header & footer
    6. Modifying properties


  • Adding Finishing Touches to Reports +


    1. Applying conditional formatting
    2. Applying themes


  • Mailing Label +


    1. Mailing Label


Register Now