Lynda com Access 2010 Essential Training | 6518260DC209865573F1951CF15B04BAB6E7FF71

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	6518260DC209865573F1951CF15B04BAB6E7FF71

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