MicroSoft Access Database Queries for Beginners

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

MicroSoft Access Database queries are used to retrieve specific records and trends from your data.

1. Introduction

1. Introduction to the MS Access Course.html

2. Section 2 Starting out with Access

1.1 northwind_diagram.zip

1.2 schema.zip

1. Introduction to your data.html

2. Lecture 1 Create a new database in MS Access

3. Create a new table in MS Access

4. Import Data From Excel, using copy and paste

5. Import Data From Excel, and verify the data types

6. Import Data From Excel, lets do it all the data together

7. Get useful insights from your data, simply from the Home Ribbon!

3. Section 3 Access Query Basics

1. Create a Query

2. Access Housekeeping Rename a table, Delete a table, Close a Query

3. MS Access Query Criteria Filter a dataset using text values

4. Query Cretiria Filter a dataset using number values

5. Query Crietiria Filter a dataset using date values

6. Sort a query

7. Top value queries

8. Multiple Query Criteria in Access Using OR

9. Multiple Query Criteria in Access Using AND

10. Multiple Query Criteria in Access Using AND and OR

4. Section 4 MS Access Expression Queries and Total Queries

1. MS Access Expression Queries

2. MS Access Totals Queries, Grouping records and using Aggregate Functions

5. Save a MS Access query for regular use

1. Save an MS Access Query

6. Section 5 Parameter Queries

1. What is a parameter query

2. Simple Parameter Query, Using Text Values

3. Parameter Query Using Number Values

4. Parameter Query Using Date Values

7. Section 6 All about Auto-Numbers

1. What is an Auto-Number in MS Access

2. Create a table with Auto-Numbers

3. Re-using auto-numbers, once a number is deleted

4. Starting auto-numbers at any value but 1

5. Create a table an importing and using an existing series of auto-numbers

6. Copy And Paste Excel Data, maintaining the incoming Auto_Numbers

7. Use an Apped query to start Auto_numbers at something other than 1

139,000 تومان

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

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

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

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