Access - Navigating and organizing databases - Training Courses | Afi U.
afiU logo
Guaranteed to Run sessions 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
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)
Coaching Fundamentals Executive Leadership Leadership and Team Management Conscious, collaborative, and transformational leadership View all programs
Management in the digital age Innovation Governance: Tools and Strategies to Transform Your Organization Leader as Coach: Better Delegation and Empowerment Management in Turbulent Times Coaching in a Consulting Role Building a Customer-Centric Culture: Drive Loyalty, Growth, and Innovation Transform Employee Experience The essentials of an ESG strategy View all microprograms
Artificial intelligence at the service of your organization Achieving your aspirations as a young professional Managing a Growing SME Adapting your management style to the new generations View all Circles by Afi U.
Private DeliveryCollaborative Learning WorkshopsBusiness CoachingCustom 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 Afi U. 2024-2025 Training Catalog Guaranteed-to-run schedule Discover the Power BI learning path
Contact|FAQFR
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

Upcoming sessions

No date suits you?

Notify me when a session is added.

  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306tip icon

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

Yves Pilon
Yves Pilon
Trainer
Yves Pilon is passionate about technological tools. His knowledge of web and office softwares has made him an expert on all Microsoft Office tools. Yves' excellent pedagogy has earned him praise from our clients on several occasions. He stands out for his spirit of synthesis and active sense of listening to the needs of the participants. The expertise he has accumulated over the years gives him the ability to ensure a productive transfer of knowledge to our clients.
Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
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.