Course Information

Overview

Level

Advanced

Version

2016

Outline

  • Specifying a trusted location
  • Specifying the default file location
  • About queries
  • Creating & running an update query
  • Creating & running a delete query
  • Creating & running a make table query
  • Creating & running an append query
  • Creating & running a crosstab query
  • Creating & running a find duplicates query
  • Creating & running a find unmatched records query
  • What is a parameter query?
  • Creating & running a one variable parameter query
  • Modifying a one variable parameter query
  • Creating & running a two variable parameter query
  • Modifying a two variable parameter query
  • Using wildcards in a query: star
  • Using wildcards in a query: brackets & dash
  • Using wildcards in a query: exclamation mark
  • Using wildcards in a query: hash
  • Showing maximum or minimum values in a query
  • Using calculated fields that perform arithmetic calculations
  • Grouping information in a query using functions ‐sum
  • Grouping information in a query using functions ‐count
  • Grouping information in a query using functions ‐average
  • Grouping information in a query using functions ‐max & min
  • Types of form controls
  • Bound controls vs. Unbound controls
  • Creating, modifying & deleting bound controls: text box
  • Creating, modifying & deleting bound controls: combo box
  • Creating modifying & deleting bound controls: listbox
  • Creating bound controls: check box
  • Modifying & deleting bound controls: check box
  • Manipulating bound controls: option groups
  • Applying bound control properties: limit to list
  • Applying bound control properties: distinct values
  • Manipulating unbound controls containing arithmetic expressions
  • Manipulating unbound controls containing logical expressions
  • Modifying the tab order within a form
  • What is a sub‐form?
  • Creating a sub‐form
  • Linking a sub‐form
  • Formatting arithmetic calculation controls to display a percentage
  • Formatting arithmetic calculation controls to display currency
  • Formatting arithmetic calculation controls to display specific decimal places
  • Applying a running sum for a group or over all
  • What is concatenation?
  • Concatenating fields within a report.
  • Inserting a data field into a report group
  • Inserting a data field into a report page
  • Inserting a data field into report headers & footers
  • Sorting & grouping records in a report by field(s)
  • Forcing page breaks for groups in a report
  • Creating a linked sub‐report
  • Macro to close an object & open another object
  • Macro to open & maximize an object
  • Macro to print & close an object
  • Assigning a macro to a command button
  • Assigning a macro to an object
  • Assigning a macro to a control
  • Linking external data in an excel workbook to a database
  • Linking external text data in a txt file to a database
  • Linking external text data in a csv file to a database
  • Linking external data to a database using existing database files
  • Importing an excel file into a database
  • Importing a csv text into a database
  • Importing a txt file into a database
  • Importing an xml file into a database
  • Importing an existing database file into a database
Dates and Prices

There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.

image
1 Day

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle