ACCESS

Microsoft Access can create database applications that will give high levels of control, security and distribution of company data. Every database is created for a specific purpose within your organisation, our Access course will give you the skills to set a database up from scratch and be able to amend and add to an existing Access database in order to get the most out of this very powerful application.

ACCESS INTRODUCTION

This course will ensure that delegates will gain a good understanding of the correct principles to follow when setting up and working with a database. Delegates will learn how to design and set up the main database components, and how to use queries to extract and report on specific data.

  • Understanding database concepts

  • Principles of tables, queries, forms and reports
  • Looking at a finished example
  • Access screen, menus and icons
  • The database design window
  • Creating tables in design view
  • Understanding fields, data types and design concepts
  • Adding a primary key
  • Adding editing and deleting table records
  • Sorting and filtering of table data
  • Creating a form using the form wizard
  • Form layouts and styles
  • Amending the form in design view
  • Formatting forms using colours and layout
  • Creating basic queries in the design view
  • Running queries to generate results
  • Queries using multiple criteria
  • Creating Reports using the report wizard
  • Basing reports on tables or queries
  • Layout and formatting of reports in the design view
  • Formatting colours and layout
  • Preview or print reports

ACCESS INTERMEDIATE

Designed for existing Access users this course will look at making the database components work harder by using more automation and by clever ways to link the separate components together. Learn more complex ways to use the queries tool to give instant data specific results and create a menu driven database that will be easier for other colleagues to use.

NEXT DATE: TBC
  • Recap database principles and concepts
  • Planning the database
  • Normalising data
  • Relationships between multiple tables
  • Setting field input masks and validation
  • Table level validation
  • Refresher on basic queries
  • Using logical functions as criteria
  • Using calculated fields
  • Summary and crosstab queries
  • Parameter queries
  • Recap of basic forms
  • Adding subforms
  • Creating a search box
  • Protecting forms using properties
  • Using command buttons to link components
  • Creating dialog box for user choices
  • Building a menu system and basic database security

ACCESS ADVANCED

This advanced level course will provide you with the tools to automate your database tasks using macros and build a better user interface or switchboard. Learn how to store the database on the server and give colleagues selective menus and forms relevant to their jobs. We will also introduce the Visual Basic programming environment and write some simple ‘starter code’ as a taster for the next course.

NEXT DATE: TBC
  • The 3 Relationship types in a multi-table database
  • Queries to update table data
  • Queries to move data between 2 tables
  • Queries to Delete table data
  • Queries to back up data
  • Running ‘Action Queries’ from user forms
  • Setting database passwords
  • Controlling database start up
  • Automation using macros to link objects
  • Change properties with macros
  • Creating a custom Menu
  • Creating a ‘front end’ and splitting a database

MAKE AN ENQUIRY