Access 2016 Training Materials – Advanced Level
Access 2016 Courseware
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
