Support

Microsoft Access Course | Level 2

4 sessions available starting from $900.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

Course Code: DT10102
Course Duration: 2 days

Skills Gained

* Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
* Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
* Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
* Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
* Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create...

see more

Course Code: DT10102
Course Duration: 2 days

Skills Gained

* Normalize tables, analyze tables, and view object dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
* Create lookup fields and multi-valued fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
* Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
* Add unbound controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
* Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create labels.
* Create and modify charts in forms and reports.
* Create and modify PivotTables, create PivotCharts, and create PivotTable forms.

Course Modules

Relational databases

* Database normalization
* Table relationships
* Referential integrity

Related tables

* Creating lookup fields
* Modifying lookup fields
* Subdatasheets

Complex queries

* Joining tables in queries
* Using calculated fields
* Summarizing and grouping values

Advanced form design

* Adding unbound controls
* Adding graphics
* Adding calculated values
* Adding combo boxes
* Advanced form types

Reports and printing

* Customized headers and footers
* Calculated values
* Printing
* Labels

Charts

* Charts in forms
* Charts in reports

PivotTables and PivotCharts

* PivotTables
* Modifying PivotTables
* PivotCharts
* PivotTable forms

Prerequisites

Access 2010: Basic or equivalent experience.

see less

Choose from 4 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $900.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Programming with Microsoft Visual Basic .NET
Programming with Microsoft Visual Basic .NET
6 sessions available starting from $3,400.00
Microsoft Commerce Server 2002 Training Course | Building Solutions
Microsoft Commerce Server 2002 Training Course | Building Solutions
2 sessions available starting from $2,720.00
Microsoft Access 2003 Course | Level 2
Microsoft Access 2003 Course | Level 2
1 session available for $800.00

see all listings »


Found In