Total Training for Microsoft Access 2007: Essentials
Производитель:
Total Training
Год выпуска: 2007
Язык: английский
Ссылка на официальную веб-страницу: http://www.totaltraining.com/prod/microsoft/access2007_ess.asp
Автор: Jeff Conrad
Продолжительность: 6.6 hours
Файлы проэктов: в раздаче
Уровень: Beginner to Intermediate
Видео кодек: QuickTime
Разрешение: 960x540
Описание: Explore the endless capabilities of Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases. Once you're up to speed on the intricacies of Access, Jeff walks you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.
Содержание
Contents:
Course Outline
PART 1
Lesson 1: INTRODUCING ACCESS 2007 (17 min)
1. Defning a Database
2. Knowing When to Use Access™
3. Working with Database Objects
4. Converting Older Databases
Lesson 2: EXPLORING THE NEW USER INTERFACE (84 min)
1. Exploring the Getting Started Screen
2. Opening a Microsoft Template
3. Using the Navigation Pane
4. Using the Home Tab, Part 1
5. Using the Home Tab, Part 2
6. Using the Create Tab
7. Using the External Data Tab
8. Using the Database Tools Tab
9. Using the Office Menu
10. Explaining the Access Options
11. Using the Quick Access Toolbar
12. Adding Custom Commands to the Quick Access Toolbar
13. Using the Help Menu
14. Understanding the Message Bar
15. Creating Trusted Locations
16. Working in the Object Window
Lesson 3: WORKING IN THE NAVIGATION PANE (45 min)
1. Displaying Categories
2. Showing Views
3. Sorting the Objects
4. Searching for Objects
5. Collapsing Groups
6. Creating Custom Groups
7. Adding Object Shortcuts
8. Hiding Custom Groups
9. Changing the Interface Mode
10. Final Comments & Credits
PART 2
Lesson 1: CREATING TABLES (67 min)
1. Explaining the Datasheet Tab
2. Entering Data in a New Table
3. Using a Table Template
4. Identifying the Entities
5. Working with Design View
6. Creating DataTypes
7. Using Field Validation Rules
8. Dening Primary Keys
9. Adding Indexes
10. Working with Table Relationships
11. Creating Table Relationships
12. Dening Multi-Value Field Lookups
Lesson 2: CREATING QUERIES (50 min)
1. Creating a Select Query
2. Using Expressions in a Query
3. Sorting Data
4. Searching for Data
5. Selecting Data from Many Tables
6. Working in Layout View
7. Working in SQL View
8. Creating a Crosstab Query
9. Running Action Queries
10. Running Update Queries
11. Using the Query Wizard
Lesson 3: CREATING FORMS (48 min)
1. Using Quick Create Commands
2. Exploring Form Types
3. Navigating within Forms
4. Using the Form Wizard
5. Creating a Form from Scratch
6. Working in Layout View
7. Working in Design View
8. Setting Form Properties
9. Using Form Controls
10. Using Control Layouts
11. Applying AutoFormats
12. Understanding Subforms
Lesson 4: CREATING REPORTS (57 min)
1. Using the Report Command
2. Running the Report Wizard
3. Exploring Report Views
4. Creating a Report from Scratch
5. Using Conditional Formatting
6. Grouping & Sorting
7. Setting Report Properties
8. Detailing Your Report
9. Applying AutoFormats
10. Adding Subreports
11. Alternating Record Colors
12. Filtering in Report View
13. Creating Labels
Lesson 5: CREATING MACROS (26 min)
1. Working in Macro Design Mode
2. Assigning Macro Actions
3. Setting Macro Arguments
4. Running an AutoExec Macro
5. Creating Embedded Macros
6. Final Comments & Credits
