Code: 
MSACCESS1
Duration: 
1-4 Day(s)
Price: 
£165-751

Overview

  • Building a Microsoft Access database
  • Establishing indexes and data relationships
  • Implementing Form and Query wizards
  • Automating tasks with macros
  • Creating preformatted and custom reports
  • Developing complex Access reports

Your Choice

Customize your hands-on Learning Method with your choice of PC usage: Pair Up or Sole Use. Learn More

Audience

Anyone who needs to manipulate, analyze or report on organizational data.

Skills Gained

  • Develop and support robust Access systems to query data, develop forms and design reports
  • Apply Form, Table, Report and Query wizards to quickly build database applications
  • Create and integrate macros into your applications to increase efficiency
  • Quickly modify forms and reports with selective filtering, sorting and grouping
  • Implement advanced Access reporting features

Course Specifics

Course Outline

Microsoft Access Overview

Discovering the interface
  • Quick data functions in reports
  • Categorizing with command groups
  • Changing the view to discover contextual tabs
Overview of database concepts
  • Databases and their contents
  • Flat file and relational databases
  • Conforming Access to RDBMS standards
The fundamentals of database design
  • Tables, records and fields
  • Implementing database normalization
  • Ordering schemes
  • Indexes
  • Setting compound primary keys

Building a Relational Database with Access

Defining the requirements
  • Eliciting user needs and wants
  • Consolidating a design into a system specification
  • Designing the data model
Creating an Access database system
  • Selecting the best Access design style
  • Access tables, fields, indexes
  • Assigning proper field types
  • Table relationships
  • Modifying field functionality with properties
Integrating internal and external data
  • Customizing forms with the Layout View
  • Embedding forms
  • Importing existing tables
  • Protecting data using layered validation
  • Picking controls in Layout and Design Views

Querying Relational Data

Query types and elements
  • Defining queries
  • Choosing fields in the Design View
  • Select, Action and Parameter queries
Developing queries
  • Query wizards
  • Expressions in queries
  • Refining data output with sorting and filtering
  • Creating calculated fields

Access Reports for Data Analysis

Implementing Report wizards
  • Generating quick reports
  • Enhancing your presentation with conditional formatting
  • Exploiting formulas and expressions in reports
  • Sorting out groups and totals
Modifying the standard report formats
  • Adjusting report controls
  • Changing group order and effects
  • Formulating values in expressions
  • Publishing to PDF and XPS formats

Task Automation with Macros

Designing effective macros
  • Point-and-click
  • Embedded macros
  • Macro style guidelines
  • Running a macro from events
  • Picking macro actions and arguments
Event-driven programming
  • Linking forms and reports
  • Associating macros with controls
  • Managing security through the Trust Center
  • Designing a custom Navigation Pane

Access as a Multiuser Front-End

Data separation in Access
  • Creating a non-data ACCDB
  • Strategically placing your data
  • Handling multiuser conflicts
Linking to SharePoint or SQL Server
  • The ODBC connectivity standard
  • Utilizing SharePoint and SQL Server data within Access

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Please click date to Enquire Now
Course Location Days Cost Date
Leicester1 165 £165 2017-12-22
Glasgow2 751 £751 2017-12-14
London2 751 £751 2017-12-11
Leicester1 165 £165 2017-11-28
Manchester2 751 £751 2017-11-27
London2 751 £751 2017-11-13
London1 495 £495 2017-11-06
Sheffield1 218 £218 2017-10-26
London1 218 £218 2017-10-26
Leeds1 218 £218 2017-10-26
Milton Keynes1 218 £218 2017-10-26
Leeds2 751 £751 2017-10-23
Bristol4 2000 £2000 2017-10-23
Manchester4 2000 £2000 2017-10-20
Leicester1 165 £165 2017-10-19
Belfast4 2000 £2000 2017-10-16
Liverpool1 218 £218 2017-10-12
London2 751 £751 2017-10-12
Manchester1 218 £218 2017-10-12
Birmingham2 751 £751 2017-10-11
Liverpool4 2000 £2000 2017-10-10
Reading4 2000 £2000 2017-10-09
London1 495 £495 2017-10-06
London1 495 £495 2017-10-02
Coventry1 218 £218 2017-09-28
Birmingham1 218 £218 2017-09-28
Bristol1 218 £218 2017-09-28
Leicester1 165 £165 2017-09-22
Leicester1 218 £218 2017-09-14
Slough1 218 £218 2017-09-14
London2 751 £751 2017-09-14
Reading1 218 £218 2017-09-14
Nottingham1 218 £218 2017-09-14
Leeds2 751 £751 2017-09-04
Oxford4 2000 £2000 2017-09-04
London1 495 £495 2017-09-04
London1 495 £495 2017-09-01
Milton Keynes1 218 £218 2017-08-31
Leeds1 218 £218 2017-08-31
London1 218 £218 2017-08-31
Sheffield1 218 £218 2017-08-31
Leeds4 2000 £2000 2017-08-25
Manchester2 218 £218 2017-08-17
Liverpool1 218 £218 2017-08-17
Leicester1 165 £165 2017-08-15
Birmingham2 751 £751 2017-08-14
London1 495 £495 2017-08-04
Bristol1 218 £218 2017-08-03
London2 751 £751 2017-08-03
Coventry1 218 £218 2017-08-03
Birmingham1 218 £218 2017-08-03
Leicester1 165 £165 2017-07-31
Nottingham1 218 £218 2017-07-20
Leicester1 218 £218 2017-07-20
Slough1 218 £218 2017-07-20
Leeds2 751 £751 2017-07-20
Reading1 218 £218 2017-07-20
Cardiff4 2000 £2000 2017-07-13
Edinburgh2 751 £751 2017-07-13
London1 218 £218 2017-07-06
Sheffield1 218 £218 2017-07-06
Milton Keynes1 218 £218 2017-07-06
Leeds1 218 £218 2017-07-06