Lynda com Access 2010 Essential Training | 09FFE0722E745C459D1397C57425A3AB4A76DDCD

Lynda com Access 2010 Essential Training

Name	Lynda.com Access 2010 Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	304.9 MB
Total Files	80
Hash	09FFE0722E745C459D1397C57425A3AB4A76DDCD

/00 Introduction/
0001 Welcome.mov	6.1 MB
0002 Using the exercise files.mov	524.8 KB
/01 Access Basics/
0101 Database concepts and terminology.mov	5.3 MB
0107 Exploring ribbons.mov	3.9 MB
0106 Backstage view.mov	3.2 MB
0108 Using the Navigation pane.mov	2.7 MB
0109 Getting help.mov	2.6 MB
0105 The Quick Access toolbar.mov	1.3 MB
0103 Creating a new file.mov	1.2 MB
0102 Starting Access.mov	1.1 MB
0104 Trusting a file.mov	970.2 KB
/02 Creating a First Database and Using the Tools/
0202 Creating tables using Application Parts.mov	7.2 MB
0206 Creating a lookup field.mov	4.6 MB
0203 Creating tables in Layout view with Quick Start.mov	4.2 MB
0204 Creating and editing tables in Design view.mov	2.9 MB
0207 Creating multi-value fields.mov	2.7 MB
0201 Planning and designing your database.mov	1.6 MB
0205 Setting a primary key.mov	1.5 MB
0208 Using calculated fields.mov	1.1 MB
/03 Setting Up the Data/
0301 Setting field properties.mov	8.4 MB
0303 Setting validation rules.mov	3.8 MB
0302 Setting input masks.mov	2.4 MB
/04 Building Structure/
0401 Creating relationships and enforcing referential integrity.mov	5.0 MB
0402 Viewing subdatasheets.mov	1.2 MB
/05 Formatting and Appearance/
0501 Entering data into your tables.mov	9.9 MB
0503 Finding, sorting, and filtering records.mov	8.6 MB
0502 Formatting tables.mov	6.4 MB
/06 Forms/
0604 Using Design view.mov	19.1 MB
0603 Modifying a form in Layout view.mov	9.3 MB
0607 Using navigation forms.mov	4.5 MB
0601 Creating data-entry forms.mov	3.1 MB
0606 Adding buttons to a form.mov	2.5 MB
0605 Setting tab stops.mov	2.3 MB
0602 Using the Form Wizard.mov	1.8 MB
/07 Queries/
0703 Creating a query in Design view with criteria.mov	4.8 MB
0710 Using update queries.mov	3.5 MB
0707 Creating and and or queries.mov	3.4 MB
0709 Creating statistical queries.mov	3.3 MB
0708 Building calculation queries.mov	3.2 MB
0712 Creating crosstab queries.mov	2.5 MB
0702 Using the Query Wizard.mov	2.5 MB
0711 Using delete queries.mov	2.2 MB
0705 Creating reusable parameter queries.mov	1.8 MB
0706 Creating yes no queries.mov	1.7 MB
0704 Creating wildcard queries.mov	1.6 MB
0701 Introduction to queries.mov	1.5 MB
/08 Reports/
0803 Formatting reports in Layout view.mov	7.4 MB
0807 Adding totals and subtotals to a report.mov	4.4 MB
0805 Adding group and sort capabilities to a report.mov	3.6 MB
0808 Adding conditional formatting and data bars to a report.mov	3.4 MB
0804 Identifying report structure in Design view.mov	3.2 MB
0810 Creating mailing labels.mov	3.0 MB
0806 Adding existing fields from other tables.mov	2.8 MB
0802 Using the Report Wizard.mov	2.5 MB
0801 Introduction to reports.mov	2.3 MB
0809 Creating multi-table reports.mov	2.0 MB
0811 Printing reports.mov	1.7 MB
/09 Putting Data to Work/
0901 PivotTables.mov	3.1 MB
0902 PivotCharts.mov	2.6 MB
/10 Automating with Macros/
1001 Creating macros.mov	3.4 MB
1002 Attaching macros to objects.mov	2.9 MB
1003 Using data macros.mov	2.7 MB
/11 Using Other Applications with Access/
1101 Importing Excel and text data.mov	5.1 MB
1107 Collecting data over email.mov	3.6 MB
1109 Publishing to SharePoint.mov	3.6 MB
1105 Publishing to a web browser in HTML or XML.mov	3.2 MB
1108 Using Package and Sign.mov	1.8 MB
1102 Exporting data into Excel.mov	1.7 MB
1103 Exporting to PDF.mov	1.3 MB
1106 Sharing via email.mov	1.2 MB
1104 Exporting into a Word Mail Merge.mov	1.2 MB
1110 Importing and exporting with SharePoint.mov	994.3 KB
/12 Advanced Tools in the Database/
1203 Encrypting a database and setting a password.mov	3.1 MB
1204 Splitting a database.mov	2.9 MB
1202 Using data analysis tools.mov	1.5 MB
1201 Compacting and repairing a database.mov	1.3 MB
/13 Customization/
1302 Setting Access options.mov	8.4 MB
1301 Customizing the ribbons.mov	1.8 MB
/14 Conclusion/
1401 Goodbye.mov	210.4 KB
/Exercise Files/
Ex_Files_Access2010_EssT.zip	36.0 MB
Total files 80