| 00 Introduction |
| 1 |
0001 Welcome |
|
3.64 MB |
|
|
| 2 |
0002 Using the exercise files |
|
436.40 KB |
|
|
| 01 Access Basics |
| 3 |
0101 Database concepts and terminology |
|
4.20 MB |
|
|
| 4 |
0102 Starting Access |
|
813.37 KB |
|
|
| 5 |
0103 Creating a new file |
|
953.00 KB |
|
|
| 6 |
0104 Trusting a file |
|
760.77 KB |
|
|
| 7 |
0105 The Quick Access toolbar |
|
1,015.82 KB |
|
|
| 8 |
0106 Backstage view |
|
2.46 MB |
|
|
| 9 |
0107 Exploring ribbons |
|
3.22 MB |
|
|
| 10 |
0108 Using the Navigation pane |
|
2.15 MB |
|
|
| 11 |
0109 Getting help |
|
1.99 MB |
|
|
| 02 Creating a First Database and Using the Tools |
| 12 |
0201 Planning and designing your database |
|
1.33 MB |
|
|
| 13 |
0202 Creating tables using Application Parts |
|
5.49 MB |
|
|
| 14 |
0203 Creating tables in Layout view with Quick Start |
|
3.23 MB |
|
|
| 15 |
0204 Creating and editing tables in Design view |
|
2.15 MB |
|
|
| 16 |
0205 Setting a primary key |
|
1.15 MB |
|
|
| 17 |
0206 Creating a lookup field |
|
3.34 MB |
|
|
| 18 |
0207 Creating multi-value fields |
|
1.97 MB |
|
|
| 19 |
0208 Using calculated fields |
|
826.30 KB |
|
|
| 03 Setting Up the Data |
| 20 |
0301 Setting field properties |
|
6.17 MB |
|
|
| 21 |
0302 Setting input masks |
|
1.76 MB |
|
|
| 22 |
0303 Setting validation rules |
|
2.84 MB |
|
|
| 04 Building Structure |
| 23 |
0401 Creating relationships and enforcing referential integrity |
|
3.84 MB |
|
|
| 24 |
0402 Viewing subdatasheets |
|
1.08 MB |
|
|
| 05 Formatting and Appearance |
| 25 |
0501 Entering data into your tables |
|
7.59 MB |
|
|
| 26 |
0502 Formatting tables |
|
5.33 MB |
|
|
| 27 |
0503 Finding, sorting, and filtering records |
|
7.15 MB |
|
|
| 06 Forms |
| 28 |
0601 Creating data-entry forms |
|
2.42 MB |
|
|
| 29 |
0602 Using the Form Wizard |
|
1.35 MB |
|
|
| 30 |
0603 Modifying a form in Layout view |
|
7.28 MB |
|
|
| 31 |
0604 Using Design view |
|
15.48 MB |
|
|
| 32 |
0605 Setting tab stops |
|
1.92 MB |
|
|
| 33 |
0606 Adding buttons to a form |
|
1.98 MB |
|
|
| 34 |
0607 Using navigation forms |
|
3.55 MB |
|
|
| 07 Queries |
| 35 |
0701 Introduction to queries |
|
1.27 MB |
|
|
| 36 |
0702 Using the Query Wizard |
|
1.89 MB |
|
|
| 37 |
0703 Creating a query in Design view with criteria |
|
3.63 MB |
|
|
| 38 |
0704 Creating wildcard queries |
|
1.16 MB |
|
|
| 39 |
0705 Creating reusable parameter queries |
|
1.32 MB |
|
|
| 40 |
0706 Creating yes no queries |
|
1.34 MB |
|
|
| 41 |
0707 Creating and and or queries |
|
2.62 MB |
|
|
| 42 |
0708 Building calculation queries |
|
2.44 MB |
|
|
| 43 |
0709 Creating statistical queries |
|
2.50 MB |
|
|
| 44 |
0710 Using update queries |
|
2.68 MB |
|
|
| 45 |
0711 Using delete queries |
|
1.87 MB |
|
|
| 46 |
0712 Creating crosstab queries |
|
1.94 MB |
|
|
| 08 Reports |
| 47 |
0801 Introduction to reports |
|
1.79 MB |
|
|
| 48 |
0802 Using the Report Wizard |
|
1.93 MB |
|
|
| 49 |
0803 Formatting reports in Layout view |
|
5.95 MB |
|
|
| 50 |
0804 Identifying report structure in Design view |
|
2.59 MB |
|
|
| 51 |
0805 Adding group and sort capabilities to a report |
|
2.79 MB |
|
|
| 52 |
0806 Adding existing fields from other tables |
|
2.24 MB |
|
|
| 53 |
0807 Adding totals and subtotals to a report |
|
3.57 MB |
|
|
| 54 |
0808 Adding conditional formatting and data bars to a report |
|
2.71 MB |
|
|
| 55 |
0809 Creating multi-table reports |
|
1.54 MB |
|
|
| 56 |
0810 Creating mailing labels |
|
2.39 MB |
|
|
| 57 |
0811 Printing reports |
|
1.31 MB |
|
|
| 09 Putting Data to Work |
| 58 |
0901 PivotTables |
|
2.50 MB |
|
|
| 59 |
0902 PivotCharts |
|
1.94 MB |
|
|
| 10 Automating with Macros |
| 60 |
1001 Creating macros |
|
2.50 MB |
|
|
| 61 |
1002 Attaching macros to objects |
|
2.21 MB |
|
|
| 62 |
1003 Using data macros |
|
2.09 MB |
|
|
| 11 Using Other Applications with Access |
| 63 |
1101 Importing Excel and text data |
|
3.95 MB |
|
|
| 64 |
1102 Exporting data into Excel |
|
1.34 MB |
|
|
| 65 |
1103 Exporting to PDF |
|
985.30 KB |
|
|
| 66 |
1104 Exporting into a Word Mail Merge |
|
919.05 KB |
|
|
| 67 |
1105 Publishing to a web browser in HTML or XML |
|
2.50 MB |
|
|
| 68 |
1106 Sharing via email |
|
975.78 KB |
|
|
| 69 |
1107 Collecting data over email |
|
2.97 MB |
|
|
| 70 |
1108 Using Package and Sign |
|
1.34 MB |
|
|
| 71 |
1109 Publishing to SharePoint |
|
2.79 MB |
|
|
| 72 |
1110 Importing and exporting with SharePoint |
|
778.64 KB |
|
|
| 12 Advanced Tools in the Database |
| 73 |
1201 Compacting and repairing a database |
|
1.01 MB |
|
|
| 74 |
1202 Using data analysis tools |
|
1.13 MB |
|
|
| 75 |
1203 Encrypting a database and setting a password |
|
2.38 MB |
|
|
| 76 |
1204 Splitting a database |
|
2.19 MB |
|
|
| 13 Customization |
| 77 |
1301 Customizing the ribbons |
|
1.38 MB |
|
|
| 78 |
1302 Setting Access options |
|
6.69 MB |
|
|
| 14 Conclusion |
| 79 |
1401 Goodbye |
|
144.19 KB |
|
|
| 15 ZZZ - فایلهای تمرینی |
| 80 |
Ex_Files_Access2010_EssT |
|
34.38 MB |
|
|
