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.
This workshop is offered within organizations for groups of 5 people or more.
Course duration: 2 days
Course language: English
Program Topics
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
Learning Outcomes
By 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
Who Should Attend?
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.
For more information on this workshop, please contact:
Sophie Gouédard
Tel: 613-234-2020, ext. 21
Email: sgouedard@pmctraining.com