Microsoft Access Relational Database Management

سرفصل های دوره

Handling Database Professionally

1. MODULE ONE - OVERVIEW OF MICROSOFT ACCESS

1.1 MICROSOFT ACCESS - What you will Learn.pdf

1. INTRODUCING THE MICROSOFT ACCESS COURSE

2.1 MICROSOFT ACCESS (Presentation) - full.pdf

2. INTRODUCTION TO MICROSOFT ACCESS APPLICATION

3.1 MICROSOFT ACCESS (Presentation) - full.pdf

3. OVERVIEW OF MICROSOFT ACCESS (PART 1)

4.1 MICROSOFT ACCESS (Presentation) - full.pdf

4. OVERVIEW OF MICROSOFT ACCESS (PART 2)

5.1 MICROSOFT ACCESS (Presentation) - full.pdf

5. WORKING WITH TABLES IN MICROSOFT ACCESS

6. CREATING A TABLE (PRACTICAL SESSION)

7. TABLE FIELD PROPERTIES

8. TABLE PROPERTIES AND CREATING TABLES

9.1 MICROSOFT ACCESS QUERIES.pdf

9. WORKING WITH QUERIES IN ACCESS

10. WORKING WITH FORMS IN ACCESS

11. WORKING WITH REPORTS IN ACCESS

12. WORKING WITH DATA TYPES

13. WORKING WITH DATA TYPES (PRACTICAL)

14. WORKING WITH TABLE RELATIONSHIP

15. WORKING WITH PRIMARY AND FOREIGN KEYS

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

2.1 cardeal company-2.zip

2. CREATING TABLES (CUSTOMERS, ORDERS & PRODUCTS)

3.1 cardeal company-2.zip

3.2 Customer Table.xlsx

3. CREATING AND DESIGNING THE CUSTOMERS TABLE

4.1 cardeal company-2.zip

4.2 Orders Table.xlsx

4. CREATING AND DESIGNING THE ORDERS TABLE

5.1 cardeal company-2.zip

5.2 Products Table.xlsx

5. CREATING AND DESIGNING THE PRODUCTS TABLE

6. ENTERING DATA INTO TABLES

7.1 Customer Table.xlsx

7.2 Orders Table.xlsx

7.3 Products Table.xlsx

7. IMPORTING EXCEL FILES INTO ACCESS

8. SETTING FIELD PROPERTIES ON IMPORTED TABLES

9.1 cardeal company-2.zip

9. SETTING VALIDATION RULES IN ACCESS

10.1 cardeal company-2.zip

10. SETTING UP VALIDATION RULES (CONTD..)

11.1 cardeal company-2.zip

11. CREATING INPUT MASK IN ACCESS

12.1 cardeal company-2.zip

12. CREATING LOOKUP VALUES IN ACCESS

13. WORKING WITH GENERAL TOOLS IN TABLES

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)

2.1 cardeal company-2.zip

2. WORKING WITH QUERIES (CUSTOMERS TABLE)

3. WORKING WITH QUERIES (PRODUCTS TABLE)

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

5. WORKING WITH QUERIES (LIKE AND NULL) COMMANDS

6. QUERYING A CALCULATED FIELD

7. QUERYING MULTIPLE TABLES (RELATIONSHIP)

8. GROUPING DATA IN QUERIES

9. WORKING WITH SEPARATE QUERIES

10. WORKING WITH CALCULATED FIELD FROM QUERIES

11. WORKING WITH CROSSTAB IN ACCESS QUERIES

12. GROUPING DATA IN QUERIES

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

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

15. RUNNING QUERIES USING SQL COMMANDS

16. CREATING UNION QUERIES USING SQL COMMANDS IN ACCESS

17. WORKING WITH MATHS AND TEXT FUNCTIONS IN ACCESS

18. WORKING WITH DATES FUNCTIONS

19. WORKING WITH AGGREGATE FUNCTIONS USING SQL COMMANDS

20. WORKING WITH AGGREGATE FUNCTIONS (ACCESS ENVIRON)

21. Microsoft Access - Query and SQL Commands.html

4. MODULE FOUR - WORKING WITH FORMS IN ACCESS

1. WORKING WITH FORMS IN ACCESS

2. WORKING WITH FORMS DESIGN VIEW (PART 1)

3. WORKING WITH FORMS DESIGN VIEW (PART 2)

4. FORMS DESIGN IN ACCESS (PART 3)

5. WORKING WITH UNBOUND FORMS FIELD

6. BOUNDING AN UNBOUND FIELD IN FORMS

7. ADDING CONTROLS TO FORM OBJECT

8. ADDING PASSPORT PHOTOS TO RECORDS

9. TYPES OF FORM LAYOUTS IN MICROSOFT ACCESS

10. INSERTING CHARTS INTO MICROSOFT ACCESS FORMS

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

5. MODULE FIVE - WORKING WITH ACCESS REPORTS

1. WORKING WITH REPORTS IN MICROSOFT ACCESS

2. EXPORTING ACCESS REPORTS IN VARIOUS FORMATS

3. MANAGING THE MICROSOFT ACCESS REPORTS

4. CONCLUDING THE MICROSOFT ACCESS REPORT

5. Microsoft Access - Working with Reports.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy