catraining

 

Microsoft Partner

 

Microsoft Access 2007 Modules

Audience: This course is aimed at those who wish to tailor their Access 2007 course to specific requirements, for ideas of course content below we have listed example topics. We are happy to arrange for a trainer to contact you to help tailor your course.

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office suite.

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

Course Location: This Microsoft Access 2007 modules 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:
  • • Work with Access in line with the agreed course aims

 


  • Possible Course Content – Select 4 Modules (or discuss with our team your individual requirements)

    print this page
    Working with Tables
    • Opening an existing Microsoft Access table
    • Adding, editing and deleting records
    • Finding specific records
    • Sorting and filtering the data
    • Hiding and unhiding columns
    • Printing the table
    • Freezing columns
    Planning a Microsoft Access Relational Database
    • Creating tables
    • Setting field properties
    • Setting the primary key
    • Defining relationships
    • Setting referential integrity
    • Creating lookups
    • Creating calculated fields
    Working with Forms
    • Creating a form with the Form Wizard
    • Editing a form
    • Opening a form
    • Adding, editing and deleting records
    • Find and replace records
    • Filtering data in a form
    Introduction to Select Queries
    • Select queries explained
    • Creating select queries
    • Working with query views
    • Adding and deleting fields
    • Sorting records in the Design View
    • Using query criteria
    • Adding calculated fields
    Designing Advanced Queries
    • Setting join types between tables and queries
    • Setting top values in a query
    • Creating Calculated fields
    • Creating Summary queries
    • Grouping queries
    • Creating Parameter queries
    Action Queries
    • Update Query
    • Make Table Query
    • Delete Query
    • Append Query
    • Union Query
    • Find duplicates query
    • Find unmatched query
    Working in Form Design View
    • Manipulating controls in form design view
    • Changing form and control properties
    • Adding controls to a form
    • List boxes, Check boxes and Option buttons etc.
    • Using calculations on forms
    Working In Report Design View
    • Manipulating controls in a report
    • Changing report control properties
    • Managing sorting and grouping in reports
    • Adding calculations to a report
    • Controlling pagination
    Importing and Exporting Access Data
    • Importing a spreadsheet from Excel
    • Linking data tables into an Access database
    • Export a table to Excel and text files
    • Exporting reportsMicrosoft

Call us now for further information Tel:08001601666