MS Access (2016, 2019, 365) – Level 1
208-26
Productivity software
Techniques to Work Effectively with Databases
This two-day course will help you understand how to identify and work with database components; open tables to locate, edit and enter data; create and customize tables; use input masks and data validation techniques; create table relationships ensuring data integrity; create and customize table forms; work with queries to extract, edit and perform calculations with table data; create and customize reports; import and export data into tables and preview and print data objects.
At the end of this workshop, you will be able to:
- Work with Tables, Forms, Queries and Reports
- Enter, edit and filter table data
- Create and set custom options for inputting table data
- Relate tables to one another using referential integrity
- Create and customize forms
- Work with different types of queries
- Create and print reports
- Import and export data to Excel and other formats
The Basics
- Database Concepts
- Getting Started
- Creating a Database
- Converting Access Files
- Working with Objects
- Using Access Help
Table Data
- Table Concepts
- Viewing Data in a Table
- Changing the Database Appearance
- Entering and Editing Data
- Applying Filters
Table Design
- Creating a Table
- Changing the Table Design
Data Entry
- Data Entry Concepts
- Data Formats
- Input Masks
- Input Validation
- Adding Records
Relationships
- 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
Queries
- Using the Query Wizard
- Creating a Query in Design View
- Selecting and Sorting in a Query
- Calculations
- Action Queries
- Parameter Queries
Reports
- Creating Reports
- Using the Report Wizard
- Previewing Reports
- Creating Reports in Design View
- Changing Report Design
- Control Operations
- Control Attributes
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
- Printing Objects
- Print Preview
There are no prerequisites for this course.
This workshop is intended for anyone who has a good working knowledge of Microsoft Office products and is seeking to understand how to work with databases.
The advantages of team sessions
- Learn and grow together as a team
- Location and time of your choice
- Sessions can be customized to fit your objectives
- Surprisingly cost effective
Submit your interest