Master essential techniques to design relational tables, build queries, and create dynamic reports in Access 2021
This e-learning course, made up of a video and a book, teaches you how to create and manage a database with Access 2021. You will learn how to create a database and the objects that make it up (tables, forms, reports, and queries), as well as how to manage data (records).
Is it for you ?
Any user wishing to discover or deepen their knowledge of Access features for creating and managing a database (tables, forms, reports, and queries).
Prerequisites
No prior knowledge of Access is required. Minimal experience with the software can help you progress faster.
Training content
1 Access 2021 – The essential basics for creating and managing a database
- Databases and database objects
- Creating a database
- Opening/closing a database
- Database objects
- Managing objects
- Information on object dependencies
- Using Access help
2 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
- Sorting records quickly
- Filtering records
- Specific filters
- Inserting a total row in a datasheet
3 Tables, fields, and table relationships
- Creating a table and field properties
- Modifying table structure in Datasheet view
- Modifying table structure in Design view
- Controlling field input
- Input masks
- Creating a lookup list
- Defining a primary key
- Indexing a table
- Relationship between tables
4 Forms
- Creating a form
- Form properties
- Restricting access to certain fields
- Field access order
- Subforms
- Entering data in a form and subform
- Themes
- Creating and managing controls
- Inserting a text box
- Selecting and deleting controls
- Creating a checkbox, option button, or toggle button
- Creating an option group
- Creating a text label
- Creating a calculated control
- Statistical calculations
- Creating a list of fixed data
- Creating a list of data from another table
- Copying and moving controls
- Aligning controls
- Section height
- Creating a line or rectangle
- Sizing controls
- Formatting control text
- Aligning control text
- Presentation of controls
- Conditional formatting
- Copying a control's presentation to another
- Grouping/ungrouping controls
- Page numbering
- Inserting an image
5 Creating and printing a report
- Creating a report
- Print preview
- Sorting order associated with a report
- Grouping records in a report
- Managing groups when printing
- Printing a report for specific records
- Print margins and orientation
- Mailing labels
6 Select and Action queries
- Creating a select query
- Using the query grid
- Entering criteria in the query grid
- Running a query
- Entering criteria for multiple fields
- Entering multiple criteria for the same field
- Sorting order in queries
- Calculated fields in queries
- Statistical calculations in a query
- Statistical calculations with grouping records
- Statistical calculations with specific grouping
- Parameterized select query
- Unmatched query
- Find duplicates query
- Delete query
- Make-table query
- Update query
- Crosstab query
7 Advanced features
- Protecting a database
- Converting a database
- Importing data from another application
- Exporting data
- Importing and exporting XML data
8 Book
- This module offers you access to digital course materials.
- Access 2021 General overview
- 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
- Macros
- Customizing the Access interface
📌 Practical information
100% online training. Accessible anytime from anywhere for one year. If you have any questions about registration, the language of instruction, or the cancellation terms, please consult our FAQ