Access - Navigating and organizing databases - Training Courses | Afi U.
afiU logo
Explore our 2025-2026 catalogue View all courses
HumanLeadershipCommunication and InfluencePersonal DevelopmentCoaching SkillsCustomer ExperienceTraining Function
Digital ToolsMicrosoft 365Microsoft CopilotMicrosoft SharepointMicrosoft Power PlatformSoftware Design Tools
TechnologyInfrastructure and systemSecurityCloudArtificial IntelligenceProgramming and Development
Data ScienceArtificial IntelligenceData ManagementBusiness IntelligenceDatabaseAutomation
Organizational StrategyBusiness AnalysisDigital TransformationIT Policy and GovernanceManagement and coachingNegociation and Influence
Project ManagementAgile MethodologyLean MethodologyScrumSAFe
Campus AI
3 days
Building a Customer-Centric Culture: Drive Loyalty, Growth, and Innovation

Accelerate Your Growth with a Customer-Centric Culture.

4 days
Mastering a Strategic Consulting Role with a Coaching Approach

Develop the ability to strategically support individuals and teams.

12 days
Coaching Fundamentals

Develop the skills and obtain your accredited coach certification to successfully support change and transformation.

7 half-days
Leader-Coach: Delegation and Team Empowerment

Enhance your leadership-coach posture by learning to delegate more effectively and empower your teams.

8 sessions of 90 minutes each
Innovation Governance: Tools and Strategies to Transform Your Organization

Make innovation the engine of your growth and resilience

60 hours
Executive Leadership

Develop a new approach to leadership and take your executive leadership role further.

5 days
Leadership and Team Management

Gain confidence in your role as a team manager and elevate your leadership maturity.

View all programs
Training and Coaching

Cultivate a learning organization and develop talent.

Customer Experience

Optimize your processes for operational excellence.

Employee Experience

Engage, empower, and enhance employee well-being.

Artificial Intelligence

Master AI and automate your processes.

Leadership

Develop key skills to inspire and mobilize.

Digital Tools

Boost collaboration and productivity within your teams

Strategy and Performance

Align your goals for sustainable growth.

Digital Transformation

Leverage technology to innovate and accelerate your growth.

MICROSOFT

Azure Developer AssociateAzure Architect DesignAzure Data Engineer Microsoft 365 FundamentalsView more

AWS

Certified Cloud PractitionerCertified Solutions ArchitectCertified Developer - AssociateCertified DevOps EngineerView more

LEAN SIX SIGMA

Lean Six Sigma - Green BeltLean Six Sigma - White BeltLean Six Sigma - Yellow BeltView more

PMI

Project Management - BasicsAgile Project Management - BasicsLeading SAFe 6 CertificationProgram ManagementView more

ICF

Coaching Fundamentals (level 1)Strategic coaching of a group (level 2)Supervision and deepening of coaching skills (level 3)View more

Other certifications

CompTIAVMwareCiscoITILScaled Agile Framework® (SAFe)
Private DeliveryCollaborative Learning WorkshopsBusiness CoachingPersonalized programsPrivate Conferences
Who are we?Afi U. ExperienceThe TeamOur OfficesPartners and CertificationsCareers
BlogFunding programsNewsletterFAQContact
Benefits of Project Management and Key Trends For a leadership that fits you : find the right program Guaranteed-to-run schedule Discover the Power BI learning path

Change region

Canada (English)Canada (Français)France (Français)
ContactFAQ
Arrow leftBack to catalogue

Access - Navigating and organizing databases

Windows: Gain knowledge about the architecture of an Access database and the role of its components.
Microsoft Partner
Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

  • Duration: 1 day
  • Regular price: On request

Course outline

Duration : 1 day

© AFI par Edgenda inc.

AudienceAny data base user or manager

Prerequisites

Windows - User or equivalent

Objectives

  • Gain knowledge about the architecture of an Access database and the role of its components

Teaching method

Presentations - Demonstrations - Guided and Individual Exercises

Contents

Chapter 1 - Identifying Interface Features and Elements

  • Present and identify the elements of the Access interface
  • Present the File tab (Backstage view)
  • Customize the Quick Access Toolbar
  • Customize the user interface
  • Identify objects in a database
  • Moving around a data table
  • Identify data types
  • Get help in Access

Chapter 2 - Formatting the structure of a table

  • Manipulate rows and columns in a data table
  • Freeze and release columns
  • Change the layout of the datasheet
  • Change the layout and print a data table

Chapter 3 - Manipulating Records

  • Delete records
  • Find and replace data in records
  • Sort and filter records

Chapter 4 - Database Design and Standardization

  • Understand the design steps of a database
  • Understanding standardization

Chapter 5 - Establishing Relationships Between Tables

  • Understanding the role of relationships
  • Create a relationship between two tables
  • Understanding referential integrity
  • Perform cascading operations

Surround yourself with the best

Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.