Access - Intermediate/Advanced Positive2Work Skillnet
Price: TBA
  • Duration: TBA

Course details

Lesson 1 Relational databases
Topic A Database normalization
Topic B Table relationships
Topic C Referential integrity

Lesson 2 Related tables
Topic A Creating lookup fields
Topic B Modifying lookup fields
Topic C Subdatasheets

Lesson 3 Complex queries
Topic A Joining tables in queries
Topic B Using calculated fields
Topic C Summarizing and grouping values

Lesson 4 Advanced form design
Topic A Adding unbound controls
Topic B Adding graphics
Topic C Adding calculated values
Topic D Adding combo boxes
Topic E Advanced form types

Lesson 5 Reports and printing
Topic A Customized headers and footers
Topic B Calculated values
Topic C Printing
Topic D Labels

Lesson 6 Charts
Topic A Charts in forms
Topic B Charts in reports

Lesson 7 PivotTables and PivotCharts
Topic A PivotTables
Topic B Modifying PivotTables
Topic C PivotCharts
Topic D PivotTable forms

Updated on 08 November, 2015

About Positive2Work Skillnet

The Positive2Work Skillnet is made up of small, medium & large companies from all sectors of the Irish Economy. The member companies of Positive2Work Skillnet have come together to explore how the intervention of effective strategies, supported by training solutions and people development, can positively impact on the quality of employees working lives and the competitive environment within which network member companies operate. The aim of the project is to create a Positive2Work environment for all employees within the member companies of the Skillnet.
To date the Skillnet has delivered training that support the areas of:
  • Building Resilience / Stress Management
  • Conflict Management / Building Constructive Relations
  • Change Management / People Management
While also working directly with member companies to deliver training that both incorporates the Positive2Work objective and meets their individual needs.
Positive2Work has approved funding until the end of 2013.
Positive2Work Skillnet provides subsidised training to member companies and offers free training for job-seekers. Members can also influence what courses are provided by the network.
See all Positive2Work Skillnet courses

Database Management Related Questions

Are you from Positive2Work Skillnet ? Claim your course!
Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or