Microsoft Office Access
Microsoft Access can be one of the most confusing software platforms in the Microsoft Office Suite as it is the most mis-understood. Simply put, Microsoft Access is an information management tool that provides users with the ability to store information for: referencing, reporting, and analysis.
Microsoft Access gives users with the ability to analyze large amounts of information and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. It does this by enabling the user to run queries, and set up Graphical User Interfaces (GUI) to simplify tasks by performing them at the click of a button. Reports can be generated easily and efficiently.
Microsoft Access is widely used among Government, Crown Corporations and Non-Profits due to its relatively reasonable cost, and less complicated learning curve as compared to SQL databases.
We offer courses in Access Level 1, Access Level 2, and Custom Access courses. Courses can be delivered in 3-hour blocks, and scheduled in the morning, afternoon, or early evenings. Yes, we also provide weekend training classes.
Microsoft Access - Introduction to Data Entry and Reports
Who should attend? This course is intended for new Microsoft Access users.
Prerequisites: Windows 7, Windows 8, or Windows 10.
Duration: 6 Hours
Course Objectives:
Upon completion of the course, participants will be able to accomplish the following:
- Identify the components of a database, and work with those components.
- Open a table, find information stored there, and enter data.
- Create several query types, edit and run queries, and use action and calculation queries.
- Create several report types, enhance reports and print preview reports.
- Preview and print database objects, and change the page setup options.
Course Content
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 Datasheet Appearance
- Entering and Editing Data
- Applying Filters
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
Printing:
- Printing Objects
- Print Preview
Microsoft Access - Level 1 Database Design (2 Days)
Who should attend? This course is intended for new Microsoft Access users.
Prerequisites: Windows 7, Windows 8, or Windows 10.
Duration: 12 Hours (2 Days)
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
- Identify the components of a database, and work with those components.
- Open a table, find information stored there, and enter data.
- Create and customize a table design.
- Enter data into tables, and ensure its accuracy by using input masks and input validation formulas.
- Create relationships between tables to ensure data accuracy and to deploy referential integrity.
- Create forms for entering data into tables, and change the design elements that have been placed on those forms.
- Create several query types, edit and run queries, and use action and calculation queries.
- Create several report types, enhance reports and print preview reports.
- Import and export data to and from various sources, including text files and Excel.
- Preview and print database objects, and change the page setup options.
Course Content
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 Datasheet 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
Microsoft Access - Level 2 Database Design
Who should attend? This course is intended for participants who are familiar with Microsoft Access.
Prerequisites: Microsoft Access – Level 1 or Equivalent.
Duration: 6 Hours
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
- Understand the databases that will be used during the course.
- Enhance tables by creating lookups.
- Create various types of advanced queries.
- Create advanced forms by adding controls, subforms, calculations, and graphic images.
- Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts.
- Work with and create web-based objects.
Course Content
Database Overview:
- Review
Enhancing Tables:
- Copying a Database Object
- Lookup Fields
- Creating a Lookup
Advanced Queries:
- Query Overview
- The Query Wizard
- Nested Queries
- Query Joins
- Make Table Queries
- Append Queries
- Summary Queries
- Crosstab Queries
Advanced Forms:
- Form Design
- Controls
- Form Properties
- Subforms
- Advanced Calculations
- Customizing Forms
Advanced Reports:
- Designing Reports
- Sorting and Grouping
- Layout Properties
- Calculations
- Subreports
- Graphic Reports
- Chart Wizard
Supplemental Topics:
- Working with Web Tools
- Working with Web Pages
- Hyperlinks