catraining

 

Microsoft Partner

Microsoft Access 2010 Modules

Audience: The content of this course is intended to be tailored to meet your specific requirements. To provide some ideas of course content, we have listed below example topic modules, and would recommend combining the content of four of the modules. We are happy 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 from the Microsoft Office suite of training courses. Course Types: Group bookings, public courses, 1-2-1 sessions.

Course Location: This Microsoft Access 2010 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 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
  • Moving 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
  • Creating Pivot Tables
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 reports
  • Export to HTML format
  • Database tools and utilities Microsoft

Call us now for further information Tel:08001601666