Objectives of the training
By the end of the training course, the participant will be able to create and manage a database with Access 2021, as well as its tables, forms, reports, queries, and records.Targeted audience
Any user wishing to discover or deepen their knowledge of Access features for creating and managing a database (tables, forms, reports, and queries).Prerequisite
No prior knowledge of Access is required. Minimal experience with the software can help you progress faster.Trainers
Course architecture
Access 2021 – Essential Foundations for Creating and Managing a Database
Databases and Database Objects
• Creating a database
• Opening/closing a database
• Database objects
• Managing objects
• Information on dependencies between objects
• Using Access help
Records and Data
• Managing rows and columns in a datasheet
• Creating records
• Accessing records
• Modifying field values
• Searching for records
• Replacing field values
• Deleting records
• Quick sorting of records
• Filtering records
• Specific filter
• Inserting a totals row in a datasheet
Tables, Fields, and Table Relationships
• Creating a table and field properties
• Modifying a table structure in Datasheet view
• Modifying a table structure in Design view
• Controlling field entry
• Input mask
• Creating a lookup list
• Defining a primary key
• Indexing a table
• Relationships between tables
Forms
• Creating a form
• Form properties
• Disabling access to certain fields
• Tab order for fields
• Subform
• Data entry in a form and subform
• Themes
Creating and Managing Controls
• Inserting a text box
• Selecting and deleting controls
• Creating a check box, option button, or toggle button
• Creating an option group
• Creating a text label
• Creating a calculated control
• Statistical calculation
• Creating a list of fixed data
• Creating a list of data from another table
• Copying and moving controls
• Aligning controls
• Section heights
• Creating a line or rectangle
• Sizing controls
• Formatting control text
• Aligning control text
• Control presentation
• Conditional formatting
• Copying the format of one control to another
• Grouping/ungrouping controls
• Page numbering
• Inserting an image
Creating and Printing a Report
• Creating a report
• Print preview
• Sort order associated with a report
• Grouping records in a report
• Managing groups during printing
• Printing a report for specific records
• Print margins and orientation
• Mail merge labels
Select Queries and Action Queries
• Creating a select query
• Using the query grid
• Entering a criterion in the query grid
• Running a query
• Entering criteria for multiple fields
• Entering multiple criteria for the same field
• Sort order in queries
• Calculated fields in queries
• Statistical calculations in a query
• Statistical calculations with record grouping
• Statistical calculations with grouping of specific records
• Parameterized select query, non-matching query, query to find duplicates, delete query, table creation query, update query, crosstab query
Advanced Features
• Database protection
• Database conversion
• Importing data from another application
• Exporting data
• XML data import and export
Book
Access 2021
• General Information
• Databases
• Database Objects
• Table Structure
• Relationships Between Tables
• Records
• Data
• Printing Data
• Creating a Form
• Creating a Report
• Printing a Report
• Bound Controls
• Unbound Controls
• Calculated Controls
• Managing Controls
• Sections
• Select Queries
• Calculations in Queries
• Action Queries
• Copying/Importing/Exporting
• Macro Commands
• Customizing the Access Interface
Pedagogical details
Type of training
Training Notes
100% remote training. Accessible anytime, anywhere. One year of access to training and digital manual.
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quotePrivate or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote