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.
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:
Course Content
The Basics:
Table Data:
Queries:
Reports:
Printing:
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:
Course Content
The Basics:
Table Data:
Table Design:
Data Entry:
Relationships:
Creating and Using Forms:
Queries:
Reports:
Importing and Exporting Data:
Printing:
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:
Course Content
Database Overview:
Enhancing Tables:
Advanced Queries:
Advanced Forms:
Advanced Reports:
Supplemental Topics:
The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.
In the world of Microsoft, the only constant thing is change. Office 365 has evolved into Microsoft 365. This is just a quick article
