Microsoft Access Relational Database Management

Focused View

Abraham Eninla

9:41:34

20 View

1. MODULE ONE - OVERVIEW OF MICROSOFT ACCESS

1.1 MICROSOFT ACCESS - What you will Learn.pdf

1. INTRODUCING THE MICROSOFT ACCESS COURSE.mp4

00:53

2.1 MICROSOFT ACCESS (Presentation) - full.pdf

2. INTRODUCTION TO MICROSOFT ACCESS APPLICATION.mp4

02:41

3.1 MICROSOFT ACCESS (Presentation) - full.pdf

3. OVERVIEW OF MICROSOFT ACCESS (PART 1).mp4

06:03

4.1 MICROSOFT ACCESS (Presentation) - full.pdf

4. OVERVIEW OF MICROSOFT ACCESS (PART 2).mp4

04:19

5.1 MICROSOFT ACCESS (Presentation) - full.pdf

5. WORKING WITH TABLES IN MICROSOFT ACCESS.mp4

07:15

6. CREATING A TABLE (PRACTICAL SESSION).mp4

13:11

7. TABLE FIELD PROPERTIES.mp4

08:40

8. TABLE PROPERTIES AND CREATING TABLES.mp4

12:20

9.1 MICROSOFT ACCESS QUERIES.pdf

9. WORKING WITH QUERIES IN ACCESS.mp4

08:08

10. WORKING WITH FORMS IN ACCESS.mp4

14:33

11. WORKING WITH REPORTS IN ACCESS.mp4

13:06

12. WORKING WITH DATA TYPES.mp4

08:14

13. WORKING WITH DATA TYPES (PRACTICAL).mp4

07:33

14. WORKING WITH TABLE RELATIONSHIP.mp4

06:11

15. WORKING WITH PRIMARY AND FOREIGN KEYS.mp4

12:24

16. Introduction to Microsoft Access.html

2. MODULE TWO - CREATING MICROSOFT ACCESS TABLES

1.1 cardeal company-2.zip

1. CREATING A TABLE FROM TEMPLATE.mp4

14:14

2.1 cardeal company-2.zip

2. CREATING TABLES (CUSTOMERS, ORDERS & PRODUCTS).mp4

05:14

3.1 cardeal company-2.zip

3.2 Customer Table.xlsx

3. CREATING AND DESIGNING THE CUSTOMERS TABLE.mp4

11:11

4.1 cardeal company-2.zip

4.2 Orders Table.xlsx

4. CREATING AND DESIGNING THE ORDERS TABLE.mp4

06:36

5.1 cardeal company-2.zip

5.2 Products Table.xlsx

5. CREATING AND DESIGNING THE PRODUCTS TABLE.mp4

07:45

6. ENTERING DATA INTO TABLES.mp4

06:01

7.1 Customer Table.xlsx

7.2 Orders Table.xlsx

7.3 Products Table.xlsx

7. IMPORTING EXCEL FILES INTO ACCESS.mp4

10:29

8. SETTING FIELD PROPERTIES ON IMPORTED TABLES.mp4

09:59

9.1 cardeal company-2.zip

9. SETTING VALIDATION RULES IN ACCESS.mp4

05:05

10.1 cardeal company-2.zip

10. SETTING UP VALIDATION RULES (CONTD..).mp4

07:02

11.1 cardeal company-2.zip

11. CREATING INPUT MASK IN ACCESS.mp4

11:00

12.1 cardeal company-2.zip

12. CREATING LOOKUP VALUES IN ACCESS.mp4

11:32

13. WORKING WITH GENERAL TOOLS IN TABLES.mp4

08:16

14. Microsoft Access - Table Creation and Management.html

3. MODULE THREE - CREATING QUERIES IN MICROSOFT ACCESS

1.1 MICROSOFT ACCESS QUERIES.pdf

1. WORKING WITH QUERIES (PRESENTATION).mp4

06:57

2.1 cardeal company-2.zip

2. WORKING WITH QUERIES (CUSTOMERS TABLE).mp4

09:10

3. WORKING WITH QUERIES (PRODUCTS TABLE).mp4

08:57

4. WORKING WITH QUERIES (BETWEEN, IN, OR) COMMANDS.mp4

09:06

5. WORKING WITH QUERIES (LIKE AND NULL) COMMANDS.mp4

05:47

6. QUERYING A CALCULATED FIELD.mp4

12:18

7. QUERYING MULTIPLE TABLES (RELATIONSHIP).mp4

04:05

8. GROUPING DATA IN QUERIES.mp4

18:17

9. WORKING WITH SEPARATE QUERIES.mp4

12:16

10. WORKING WITH CALCULATED FIELD FROM QUERIES.mp4

15:10

11. WORKING WITH CROSSTAB IN ACCESS QUERIES.mp4

15:13

12. GROUPING DATA IN QUERIES.mp4

09:24

13. GROUPING BY DATES IN ACCESS QUERIES (Part 1).mp4

19:49

14. GROUPING BY DATES IN ACCESS QUERIES (PART 2).mp4

04:33

15. RUNNING QUERIES USING SQL COMMANDS.mp4

09:18

16. CREATING UNION QUERIES USING SQL COMMANDS IN ACCESS.mp4

06:51

17. WORKING WITH MATHS AND TEXT FUNCTIONS IN ACCESS.mp4

10:16

18. WORKING WITH DATES FUNCTIONS.mp4

10:58

19. WORKING WITH AGGREGATE FUNCTIONS USING SQL COMMANDS.mp4

05:43

20. WORKING WITH AGGREGATE FUNCTIONS (ACCESS ENVIRON).mp4

08:13

21. Microsoft Access - Query and SQL Commands.html

4. MODULE FOUR - WORKING WITH FORMS IN ACCESS

1. WORKING WITH FORMS IN ACCESS.mp4

09:51

2. WORKING WITH FORMS DESIGN VIEW (PART 1).mp4

05:41

3. WORKING WITH FORMS DESIGN VIEW (PART 2).mp4

08:38

4. FORMS DESIGN IN ACCESS (PART 3).mp4

15:52

5. WORKING WITH UNBOUND FORMS FIELD.mp4

15:37

6. BOUNDING AN UNBOUND FIELD IN FORMS.mp4

05:54

7. ADDING CONTROLS TO FORM OBJECT.mp4

13:36

8. ADDING PASSPORT PHOTOS TO RECORDS.mp4

09:34

9. TYPES OF FORM LAYOUTS IN MICROSOFT ACCESS.mp4

06:44

10. INSERTING CHARTS INTO MICROSOFT ACCESS FORMS.mp4

07:01

11. Microsoft Access - Working with Forms and Design View.html

5. MODULE FIVE - WORKING WITH ACCESS REPORTS

1. WORKING WITH REPORTS IN MICROSOFT ACCESS.mp4

08:28

2. EXPORTING ACCESS REPORTS IN VARIOUS FORMATS.mp4

12:15

3. MANAGING THE MICROSOFT ACCESS REPORTS.mp4

09:08

4. CONCLUDING THE MICROSOFT ACCESS REPORT.mp4

10:59

5. Microsoft Access - Working with Reports.html

Description

Handling Database Professionally

What You'll Learn?

The fundamentals of database design
Creating and managing tables, queries, and forms
Building robust relationships between data
Generating reports and visualizing data
Practical tips and real-world examples

Who is this for?

Data Analyst, Spreadsheet analyst, financial analyst, data entry personnel, database management specialist, and all those who are interested in learning how to handle and manage large dataset.

What You Need to Know?

Basic data handling knowledge is required; basic knowledge of Microsoft Excel would be an advantage.

More details

Description
Unlock the full potential of your data with our Mastering Microsoft Access course. This comprehensive program is designed to equip participants with the skills and knowledge needed to effectively manage, analyze, and visualize data using Microsoft Access, a powerful and versatile database management system. It is time to Dive into the world of data management excellence with this course. This intensive program is meticulously crafted to empower participants with the essential skills and knowledge required to proficiently navigate and harness the capabilities of Microsoft Access, a dynamic and versatile database management system.Â Throughout the course, participants will explore the intricacies of database design and optimization, learning to construct tables with precision and establish relationships that enhance data organization. The querying and data retrieval modules delve into the art of SQL and Query Design, enabling participants to extract specific data and derive meaningful insights through calculations and aggregations.Â Forms and user interface design take center stage as participants master the creation of user-friendly interfaces, implementing controls and validation to ensure data accuracy. The course also covers the art of report generation and data visualization, allowing participants to communicate insights effectively through customized layouts and visual elements.Â By the conclusion of this course, participants will emerge equipped with the expertise to efficiently create, manage, and analyze databases using Microsoft Access. Whether you are a novice or an intermediate user, this course is tailored to provide a comprehensive understanding and mastery of Microsoft Access, unlocking the full potential of your data management endeavors.

Who this course is for:
Data Analyst, Spreadsheet analyst, financial analyst, data entry personnel, database management specialist, and all those who are interested in learning how to handle and manage large dataset.

User Reviews

Rating

average 0

Total votes0

Focused display

Abraham Eninla is a Certified Microsoft Office Specialist, with expert-level knowledge and experience in Microsoft Excel. For over 18 years, the lecturer has been an active IT Solution Provider and Financial Analyst, He also trains students in Web Development. As a specialized Training Providers and Consultant, he uses Microsoft Office Application and other specialized software to engage corporate personnel in productivity tasks and Training, He also handles regularly Sage 50, QuickBooks Accounting, Project Management Training, Abraham Eninla is currently the CEO of Lead Vision Concepts, the Founder of Wisdom Bank Motivation for Living and Executive Director of Abraham Eninla International. He is also a Public Speaker, Motivator, writer, and the regular Voice Broadcaster of 2 Minutes Motivations.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.