Microsoft Access 2013 Advanced

Microsoft Access 2013 Intermediate Training Materials

TRUSTED LOCATIONS & DEFAULT LOCATIONS

  • Specifying a trusted location
  • Specifying the default file location

QUERIES

  • About queries
  • Creating and running an update query
  • Creating and running a delete query
  • Creating and running a make table query
  • Creating and running an append query
  • Creating and running a crosstab query
  • Creating and running a find duplicates query
  • Creating and running a find unmatched records query
  • What is a parameter query?
  • Creating and running a one variable parameter query
  • Modifying a one variable parameter query
  • Creating and running a two variable parameter query
  • Modifying a two variable parameter query
  • Using wildcards in a query: star
  • Using wildcards in a query: brackets and 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

FORMS

  • Types of form controls
  • Bound controls vs. Unbound controls
  • Creating, modifying and deleting bound controls: text box
  • Creating, modifying and deleting bound controls: combo box
  • Creating modifying and deleting bound controls: list box
  • Creating bound controls: check box
  • Modifying and 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

REPORTS

  • 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 and footers
  • Sorting and grouping records in a report by field(s)
  • Forcing page breaks for groups in a report
  • Creating a linked sub-report

MACROS

  • Macro to close an object and open another object
  • Macro to open and maximize an object
  • Macro to print and close an object
  • Assigning a macro to a command button
  • Assigning a macro to an object
  • Assigning a macro to a control

LINKING DATA

  • 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 DATA

  • 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

 

Microsoft Access 2013 Advanced
3 (60%) 2 votes