Access Level 1 Database Design
Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE.
Database concepts, getting started, creating a database, converting Access 2016 files, working with objects.
Table concepts, viewing data in a table, changing the datasheet appearance, entering and editing data, applying filters.
Creating a table, changing the table design.
Data entry concepts, data formats, input masks, input validation, adding records.
Relationships between tables, creating a relationship, referential integrity, removing a relationship, printing relationships.
Creating and Using Forms
Creating a form using AutoForm, creating a form using the Form Wizard, creating a form in design view, opening a form, changing a form design, adding controls, placing controls, multiple-choice controls, error checking.
Using the Query Wizard, creating a query in Design view, selecting and sorting in a query, calculations, action queries, parameter queries.
Creating reports, using the Report Wizard, previewing reports, creating reports in Design view, changing report design, control operations, control attributes, creating charts.
Importing and Exporting Data
Importing and exporting, importing a text file, importing data from an Access database, exporting data, troubleshooting importing and exporting problems.
Printing objects, print preview.
Access Level 2 Advanced Database Design
Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE. Prerequisite: Access Level 1.
Copying a database object, lookup fields, creating a lookup.
Query overview, the Query Wizard, nested queries, query joins, make table queries, append queries, summary queries, crosstab queries.
Form design, controls, form properties, subforms, advanced calculations, customizing forms.
Designing reports, sorting and grouping, layout properties, calculations, subreports, graphic reports, chart wizard.
Supplemental Topics: Working with Web Tools
Working with web pages, hyperlinks.
Access Level 3 Advanced Topics
Training available for Access 2013 / 2016 / 2019 or Excel for Office 365. Delivery via Online LIVE. Prerequisite: Access Level 2.
Macro concepts, creating a macro, creating a macro group, opening a macro, running a macro, attaching a macro, macro conditions.
Switchboards overview, creating switchboards, editing a switchboard form.
Setting Access defaults, customizing the Navigation Pane.
Compacting a database, backing up a database, splitting a database, documenting a database.
Securing a database, securing a share-level database, Access Trust Center.
Microsoft Access is a registered trademark of Microsoft Corporation. onsite‑training.com provides Access training but is not affiliated with Microsoft.