Access 2010 - Advanced

Course

Online

£ 46.79 VAT inc.

*Indicative price

Original amount in USD:

$ 59

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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!

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • Database
  • Access
  • Macros
  • Mail Merge
  • Exporting Data
  • Startup
  • Object dependencies
  • PivotTables
  • PivotCharts
  • Referential Integrity
  • Database Tools
  • Databases Access
  • Switchboards

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

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
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
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
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
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
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
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
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
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
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
Database Tools & Maintenance
  • Compacting and repairing a database
  • Backing up a database
  • Using the Database Documenter
  • Converting an Access database
  • Checking object dependencies
Smart Tags, Startup, & Help
  • Using smart tags
  • Setting Startup options
  • Using help

Additional information

LENGTH

2 hrs 25 min

Access 2010 - Advanced

£ 46.79 VAT inc.

*Indicative price

Original amount in USD:

$ 59