Microsoft Access Complex Forms and Reports

Course Details

 

This course is designed for people who are existing users of Microsoft Access databases and wish to be able to modify and enhance the output of existing databases. The course covers the features that are used to create more advanced forms and reports, and expressions to effectively manipulating data on forms and reports.

Duration:

1 Day

Audience:

Students who need to learn skills required to create or modify queries, forms and reports in an existing database.

Prerequisites:

Access Introduction or experience using an Access database. To gain the most from the course, participants must be familiar with database structure, tables, fields and properties.

2016

 

Learning Outcomes:

  • Design customised Forms
  • Develop more complex reports
  • Using the Expression Builder effectively
  • Automating Forms and Reports with buttons

Customised Forms/Reports

  • Using the Field List
  • Adding bound controls using the field list
  • Adding unbound controls
  • Binding an unbound control a control source
  • Working with the Form sections
  • Position, Resizing and Aligning Controls
  • Adding lines, images, check boxes, Option Buttons and Groups
  • Using Stacked layout
  • Adding Command Buttons to navigate forms
  • Changing the Tab Order of controls
  • Creating Combo Boxes and List Boxes
  • Using Multiple columns in a combo box
  • Defining Field sizes and default values

Creating Complex Reports

  • Using queries for Reports
  • Grouping Data in a report
  • Adding Headers and Footers
  • Report Layouts - stepped & blocked
  • Creating a Running Summary
  • Using Columns in report
  • Using the Keep Together property
  • Sorting Report output
  • Creating Labels

SubForms & SubReports

  • Using sub-forms and sub-reports to display data from two different tables or - queries.
  • Using Link Child and Link Master fields

Using Expression Builder with Forms and Reports

  • Manipulating Text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using Conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()
  • Referring to subform/subreport controls in expressions

Automating Forms with Buttons

  • Using the Control wizard to add a command button to a form
  • Form Operations
  • Record Operations
  • Report Operations
  • Formatting command buttons

2013

 

Learning Outcomes:

  • Design customised Forms
  • Develop more complex reports
  • Using the Expression Builder effectively
  • Automating Forms and Reports with buttons

Customised Forms/Reports

  • Using the Field List
  • Adding bound controls using the field list
  • Adding unbound controls
  • Binding an unbound control a control source
  • Working with the Form sections
  • Position, Resizing and Aligning Controls
  • Adding lines, images, check boxes, Option Buttons and Groups
  • Using Stacked layout
  • Adding Command Buttons to navigate forms
  • Changing the Tab Order of controls
  • Creating Combo Boxes and List Boxes
  • Using Multiple columns in a combo box
  • Defining Field sizes and default values

Creating Complex Reports

  • Using queries for Reports
  • Grouping Data in a report
  • Adding Headers and Footers
  • Report Layouts - stepped & blocked
  • Creating a Running Summary
  • Using Columns in report
  • Using the Keep Together property
  • Sorting Report output
  • Creating Labels

SubForms & SubReports

  • Using sub-forms and sub-reports to display data from two different tables or - queries.
  • Using Link Child and Link Master fields

Using Expression Builder with Forms and Reports

  • Manipulating Text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using Conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()
  • Referring to subform/subreport controls in expressions

Automating Forms with Buttons

  • Using the Control wizard to add a command button to a form
  • Form Operations
  • Record Operations
  • Report Operations
  • Formatting command buttons

2010/2007

 

Learning Outcomes:

  • Design customised Forms
  • Develop more complex reports
  • Using the Expression Builder effectively
  • Automating Forms and Reports with buttons

Customised Forms/Reports

  • Using the Field List
  • Adding bound controls using the field list
  • Adding unbound controls
  • Binding an unbound control a control source
  • Working with the Form sections
  • Position, Resizing and Aligning Controls
  • Adding lines, images, check boxes, Option Buttons and Groups
  • Using Stacked layout
  • Adding Command Buttons to navigate forms
  • Changing the Tab Order of controls
  • Creating Combo Boxes and List Boxes
  • Using Multiple columns in a combo box
  • Defining Field sizes and default values

Creating Complex Reports

  • Using queries for Reports
  • Grouping Data in a report
  • Adding Headers and Footers
  • Report Layouts - stepped & blocked
  • Creating a Running Summary
  • Using Columns in report
  • Using the Keep Together property
  • Sorting Report output
  • Creating Labels

SubForms & SubReports

  • Using sub-forms and sub-reports to display data from two different tables or - queries.
  • Using Link Child and Link Master fields

Using Expression Builder with Forms and Reports

  • Manipulating Text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using Conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()
  • Referring to subform/subreport controls in expressions

Automating Forms with Buttons

  • Using the Control wizard to add a command button to a form
  • Form Operations
  • Record Operations
  • Report Operations
  • Formatting command buttons

Event Properties

Event Date 23-10-2017
Event End Date 23-10-2017
Individual Price $440.00
Course Code ACMD2
Location
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia

Group Rate

#Registrants Rate/Person($)
3 418.00
4 396.00
$440.00 10

Location Map

Share this event: