catraining

 

Microsoft Partner

Microsoft Access 2010 Query

Audience: This course is designed for new or self-taught Microsoft Access 2010 users. The course will cover all aspects of database queries and reporting.

Course Duration: 1 days

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Access 2010 Queries training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

 

reaining course

 

After completing this course, students will be able to:
  • Understand the role of Microsoft Access objects
  • Create Table and Query Relationships
  • Create fields and tables
  • Understand Select queries
  • Create calculated fields
  • Create Select queries
  • Group queries
  • Create Action queries
  • Create calculated fields
  • Crosstab queries
  • Find unmatch and duplicate queries
  • Union Queries

  • Course Content

    print this page
    Module 1: Tables
    1. Creating tables
    2. Setting field properties
    3. Setting the primary key
    4. Defining relationships
    Module 2: Creating Relationships
    1. Creating Relationships
    2. Different Relationship types
    3. Viewing subdatasheets
    4. Setting referential integrity
    5. Cascade options
    Module 3: Select Queries
    1. Select queries explained
    2. Creating select queries
    3. Working with query views
    4. Adding and deleting fields
    5. Sorting records in the Design View
    6. Using query criteria
    7. Adding calculated fields


    Module 4 : Designing Advanced Queries
    1. Setting join types between tables and queries
    2. Setting top values in a query
    3. Creating Calculated fields
    4. Creating Summary queries
    5. Grouping queries
    6. Creating Parameter queri
    Module 5: Action Queries
    1. Update Query
    2. Make Table Query
    3. Delete Query
    4. Append Query
    5. Union Query
    Module 6: Advanced Query Techniques
    1. Working with Join properties
    2. Unmatched data
    3. Crosstab queries
    4. Union queries
    5. Find duplicates query
    6. Find unmatched query
    Module 7: Working in Report Design View
    1. Manipulating controls in a report
    2. Changing report control properties
    3. Adding calculations to a report
     
    Microsoft

Call us now for further information Tel:08001601666