Mastering Access - Intermediate

- Πληροφορική - Χρήστες

31 Ιαν 2024 17:32 31 Ιαν 2024 17:32
Αγγλικά
1 ώρες ( ημέρα )
Mastering Access - Intermediate

ΠΕΡΙΓΡΑΦΗ

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users develop powerful apps customized for their business needs.   

In this course experienced Microsoft Access trainer Kathy Jones will build upon the basics of tables, queries, forms, and reports covered in the Basics course.  Starting with the basics of relational database design, this course will expand your knowledge of Microsoft Access by covering topics such as table relationships, query joins, subdatasheets, field validation, parameter queries, and more.  

In this course you will learn how to:  

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Validate data entered into a database
  • Use advanced queries to manipulate your data
  • Organize a database for efficiency and performance, and to maintain data integrity
  • Customize reports to organize the displayed information and produce specific print layouts 

Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn Over two hours of high quality HD content in Teacher/Learner style! 

Modules Include: 

  1. Relational Database Design
  2. Creating a Table
  3. Creating Table Relationships 
  4. Creating Query Joins 
  5. Relating Data Within A Table 
  6. Working with Subdata Sheets
  7. Using Field Validation, Part 1 
  8. Using Field Validation, Part 2 
  9. Using Forms and Record Validation 
  10. Creating Parameter Queries 
  11. Summarizing Data 
  12. Creating Subqueries
  13. Creating Action Queries 
  14. Creating Unmatched/Duplicate Queries
  15. Data Normalization  16: Creating a Junction Table 
  16. Creating a Table Structure 
  17. Including Control Formatting in a Report 
  18. Adding Calculated Fields to a Report 
  19. Adding a Sub-Report to an Existing Report

Αγορά: Mastering Access - Intermediate


€ 30.00
Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
Mastering Access - Basics...

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users dev...

31/01/2024 17:32

Αγγλικά

eLearning

Mastering PowerPoint - Intermediate & Advanced...

DESCRIPTIONLearn advanced features to get the most out of PowerPoint 2019 or PowerPoint 365. Have you seen someone deliver a PowerPoint presentation that was re...

31/01/2024 17:32

Αγγλικά

eLearning

Excel 2019 - Intermediate...

This is our most requested training course!If you learn to use Excel 2019 or Excel 365, you will start to see how useful it is in your life—from formatting your...

31/01/2024 17:32

Αγγλικά

eLearning

Mastering Outlook - Beginner...

From Time-Waster To Productivity Booster: Change The Way You Use Microsoft Outlook  Few things have greater impact on your productivity than the way you employ ...

31/01/2024 17:32

Αγγλικά

eLearning

Excel 2019 - Beginner...

DESCRIPTIONMicrosoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A soli...

31/01/2024 17:32

Αγγλικά

eLearning

Excel 2019 - Advanced...

DESCRIPTIONThis course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and C...

31/01/2024 17:32

Αγγλικά

eLearning

Windows 10 for Beginner & Intermediate Users...

This Course Is For People New To Windows 10 Taking This Course Will Help You Understand The New Operating System Navigation, Advantages, And Functionality  Wind...

31/01/2024 17:32

Αγγλικά

eLearning

Cyber Security Awareness Training...

Cyber Security Awareness  Course Description  Cybersecurity has never been more prominent in the news than these days. Colossal breaches made headlines across t...

31/01/2024 17:32

Αγγλικά

eLearning

Mastering Access - Intermediate...

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users dev...

31/01/2024 17:32

Αγγλικά

eLearning

Mastering PowerPoint - Beginner...

Making PowerPoint Easy and EffectiveUsing PowerPoint effectively is a crucial skill for any business professional. Whether its designing a presentation for a me...

31/01/2024 17:32

Αγγλικά

eLearning

Mastering Outlook - Advance...

From Time-Waster To Productivity Booster: Change The Way You Use Microsoft Outlook  Few things have greater impact on your productivity than the way you employ ...

31/01/2024 17:32

Αγγλικά

eLearning