Microsoft Access 2016/2019/2021/365
This course covers the basic functions and features of Access. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.
Course duration: 1 day
Cost: Please request quote or click here to see pricing for onsite training.
Pre-Requisites: Windows 8 or equivalent experience.
Course Outline
- Database concepts
- Exploring the Access environment
- Getting help
- Planning and designing databases
- Exploring tables
- Creating tables
- Changing the design of a table
- Finding and editing records
- Organizing records
- Setting field properties
- Working with input masks
- Setting validation rules
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
- Creating forms
- Using Design view
- Sorting and filtering records
- Creating reports
- Modifying and printing reports
This course builds on the skills and concepts taught in Access Beginner. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Course duration: 1 day
Cost: Please request quote or click here to see pricing for onsite training.
Pre-Requisites: Microsoft Access Level 1 or equivalent experience.
Course Outline
- Database normalization
- Table relationships
- Referential integrity
- Creating lookup fields
- Modifying lookup fields
- Subdatasheets
- Joining tables in queries
- Using calculated fields
- Summarizing and grouping values
- Adding unbound controls
- Adding graphics
- Adding calculated values
- Adding combo boxes
- Advanced form types
- Customized headers and footers
- Calculated values
- Printing
- Labels
- Charts in forms
- Charts in reports
- PivotTables
- Modifying PivotTables
- PivotCharts
- PivotTable forms
This course builds on the skills and concepts taught in Access Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password protect and encrypt databases; and set Access options and properties.
Course duration: 1 day
Cost: Please request quote or click here to see pricing for onsite training.
Pre-Requisites: Microsoft Access Level 2 or equivalent experience.
Course Outline
- SQL and Access
- Writing SQL statements
- Attaching SQL queries to controls
- Creating crosstab queries
- Creating parameter queries
- Using action queries
- Creating, running, and modifying macros
- Attaching macros to the events of database objects
- Creating macros to provide user interaction
- Creating macros that require user input
- Creating the AutoKeys and AutoExec macros
- Creating macros for data transfer
- Importing objects
- Exporting objects
- Interacting with XML documents
- Linking Access objects
- Hyperlink fields
- Optimizing resources
- Protecting databases
- Setting options and properties