MS Access – create your first database

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

Learn Database Design with MS Access

1. DOWNLOADS

1.1 Exercises__MS_Access_create-your-first-database.pdf

1.2 Joins__MS_Access-create-your-first-database.pdf

1.3 Presentation__MS_Access-create-your-first-database.pdf

1. Materials.html

2.1 Customers.xlsx

2.2 Products.xlsx

2.3 SalesHistory.xlsx

2.4 SalesHistory2.xlsx

2. Excel files.html

2. PREFACE

1. Welcome

3. INTRODUCTION TO DATABASE DESIGN

1. INTRO

2. Basic definitions

3. Data Models

4. Data types

5. Relational database, primary and foreign keys

6. Relationship types

7. Relationship (one to many) - visualized example

8. Data normalization

9. First Normal Form (1NF)

10. Second Normal Form (2NF)

11. Third Normal Form (3NF)

12. SQL language - introduction

13. The order of writing and executing commands

14. Objects of MS Access database (1)

15. Objects of MS Access database (2)

16. Differences between MS Access and MS Excel

4. THEORY TEST

1. Knowledge test - theory.html

5. CREATING TABLES

1. INTRO

2. CREATE A TABLE CONTAINING PRODUCT DATA (1.1.)

3. INSERT DATA INTO A TABLE WITH PRODUCTS (1.2.)

4. CREATE A TABLE WITH SALES HISTORY (1.3.)

5. IMPORT DATA TO THE SALES HISTORY TABLE (1.4.)

6. CREATING QUERIES

1. INTRO

2. CREATE A QUERY WITH SALES HISTORY (2.1.)

3. ADD COLUMN WITH SALES VALUE (NET) TO CREATED QUERY (2.2.)

4. CREATE A QUERY WITH PRODUCT SALES SUMMARY (2.3.)

5. CREATE A QUERY WITH SUMMARY SALES OF CALCULATORS (2.4.)

7. CREATING FORMS

1. INTRO

2. CREATE A FORM TO ADDING AND EDITING PRODUCT DATA (3.1.)

3. CREATE A FORM TO ADDING AND EDITING SALES HISTORY DATA (3.2.)

4. CREATE A REPORTING FORM INCLUDING EXPORT BUTTONS (3.3.)

8. CREATING REPORTS AND DATA EXPORT

1. INTRO

2. CREATE A REPORT BASED ON A QUERY WITH SALES HISTORY DETAILS (4.1.)

3. ADD THE OPTION TO OPEN QUERY WITH SALES SUMMARY AND EXPORT DATA (4.2.)

4. ADD THE OPTION TO EXPORT QUERY WITH SALES OF CALCULATORS AND EXPORT DATA (4.3.)

5. PASSWORD.html

9. PRACTICE TEST

1. Knowledge test - practice.html

10. ADDITIONAL INFO (FRONT-END - BACK-END)

1.1 links.zip

1. Split database (optional)

11. END

1. Thanks

139,000 تومان

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

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

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

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