Microsoft Access 2016 Advanced Training Materials

TRUSTED LOCATIONS & DEFAULT LOCATIONS

• Specifying a trusted location
• Specifying the default file location

QUERIES

• 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

FORMS

• 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: list box
• 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

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 & footers
• Sorting & 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 & 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 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