Access 2010 – Advanced

$49.99

In Access 2010  Advanced, presenter Cindy Rybaczyk will explain advanced topics such as validation rules, group macros, database repair, and more!

This is training for Microsoft Access 2010 for Windows.

Length: 2 hrs 25 min

This title is available in the
Total Training All-Access library.

Subscribe Now

SKU: N/A Categories: , , Tags: , , , ,

Description

In Access 2010 Advanced, take your working knowledge of tables, queries, reports and forms to the expert level. What’s more, learn how to use PivotTables, create relationships, charts, switchboards and macros. You’ll even learn to export and import data, use smart tags, link tables from other Access databases, and much more!

Sample clip

  1. Relationships & Referential Integrity
    Understanding relationships
    Creating a one-to-many relationship pt. 1
    Creating a one-to-many relationship pt. 2
    Creating a many-to-many relationship
    Enforcing Referential Integrity
    Editing & deleting relationships
    Modifying the relationship window
    Printing table relationships
  2. Tables & Fields
    Indexing a field
    Indexing multiple fields
    Using validation rules & text in a table
    Creating a lookup field
    Creating a value list
    Using the attachment data type
  3. Queries
    Creating a Union query
    Creating a Crosstab query
    Concatenating two or more fields
    Using the Between And operator
    Using wild card characters
    Using the IIF function
  4. Forms
    Creating a subform
    Displaying a subform calculation
    Opening a subform in a new window
    Setting control defaults
    Using a tab control
    Managing attachments in a form
    Adding a totals row to Datasheet View
  5. Reports
    Creating a subreport
    Creating a numbered list
    Creating a multi-column report
    Creating a report template
    Coloring alternate rows in a table, form or report
  6. Charts, PivotTables, and PivotCharts
    Creating a chart in a form or report pt. 1
    Creating a chart in a form or report pt. 2
    Editing an existing chart pt. 1
    Editing an existing chart pt. 2
    Creating a PivotTable
    Working in a PivotTable pt. 1
    Working in a PivotTable pt. 2
    Working in a PivotTable pt. 3
    Creating a PivotChart from a PivotTable
    Creating a PivotChart
    Working in a PivotChart pt. 1
    Working in a PivotChart pt. 2
    Working in a PivotChart pt. 3
  7. Switchboards
    Understanding a switchboard
    Creating a switchboard using the Switchboard Manager pt. 1
    Creating a switchboard using the Switchboard Manager pt. 2
    Creating a switchboard from scratch
  8. Macros
    Creating a simple macro
    Creating a macro using the Macro Builder
    Assigning a macro to a form/report control event
    Adding a condition to a macro
    Creating a Group macro
    Creating an AutoExec macro
    Using Single Step mode to test a macro
  9. Exporting Data
    Exporting an object to another Access database
    Exporting to a spreadsheet
    Exporting to a text file
    Exporting to Microsoft® Word
    Using a table or query as a mail merge data source
  10. Importing Data
    Importing from another Access database
    Importing spreadsheet data
    Importing text files pt. 1
    Importing text files pt. 2
    Linking tables from other Access databases
  11. Database Tools & Maintenance
    Compacting and repairing a database
    Backing up a database
    Using the Database Documenter
    Converting an Access database
    Checking object dependencies
  12. Smart Tags, Startup, & Help
    Using smart tags
    Setting Startup options
    Using help