Access 365 Foundations: Everything you need to create a DB.

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

Learn database foundation skills that can be used in learning Mongo, Oracle or even SQL Cloud

1. Getting Started

1. Coruse & Instructor Introductions

2. Support Notes for Students.html

3.1 Access 365 Foundations Data Files.zip

3. Courses Resource Files & PDF Manual.html

4. Contacting the Instructor

5. Lets Set Some Expectations

6. PDF Manual & Video Correlation.html

2. Introduction to Databases

1. What is a Database

2. Database Objects

3. Access Environment

4. Basic Actions

5. Working in Datasheet View

6. Design View of Any Object

7. Section 2 Lession 1 Exercise

3. Creating Access Tables

1. Creating a Database

2. Creating Tables & Assigning Data Types

3. Setting Primary Key

4. Setting Field Properties

5. Copying Pasting Existing Tables

6. Section 3 Lession 2 Exercise

4. Data Normalization & Relationships

1. What is Data Normailization

2. Setting Table Relationships

3. Foreign Keys & Integrity Rules

4. Creating Relationships

5. Section 4 Lesson 3 Exercise

5. Creating Forms to Collect Data

1. The Basics of Forms

2. Creating Forms wForm Wizard

3. Working with Controls

4. Working with Property Sheet

5. Modifying Form Layout

6. Creating a Calculated Control

7. Setting the Form Tab Order

8. Creating a Split Form

9. Instructions to Create the Next Forms

10. Creating the Cars Form

11. Creating the Tickets Form

12. Creating the Mechanics Form

13. Creating the Service Orders Form

14. Section 5 Lesson 4 Exercise

6. Selecting Data with Queries

1. Select Queries

2. Creating a Query

3. Creating a Multi-Table Query

4. Adding Criteria to a Query

5. Performing Calculations in Queries

6. Creating a Parameter Query

7. Adding Totals to Datasheets

8. Section 6 Lesson 5 Exercise

7. Presenting Data with Reports

1. Using the Report Wizard

2. Using Controls & Report Views

3. Report Sorting & Grouping Levels

4. Adding Page Breaks & PDF

5. Section 7 Lesson 6 Exercise

8. Next Steps

1. Instructor Thankyou

2. Access Foundations Project

139,000 تومان

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

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

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

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