Access

by Promaxis Claim Listing

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Promaxis Logo

img Duration

1 Day

Course Details

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft® Office Access®

Part 1: Focuses on the design and construction of an Access database, including viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

 

Lesson 1: Getting Started With Access

  • Launch Access and Open a Database

  • Use tables to store data.

  • use queries to Combine,

  • Find,

  • Filter and sort data;

  • Use forms to view, add, and update data; use reports to present data.

  • Get Help and Configure Options in Microsoft Access

 

Lesson 2: Creating Tables

  • Plan an Access Database;

  • Start a new access database.

  • Create a new table.

  • Establish Table Relationships

 

Lesson 3: Creating Queries

  • Create basic queries.
  • calculations in a query;
  • Sort and Filter Data in a Query

 

Lesson 4:Creating Forms

  • Start a New Form
  • Enhance a Form

 

Lesson 5: Creating Reports

  • Start a New Report
  • Enhance Report Layout
  • Ottawa Branch

    2385 St Laurent Boulevard, Ottawa

Check out more MS Access courses in Canada

Rapid Computer Training Inc. Logo

Microsoft Outlook

In the Microsoft Outlook class, attendees learn about advanced features of email, efficient management of the INBOX, customization of views, rules, conditional formatting, categories, calendars, people contacts, tasks, and many other time savers.

by Rapid Computer Training Inc. [Claim Listing ]
PMC (Performance Management Consultants) Logo

MS Excel (2016, 2019, 365) - Level 1

Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool.

by PMC (Performance Management Consultants) [Claim Listing ]
CPA Alberta Logo

Advanced Excel

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly course, you will learn critical advanced Excel skills in six key areas:

by CPA Alberta [Claim Listing ]
Web Age Solutions team Logo

Introduction to Microsoft PowerPoint 2019 Training

Students will explore the PowerPoint environment and create a presentation. Students will format text on slides to enhance clarity and add graphical objects to a presentation and modify them.

by Web Age Solutions team [Claim Listing ]
AFI Expertise Logo

Access Basics

Discover Access with this program. Learn how to manipulate records, format a table structure and create a database. Please note that the version most represented in the group will be installed on all computer stations, but the differences between the versions will be addressed during the training.

by AFI Expertise [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy