Total Training Solutions, Bristol - Logo
 
     
Call us on
0117 9022 845

or Email Us
Course Search
Total Training Solutions Home PageHome
See what we cover in our Training CoursesTraining Courses
Training PackagesTraining Packages
Open Training CoursesOpen Courses
View Sample CoursewareCourseware
Other ServicesOther Services
Hints and TipsHints and Tips
TestimonialsTestimonials
See how little a training course can costCosts
Request further informationContact Us
See the sites we support and like!Links
Designed for you!

Please note that
this outline is only intended as a guide and that any event can be customised to suit you.

Printable Outline?

Get a PDF version of this document.

PDF icon

Microsoft Access
Training Course


Total Training Solutions
0117 9022 845
or Email Us

Microsoft Access Computer Training

Level 1 – New User (1 day)

  • what's new in your version?
  • overview of Access features and capabilities
  • functional elements of the Access screen
  • obtaining help
  • opening, closing, saving and searching for files
  • recap of database terminology and introduction to 'objects'
  • overview of good database design - choice of fields and keys
  • creating a new data table plus entering, viewing and editing data
  • using simple sorts and filters on a table
  • using the Find and Replace function to update multiple records
  • creating and using simple find queries
  • producing a basic report
  • basic printing techniques, (including printing a table's structure)

Level 2 – Regular User (1 day)

  • more database design concepts - normalisation, indexing and relational concepts)
  • changing a table’s structure, (and what might be lost)
  • using different ‘joins’ and establishing referential integrity between related tables
  • updating a data table with an update query
  • designing and using a form, (including sub-forms)
  • creating a graph from your data, (including customising)
  • creating a crosstab query, (PivotTable)
  • creating more complex reports, (including grouping and sorting)
  • designing and building a simple ‘switchboard’ user interface
  • importing and exporting data between other software packages
  • compacting, repairing and protecting your database

Level 3 – Advanced User (1 day)

Using Access reports effectively…

  • grouping reports
  • creating mailing reports, (e.g. for labels)
  • working with reports and embedded sub-reports
  • using expressions and functions
  • creating graphics in reports
  • using hyperlinks in reports

Using Access forms effectively…

  • creating ‘splash’ screens
  • working with forms and embedded sub-forms
  • using graphics in forms
  • using command button controls

Access macros…

  • introduction to creating and editing Access macros

 

Searching for a Management or Computer course? Enter the subject to see if we have a ready-made programme.
Business Communication Series
Effective Communication
Effective Meetings
Effective Minute Taking
Effective Presentations
Effective Reading
Effective Writing
E-mail Etiquette
Managing Data
Proof Reading and Editorial Skills
Report Writing
Management Skills Series
Absence Management
Chairing Meetings
Conflict Management
Customer Care
Leadership and Motivation
Managing Change
Managing Discipline
Managing Performance
Managing Stock
Performance Appraisal
Project Management (Level 1)
Project Management (Level 2)
Staff Development
Strategic Thinking
Stress Management
Microsoft Office Series
Microsoft Access (3 Levels)
Microsoft Excel (3 Levels)
Microsoft Office 2007 and 2010 Conversion
Microsoft Outlook
Microsoft PowerPoint (2 Levels)
Microsoft Word (3 Levels)
PC and Windows Appreciation
Windows 7
Microsoft Publisher
Professional Development Series
Assertiveness
Bullying and Harassment
Creativity in the Workplace
CV Writing
Interview Skills
Introduction to Management
Introduction to Supervision
Job Finder Training
Mentoring
Problem Solving
Team Building (for wimps)
Time Management
Train the Trainer
Technical and Programming Series
Adobe Dreamweaver
Adobe Illustrator
Adobe InDesign
Adobe Photoshop
Microsoft Access VBA
Microsoft Excel VBA
Microsoft FrontPage (2 Levels)
Microsoft Project (2 Levels)
Microsoft Visio
SAP Human Resources Module (per day)
SAP Project Systems Module (per day)
Statistical Process Control
Bentley MicroStation
   
 
 
   
 
Total Training Solutions SW Ltd, Create Centre, Smeaton Rd, Bristol BS1 6XN