Access 365 All Levels

Level I: 1 Day $395

This Instructor-led Training course covers the basic skills and concepts students need to use Microsoft Access 365 productively and efficiently. After an introduction to the Access 365 environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports.

Chapter 1: Getting Started

Database concepts
Exploring the Access environment

Chapter 2: Databases and Tables

Planning and designing databases
Exploring tables
Creating tables

Chapter 3: Fields and Records

Changing the design of a table
Finding and editing records
Organizing records

Chapter 4: Data Entry Rules

Setting field properties
Working with input masks
Setting validation rules

Chapter 5: Basic Queries

Creating and using queries
Modifying query results
Performing operations in queries

Chapter 6: Using Forms

Creating forms
Using Design view
Sorting and filtering records

Chapter 7: Working with Reports

Creating reports
Using basic formulas in reports
Modifying and printing reports

Level II: 1 Day $395

This Instructor-led Training course provides students with additional skills and concepts needed to use Microsoft Access 365 productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms and reports, insert background images and charts; and create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields.

Chapter 1: Understanding Relational Databases

Database normalization
Table relationships
Referential integrity

Chapter 2: Related Tables

Creating lookup fields
Modifying lookup fields
Subdatasheets

Chapter 3: Complex Queries

Joining tables in queries
Using calculated fields
Summarizing and grouping values

Chapter 4: Advanced form design

Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
Advanced form types

Chapter 5: Reports and Printing

Report formatting
Calculated values and subreports
Printing
Label printing

Chapter 6:

Charts in forms
Charts in reports

Level III: 1 Day $395

This Instructor-led Training course provides students with additional skills and concepts needed to use Microsoft Access 365 in an advanced manner. They will learn to query with SQL, create advanced queries, create and run macros, import, export and link objects, and understand database management.

Chapter 1: Querying with SQL

SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Chapter 2: Advanced Queries

Creating crosstab queries
Creating parameter queries
Using action queries

Chapter 3: Macros

Creating, running, and modifying macros
Attaching macros to the events of database objects

Chapter 4: Advanced Macros

Creating macros to provide user interaction
Creating macros that require user input
Creating Autokeys and AutoExec macros
Creating macros for data transfer

Chapter 5: Importing, Exporting, and Linking Objects

Importing objects
Exporting objects
Working with XML documents
Linking Access objects
Using hyperlink fields

Chapter 6: Database Management

Optimizing resources
Protecting databases
Setting options and properties