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

Formation Cad Logo

Microsoft Excel Training (Basic 1)

Discover this very powerful and versatile spreadsheet software from the Microsoft Office suite. Excel offers many features, from simple to complex, which can be adapted according to your level and your needs.

by Formation Cad [Claim Listing ]
  • Price
  • Start Date
  • Duration
ES Computer Training Logo

Microsoft Word

All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...

by ES Computer Training [Claim Listing ]
PMVISION Logo

Advanced Microsoft Excel Training Courses

This Advanced Microsoft Excel training course is designed for students to gain the skills necessary to be able to protect worksheet data, perform advanced data operations using summarizing, data consolidations, filters, pivot tables, macros, and much more.

by PMVISION [Claim Listing ]
  • Price
  • Start Date
  • Duration
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 ]
ProTech Training Logo

Microsoft Visio 2019/2021: Part 1

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive p...

by ProTech Training [Claim Listing ]

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