[}{отт@бь)ч]

lynda.com | Access 2010 Essential Training [2010] [EN] PCRec

---

Автор (режиссер): lynda.com
Название: Access 2010 Essential Training
Год выпуска: 2010
Жанр: Access
Язык: EN
Качество видео: PCRec
Продолжительность: 03:30:00
Видеокодек: Advanced Video Codec (AVC)
Битрейт видео: ~16.5 - 788 кбит/с
Размер кадра: 960 x 540
Аудиокодек: Advanced Audio Codec (AAC)
Битрейт аудио: 96,0 Кбит/сек 2 канала 48,0 КГц

Описание:
В этом видеокусе Access 2010 Essential Training автор Alicia Katz Pollock дает всесторонний обзор создания баз данных в Access 2010, вне зависимости от использования шаблона или создания БД с нуля. Этот курс охватывает все шаги конструирования и модифицирования БД для специальных целей, а также работу с таблицами, формами, запросами, макросами и отчетами с диаграммами для хранения и анализа записей.
Файлы упражнений прилагаются к курсу.

Introduction

Welcome 0:51 5.9 MB

Using the exercise files 0:34 0.5 MB

1. Access Basics 19:08

Database concepts and terminology 5:35 5.1 MB

Starting Access 0:55 1.0 MB

Creating a new file 1:10 1.1 MB

Trusting a file 0:56 0.9 MB

The Quick Access toolbar 1:08 1.3 MB

Backstage view 2:45 3.1 MB

Exploring ribbons 2:59 3.8 MB

Using the Navigation pane 2:11 2.6 MB

Getting help 1:29 2.4 MB

2. Creating a First Database and Using the Tools 23:33

Planning and designing your database 1:33 1.6 MB

Creating tables using Application Parts 6:48 6.8 MB

Creating tables in Layout view with Quick Start 3:59 4.0 MB

Creating and editing tables in Design view 2:41 2.8 MB

Setting a primary key 1:20 1.5 MB

Creating a lookup field 3:59 4.3 MB

Creating multi-value fields 2:19 2.6 MB

Using calculated fields 0:54 1.0 MB

3. Setting Up the Data 13:08

Setting field properties 7:34 8.0 MB

Setting input masks 2:03 2.3 MB

Setting validation rules 3:31 3.6 MB

4. Building Structure 05:32

Creating relationships and enforcing referential integrity 4:44 4.8 MB

Viewing subdatasheets 0:48 1.2 MB

5. Formatting and Appearance 19:52

Entering data into your tables 9:44 9.5 MB

Formatting tables 4:02 6.1 MB

Finding, sorting, and filtering records 6:06 8.2 MB

6. Forms 29:57

Creating data-entry forms 2:31 2.9 MB

Using the Form Wizard 1:38 1.7 MB

Modifying a form in Layout view 7:01 8.8 MB

Using Design view 12:41 18.2 MB

Setting tab stops 1:26 2.1 MB

Adding buttons to a form 1:49 2.4 MB

Using navigation forms 2:51 4.3 MB

7. Queries 26:49

Introduction to queries 1:09 1.4 MB

Using the Query Wizard 1:52 2.4 MB

Creating a query in Design view with criteria 4:18 4.6 MB

Creating wildcard queries 1:24 1.5 MB

Creating reusable parameter queries 1:29 1.7 MB

Creating yes/no queries 1:12 1.6 MB

Creating "and" and "or" queries 3:07 3.3 MB

Building calculation queries 2:44 3.0 MB

Creating statistical queries 3:01 3.2 MB

Using update queries 2:56 3.3 MB

Using delete queries 1:31 2.1 MB

Creating crosstab queries 2:06 2.4 MB

8. Reports 26:43

Introduction to reports 1:28 2.2 MB

Using the Report Wizard 2:00 2.4 MB

Formatting reports in Layout view 5:16 7.0 MB

Identifying report structure in Design view 2:30 3.1 MB

Adding group and sort capabilities to a report 2:43 3.5 MB

Adding existing fields from other tables 1:59 2.6 MB

Adding totals and subtotals to a report 2:58 4.2 MB

Adding conditional formatting and data bars to a report 2:38 3.3 MB

Creating multi-table reports 1:46 1.9 MB

Creating mailing labels 2:16 2.8 MB

Printing reports 1:09 1.6 MB

9. Putting Data to Work 04:32

PivotTables 2:29 2.9 MB

PivotCharts 2:03 2.5 MB

10. Automating with Macros 07:35

Creating macros 2:53 3.2 MB

Attaching macros to objects 2:26 2.7 MB

Using data macros 2:16 2.6 MB

11. Using Other Applications with Access 17:14

Importing Excel and text data 3:43 4.8 MB

Exporting data into Excel 1:00 1.6 MB

Exporting to PDF 0:53 1.2 MB

Exporting into a Word Mail Merge 1:03 1.1 MB

Publishing to a web browser in HTML or XML 1:51 3.1 MB

Sharing via email 0:58 1.1 MB

Collecting data over email 2:42 3.5 MB

Using Package and Sign 1:14 1.7 MB

Publishing to SharePoint 2:59 3.4 MB

Importing and exporting with SharePoint 0:51 0.9 MB

12. Advanced Tools in the Database 06:41

Compacting and repairing a database 0:48 1.2 MB

Using data analysis tools 1:04 1.4 MB

Encrypting a database and setting a password 2:22 2.9 MB

Splitting a database 2:27 2.8 MB

13. Customization 08:19

Customizing the ribbons 1:16 1.7 MB

Setting Access options 7:03 8.0 MB

Conclusion 00:14

Goodbye 0:14 0.2 MB

Скриншоты:


Время раздачи: с 23:00 до 8:00 (днём по возможности) до первых пяти скачавших
Заранее извиняюсь за низкую скорость раздачи... быстро скачать не получится...
Отдельная благодарность Группе "Uploaders" и лично slava03 за поддержку релизов