[valentin]

lynda.com | Access 2010 Power Shortcuts - Быстрые клавиши [2011] [EN] PCRec

Автор (режиссер): lynda.com
Название: Access 2010 Power Shortcuts - Быстрые клавиши
Год выпуска: 2011
Жанр: Access
Язык: EN
Качество видео: PCRec
Продолжительность: 03:43:00
Видеокодек: Advanced Video Codec (AVC)
Битрейт видео: ~71,8 - 1314 кбит/с
Размер кадра: 960х540
Аудиокодек: Advanced Audio Codec (AAC)
Битрейт аудио: 92,9 - 159 кбит/сек 2 канала 48,0 КГц

Описание:
В курсе Access 2010 Power Shortcuts автор, Access эксперт Alicia Katz Pollock делится сотнями подсказок и быстрых клавиш для значительного увеличения эффективности и получения максимума от Access 2010. Курс включает подсказки по работе с лентой Ribbon и панелью инструментов Quick Access, управлению файлами, настройке и автоматизации Access, производительному вводу и редактированию данных, работе с таблицами, запросами, формами и отчётами, управлению вашей базой данных и многому другому.
Файлы упражнений прилагаются к курсу.

Introduction

Welcome 0:47

Using the exercise files 0:28

1. Top Tips

Customizing the Navigation pane 2:23

Toggling between Design and Data views 2:40

Creating new fields with field templates 2:09

Understanding the "Cannot contain a Null value" error 1:29

Working with AutoNumbers as foreign keys 2:24

Using input masks 2:39

Four ways to add fields to a query 1:41

Four ways to filter data 2:56

Selecting multiple form and report controls 2:13

Aligning and distributing controls on forms and reports 5:15

2. File Management

Opening recent files 2:33

Opening your most recently used file automatically 0:56

Selecting a startup form 1:00

Changing the default saving location 1:19

3. Ribbon and Quick Access Toolbar Tips

Expanding and collapsing the Ribbon 1:13

Three ways to customize the Quick Access toolbar 3:14

Selecting Ribbon buttons using KeyTips 1:47

Creating your own ribbons 2:08

4. Interface Shortcuts

Turning the Navigation pane into a switchboard 3:48

Right-clicking 2:48

Using keyboard shortcuts 2:50

5. Navigation Shortcuts

Navigating between records 2:08

Using Search, Go to, and Find 2:20

Selecting fields, rows, columns, and tables 1:28

6. Data Entry and Editing Shortcuts

Undo and Redo tips 2:18

Entering data across, not down 0:59

Repeating data from the record above 1:39

Copying and pasting content 2:44

Inserting today's date 1:10

Removing automatic hyperlinks 1:54

Using AutoCorrect 1:36

Using concatenated fields 2:16

Linking Outlook contacts 2:23

Saving imports and exports for reuse 4:47

7. Table Techniques

Creating a table using application parts 2:18

Creating Quick Start fields 1:49

Saving application parts 2:43

Understanding number field sizes 3:02

Setting default field types 2:55

Using validation rules 4:00

Using flag fields 2:01

Using an index 2:04

Using a datasheet Totals row 2:00

Filtering by selection 1:26

Resizing columns and rows 2:07

Removing gridlines and shading from tables 1:29

Hiding and unhiding table fields 1:13

Freezing fields when scrolling 0:59

Analyzing your table for redundant structure 5:50

8. Relationship Techniques

Setting a starting AutoNumber 3:14

Creating a multi-field primary key 4:17

Using subdatasheets 1:27

Using relationship reports 1:55

9. Query Techniques

Using wildcards 5:40

Using IN instead of OR 1:29

Hiding query fields 0:54

Changing captions 1:31

Finding duplicate records 2:13

Moving records with append and delete queries 4:31

Using make-table queries 2:12

Creating an update query 2:55

Turning a query into a PivotTable 2:30

Turning a query into a PivotChart 2:06

Using SQL statements 2:31

10. Form Techniques

Using the property sheet to work with controls 2:16

Creating option groups 2:43

Using a ComboBox to select a record 2:55

Creating tabbed form layouts 4:45

Inserting charts 3:42

Creating your own smart tags 1:24

Using the CanGrow and CanShrink properties 1:46

Hiding fields in printouts 1:26

Setting tab stops 3:41

Clipping, stretching, and zooming images 1:17

Viewing single or continuous forms 1:01

Changing a form's default view 1:52

11. Report Techniques

Inserting page breaks in reports and forms 2:15

Creating headers and footers 5:49

Hiding duplicates in reports 1:03

12. Formatting Shortcuts

Using themes to customize the look of the database 4:12

Using the Format Painter 2:25

Grouping controls on forms and reports 1:35

Setting default appearance for new databases 2:05

13. Macro and Event Techniques

Using a Before Change macro to create a time stamp 6:51

Triggering a Before Delete warning message 2:49

Creating an After Update macro to email a customer 2:11

Creating a user interface macro 4:12

Using AutoExec macros 1:53

14. Database Management Techniques

Saving templates 2:10

Locking files 0:43

Conclusion

Goodbye 0:44

Скриншоты:

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