Access - Intermediate/Advanced Positive2Work Skillnet
Price: 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

    Course Location

    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
    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