Microsoft Access : Intermediate
(ITSC1004)

This instructor-led training course builds on the skills and concepts taught in Access 2010: Basic. Course will include: how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Instructor: Vishal Reddy
 

{slide=Table of Contents|green|closed} 

  • Unit 1: Relational databases
    • Topic A: Database normalization
    • Topic B: Table relationships
    • Topic C: Referential integrity
  • Unit 2: Related tables
    • Topic A: Creating lookup fields
    • Topic B: Modifying lookup fields
    • Topic C: Subdatasheets
  • Unit 3: Complex queries
    • Topic A: Joining tables in queries
    • Topic B: Using calculated fields
    • Topic C: Summarizing and grouping values
  • Unit 4: Advanced form design
    • Topic A: Adding unbound controls
    • Topic B: Graphics
    • Topic C: Adding calculated values
    • Topic D: Adding combo boxes
    • Topic E: Advanced form types
  • Unit 5: Reports and printing
    • Topic A: Customized headers and footers
    • Topic B: Calculated values
    • Topic C: Printing
    • Topic D: Labels
  • Unit 6: Charts
    • Topic A: Charts in forms
    • Topic B: Charts in reports
  • Unit 7: PivotTables and PivotCharts
    • Topic A: PivotTables
    • Topic B: Modifying PivotTables
    • Topic C: PivotCharts
    • Topic D: PivotTable forms

 

{/slides}

 

XA04133Q Apr 22 - 24 6:00 pm - 9:00 pm
Tue,Thu  $149.00
($154.00 out-of-state)
ATC
Registered: 0 8.0 Hours


Midland College is accredited by the Commission on Colleges of the Southern Association of Colleges and Schools to award certificates
and associate and baccalaureate degrees. Contact the Commission on Colleges at 1866 Southern Lane, Decatur, Georgia 30033-4097
or call 404-679-4501 for questions about the status of Midland College.

Midland College is an Equal Opportunity Employer/Educator

mc logo  secure90x72