• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Course Access 2010 Essential Training Author Alicia Katz Pollock SKU ISBN Release Date 2010-06-10 Duration 3.30 hrs / 79 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags Access

1. Access Basics Database concepts and terminology 05:35 Starting Access 00:55 Creating a new file 01:10 Trusting a file 00:56 The Quick Access toolbar 01:08 Backstage view 02:45 Exploring ribbons 02:59 Using the Navigation pane 02:11 Getting help 01:29 2. Creating a First Database and Using the Tools Planning and designing your database 01:33 Creating tables using Application Parts 06:48 Creating tables in Layout view with Quick Start 03:59 Creating and editing tables in Design view 02:41 Setting a primary key 01:20 Creating a lookup field 03:59 Creating multi-value fields 02:19 Using calculated fields 00:54 3. Setting Up the Data Setting field properties 07:34 Setting input masks 02:03 Setting validation rules 03:31 4. Building Structure Creating relationships and enforcing referential integrity 04:44 Viewing subdatasheets 00:48 5. Formatting and Appearance Entering data into your tables 09:44 Formatting tables 04:02 Finding, sorting, and filtering records 06:06 6. Forms Creating data-entry forms 02:31 Using the Form Wizard 01:38 Modifying a form in Layout view 07:01 Using Design view 12:41 Setting tab stops 01:26 Adding buttons to a form 01:49 Using navigation forms 02:51 7. Queries Introduction to queries 01:09 Using the Query Wizard 01:52 Creating a query in Design view with criteria 04:18 Creating wildcard queries 01:24 Creating reusable parameter queries 01:29 Creating yes/no queries 01:12 Creating "and" and "or" queries 03:07 Building calculation queries 02:44

Creating statistical queries 03:01 Using update queries 02:56 Using delete queries 01:31 Creating crosstab queries 02:06 8. Reports Introduction to reports 01:28 Using the Report Wizard 02:00 Formatting reports in Layout view 05:16 Identifying report structure in Design view 02:30 Adding group and sort capabilities to a report 02:43 Adding existing fields from other tables 01:59 Adding totals and subtotals to a report 02:58 Adding conditional formatting and data bars to a report 02:38 Creating multi-table reports 01:46 Creating mailing labels 02:16 Printing reports 01:09 9. Putting Data to Work PivotTables 02:29 PivotCharts 02:03 10. Automating with Macros Creating macros 02:53 Attaching macros to objects 02:26 Using data macros 02:16 11. Using Other Applications with Access Importing Excel and text data 03:39 Exporting data into Excel 01:00 Exporting to PDF 00:53 Exporting into a Word Mail Merge 01:03 Publishing to a web browser in HTML or XML 01:51 Sharing via email 00:58 Collecting data over email 02:42 Using Package and Sign 01:14 Publishing to SharePoint 02:59 Importing and exporting with SharePoint 00:51 12. Advanced Tools in the Database Compacting and repairing a database 00:48 Using data analysis tools 01:04 Encrypting a database and setting a password 02:22 Splitting a database 02:27 13. Customization Customizing the ribbons 01:16 Setting Access options 07:03 Conclusion Goodbye 00:14