Microsoft Access Course | Level 2
4 sessions available starting from $900.00
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...
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.
Tags
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
When
Please contact us for upcoming dates and/or more information about this class.
Where
- 5/159-175 Church St
Parramatta, NSW 2150
When
Please contact us for upcoming dates and/or more information about this class.
Where
- 5/159-175 Church St
Parramatta, NSW 2150
When
Please contact us for upcoming dates and/or more information about this class.
Where
- 5/159-175 Church St
Parramatta, NSW 2150
-
- Listed by
-
MIS Global Technologies
- (02) 9635 7114
Reviews
-
-
Good experience!
I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
– John Weber
My Other Listings
-
-
Forefront Security Technical Training Course (BootCamp)
3 sessions available starting from $1,800.00 -
-
Complete ASP.NET 3.5
2 sessions available starting from $3,600.00 -
-
Microsoft SQL Server 2008 Analysis Services Training Course - Implementing and Maintaining
5 sessions available starting from $2,040.00