Microsoft Office training -  Access Developers

Access Training

Access Developers (3 days)

£795 + VAT for most venues (£895 + VAT for London)

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking  (or consider an onsite Access training course).

Course Contents

Designing a database

  • Training topicIdentifying the tables
  • Training topicWhat are relationships?
  • Training topicSetting a primary key
  • Training topicUsing multivalue fields

Creating tables

  • Training topicDefining fields
  • Training topicThe types of field
  • Training topicEntering data

Different field types

  • Training topicCreating attachments
  • Training topicRich text format fields
  • Training topicDate fields (using calendars)
  • Training topicCalculated fields

Importing data

  • Training topicImporting from Excel
  • Training topicMaking tables from Excel

Covered if time allows If time

Table rules

  • Training topicRecord-level validation
  • Training topicBasic triggers

Drawing relationships

  • Training topicCreating relationships
  • Training topicReferential integrity

Creating queries

  • Training topicThe query design grid
  • Training topicSorting
  • Training topicSetting criteria
  • Training topicCombining criteria

Advanced queries

  • Training topicGrouping and totalling
  • Training topicCreating expressions
  • Training topicParameter queries

Joins

  • Training topicCreating ad hoc joins
  • Training topicTypes of join

Covered if time allows If time

Crosstab queries

  • Training topicColumns, rows and values
  • Training topicOverriding column headings

Covered if time allows If time

Action queries

  • Training topicMaking tables
  • Training topicUpdating records
  • Training topicAppending records
  • Training topicDeleting records

Creating forms

  • Training topicLayout and design view
  • Training topicUsing the form wizard
  • Training topicSplit forms
  • Training topicCreating controls

Covered if time allows If time

Advanced controls

  • Training topicMultitabs
  • Training topicWebbrowser controls
  • Training topicNavigation bars

Creating reports

  • Training topicUsing the report wizard
  • Training topicThe group, sort and total pane
  • Training topicReport design

Creating subforms

  • Training topicMultiple item forms
  • Training topicCreating subforms
  • Training topicTidying up subforms

Basic VBA coding

  • Training topicCreating modules
  • Training topicUsing Project Explorer
  • Training topicWriting comments
  • Training topicIndenting code

Uses of VBA

  • Training topicForm validation
  • Training topicCriteria forms
  • Training topicA simple menu system

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Our team is expanding and I only trust Wise Owl to deliver the training I enjoyed almost 18 months ago, as we have become really proficient with T-SQL and building reports in BIDS. We are building really interactive dashboards using SSRS, PowerPivot and SharePoint now."

Jigna Patel (Cafcass)

"Very interesting - loved it!"

Airi Christoffersen (Ishida Europe Ltd)

"I gotta say that from someone who wasn’t looking forward to the course, I’m not a techy person so I was worried I would struggle, I actually really enjoyed the course. Not only is the trainer a very nice guy who is very good at putting people at ease but he is also a great trainer and really helped me to understand the course content. He had everything prepared really well, no waiting about for him to give us exercises to do. I don’t think he had a question he couldn’t answer for us and he structured the day well too and everything fitted in nicely with the schedule he gave us at the beginning of the course. He was also keen to show us your website and the helpful videos that we can look to after the course if we needed to refresh our memories. I also liked the little freebies he provided like the USB stick (really helpful for taking all you did on the course home) and the exercise and course books. Then sweets/chocolate was another good touch. I’ve always tried to steer myself away from getting too technical as I don’t have that kind of mind and hence I find it all a little boring and I knew of SQL before the course and never found it interesting but the trainer was able to keep me fully engaged and interested. If we ever need a course that you guys cover, I will definitely be pushing my boss to go with you guys again. "

Martin Mitchell (Penguin Random House Group Ltd)

"Perfect content for a beginner like myself. The trainer was very methodical and interesting and made the course informative and very enjoyable. I now feel that I am no longer a complete novice! Thank you."

Dave McQuade (Brammer)

"Excellent tuition, very enjoyable course."

Adam Buckley (Lex)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Related Courses

Access Querying

Basic

1 day course

Access VBA macros RECOMMENDED

Advanced

2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access database training resources

Access exercises

Access exercises

To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.

View Access VBA or Access 2010 exercises

Access skills assessment

Access skills assessment

You may find it useful to do one of our Access skills assessment tests, to help you know what you don't know (to misquote Donald Rumsfeld …).

View Access skills skills assessment tests

Access blogs

Access blogs

In addtion to other Access training resources, you may find some of our Access blogs useful.

View Access or VBA macros blogs

This page has 0 threads Add post