Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost

£195 +VAT

Cost per individual

£195 +VAT
Public course

Cost per course

£550 +VAT
Client site, max 10 individuals

Duration

1 Day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

04/02/2019 Liverpool
11/03/2019 Bradford
13/05/2019 Liverpool
28/06/2019 Bradford

Book course

This course is intended for users already working with Microsoft Access who need to develop more complex relational databases, by using more sophisticated querying tools and creating multi-table forms and reports.

Objectives:

By the end of this course, users will be able to utilise functionality such as Action and Summary queries and create calculations in queries, forms and reports. Users will also be able to apply basic automation through the use of command buttons to make viewing, printing and closing forms and reports quick and easy.

Prerequisites: Users should be able to create a simple relational database in Access, including creating basic relationships. Users should also be able to interrogate and present data by creating simple queries, forms and reports.

Download Outline (PDF)

More on Creating Tables, Importing, Exporting & Linking Data
  • Exploring Successful Table Design
  • Creating & Using a Hyperlink Field
  • Multiple-Field Primary Key
  • Exploring Field Properties
  • Creating Input Masks & Validation Rules
  • Import & Export Access Data
  • Import & Export Data from Other Sources
  • Link Access Data
More on Queries
  • Parameter Queries
  • Creating a Calculated Field in a Queries
  • Use the Expression Builder to Create a Calculation
  • Summarise Data in a Query
  • Creating & Running Action Queries
Transforming Forms & Reports
  • Working with Form & Report Sections
  • Working with Bound & Unbound Controls
  • Creating a Calculated Control
  • Exploring the Form Design Work Surface
  • Multi-Table Forms
    • Creating Main Forms & Subforms
    • Creating Linked Forms
  • Understanding Control Properties
  • Changing Control Properties
  • Applying Themes to Forms & Reports
  • Customising Theme Colours & Fonts
  • Using the Command Button Wizard
  • Automating Forms with Command Buttons

Book a course

Fill in your information to book this course. The information you provide on this booking form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here