|
1 Introduction to Computers and the Internet |
|
|
2 | (28) |
|
|
3 | (2) |
|
1-1a Primary Operations of a Computer |
|
|
|
1-1b Data vs. Information |
|
|
|
1-1c Hardware and Software |
|
|
|
1-1d Computer Users and Professionals |
|
|
|
|
5 | (7) |
|
|
|
|
|
1-2c Personal Computers (PCs) |
|
|
|
|
|
|
|
|
|
1-3 Computer Networks and the Internet |
|
|
12 | (6) |
|
1-3a The Internet and the World Web |
|
|
|
1-3b Accessing a Network or the Internet |
|
|
|
|
|
|
|
1-4 Computers and Society |
|
|
18 | (12) |
|
1-4a Benefits and Risks of a Computer-Oriented Society |
|
|
|
1-4b Understanding Intellectual Property Rights |
|
|
|
1-4c Computers and Health |
|
|
|
1-4d Environmental Concerns |
|
|
|
|
30 | (47) |
|
2-1 Digital Data Representation |
|
|
31 | (1) |
|
2-2 Inside the System Unit |
|
|
31 | (8) |
|
|
|
|
|
|
|
|
|
2-2e Expansion Slots, Expansion Cards, and ExpressCard Modules |
|
|
|
|
|
2-2g Ports and Connectors |
|
|
|
|
39 | (3) |
|
2-3a Typical CPU Components |
|
|
|
2-3b The System Clock and the Machine Cycle |
|
|
|
|
42 | (12) |
|
|
|
|
|
2-4c Flash Memory Storage Systems |
|
|
|
2-4d Network Storage and Online/Cloud Storage Systems |
|
|
|
|
|
2-4f Storage Systems for Large Computer Systems |
|
|
|
|
54 | (9) |
|
|
|
|
|
|
|
2-5d Scanners and Readers |
|
|
|
|
|
|
|
|
63 | (14) |
|
|
|
2-6b Data and Multimedia Projectors |
|
|
|
|
|
|
|
|
|
3-1 Introduction to System Software and Operating Systems |
|
|
77 | (6) |
|
3-1a Functions of the Operating System |
|
|
|
3-1b Processing Techniques for Increased Efficiency |
|
|
|
3-1c Differences Among Operating Systems |
|
|
|
3-2 Operating Systems for Personal Computers |
|
|
83 | (3) |
|
|
|
|
|
3-2c Windows Server and Windows Home Server |
|
|
|
3-2d Mac OS and Mac OS X Server |
|
|
|
|
|
|
|
3-3 Operating Systems for Mobile Devices and Larger Computers |
|
|
86 | (2) |
|
3-3a Mobile and Embedded Versions of Windows |
|
|
|
3-3b Other Mobile Phone Operating Systems |
|
|
|
3-3c Operating Systems for Larger Computers |
|
|
|
3-4 Introduction to Application Software |
|
|
88 | (5) |
|
|
|
3-4b Desktop vs. Mobile Software |
|
|
|
3-4c Installed vs. Web-Based Software |
|
|
|
3-5 Application Software for Business |
|
|
93 | (2) |
|
3-5a Word Processing Concepts |
|
|
|
3-5b Spreadsheet Concepts |
|
|
|
|
|
3-5d Presentation Graphics Concepts |
|
|
|
3-6 Application Software for Working with Multimedia |
|
|
95 | (4) |
|
|
|
3-6b Audio Capture and Editing Software |
|
|
|
3-6c Video Editing and DVD Authoring Software |
|
|
|
|
|
3-6e Graphics, Multimedia, and the Web |
|
|
|
3-7 Other Types of Application Software |
|
|
99 | (7) |
|
3-7a Desktop and Personal Publishing Software |
|
|
|
3-7b Educational, Entertainment, and Reference Software |
|
|
|
3-7c Note Taking Software and Web Notebooks |
|
|
|
3-7d CAD and Other Types of Design Software |
|
|
|
3-7e Accounting and Personal Finance Software |
|
|
|
3-7f Project Management, Collaboration, and Remote Access Software |
|
|
|
NETWORKS AND THE INTERNET |
|
|
|
|
106 | (32) |
|
|
107 | (1) |
|
4-2 Network Characteristics |
|
|
107 | (7) |
|
4-2a Wired vs. Wireless Networks |
|
|
|
|
|
4-2c Network Architectures |
|
|
|
4-2d Network Size and Coverage Area |
|
|
|
|
114 | (3) |
|
4-3b Analog vs. Digital Signals |
|
|
|
4-3c Transmission Type and Timing |
|
|
|
|
|
|
117 | (4) |
|
4-4a Wired Networking Media |
|
|
|
4-3b Wireless Networking Media |
|
|
|
4-5 Communications Protocols and Networking Standards |
|
|
121 | (9) |
|
4-5a TCP/IP and Other Communications Protocols |
|
|
|
|
|
4-5c Phoneline, Powerline, G.hn, and Broadband over Powerline (BPL) |
|
|
|
|
|
|
|
|
|
4-5g Bluetooth, Ultra Wideband (UWB), and Other Short-Range Wireless Standards |
|
|
|
|
130 | (8) |
|
4-6a Network Adapters and Modems |
|
|
|
4-6b Switches, Routers, and Other Hardware for Connecting Devices and Networks |
|
|
|
4-6c Other Networking Hardware |
|
|
|
5 Introducing the Internet and Email |
|
|
138 | (24) |
|
5-1 Evolution of the Internet |
|
|
139 | (3) |
|
5-1a From Arpanet to Internet2 |
|
|
|
|
|
|
|
5-1d The Internet Community Today |
|
|
|
5-2 Connecting to the Internet |
|
|
142 | (6) |
|
5-2a Selecting the Type of Device |
|
|
|
5-2b Choosing a Connection Type |
|
|
|
|
|
5-2d Setting Up Your Computers |
|
|
|
5-3 Searching the Internet for Information |
|
|
148 | (2) |
|
|
|
5-3b Citing Internet Resources |
|
|
|
|
150 | (2) |
|
|
|
|
|
5-5 Beyond Browsing and Email |
|
|
152 | (10) |
|
5-5a Online Written Communication |
|
|
|
5-5b Online Audio and Video Communications |
|
|
|
|
|
5-5d Online Entertainment |
|
|
|
|
|
5-5f Product, Corporate, Government, and Other Information |
|
|
|
6 Computer, Network, and Internet Security and Privacy |
|
|
162 | (34) |
|
6-1 Understanding Security Concerns |
|
|
163 | (1) |
|
6-2 Unauthorized Access and Unauthorized Use |
|
|
163 | (4) |
|
|
|
6-2b War Driving and Wi-Fi Piggybacking |
|
|
|
6-2c Interception of Communications |
|
|
|
6-2d Protecting Against Unauthorized Access and Unauthorized Use |
|
|
|
|
167 | (5) |
|
|
|
6-3b Computer Viruses and Other Types of Malware |
|
|
|
6-3c Denial of Service (DoS) Attacks |
|
|
|
6-3d Data, Program, or Web Site Alteration |
|
|
|
6-3e Protecting Against Computer Sabotage |
|
|
|
6-4 Online Theft, Online Fraud, and Other Dot Cons |
|
|
172 | (4) |
|
6-4a Theft of Data, Information, and Other Resources |
|
|
|
6-4b Identity Theft, Phishing, and Pharming |
|
|
|
6-4c Online Auction Fraud and Other Internet Scams |
|
|
|
6-4d Protecting Against Identity Theft and Online Threats |
|
|
|
6-5 Cyberstalking and Other Personal Safety Concerns |
|
|
176 | (2) |
|
6-5a Cyberbullying and Cyberstalking |
|
|
|
|
|
6-5c Protecting Personal Safety |
|
|
|
6-6 Personal Computer Security |
|
|
178 | (4) |
|
|
|
6-6b System Failure and Other Disasters |
|
|
|
6-6c Protecting Against Hardware Loss, Hardware Damage, and System Failure |
|
|
|
6-7 Understanding Privacy Concerns |
|
|
182 | (8) |
|
6-7a Databases, Electronic Profiling, Spam, and Other Marketing Activities |
|
|
|
6-7b Electronic Surveillance and Monitoring |
|
|
|
6-7c Protecting Personal Privacy |
|
|
|
6-8 Security and Privacy Legislation |
|
|
190 | (6) |
|
Capstone - Computer Concepts |
|
|
195 | (1) |
|
|
|
7 Exploring Windows 8 and Managing Files |
|
|
196 | (42) |
|
7-1 Using the Windows 8 Start Screen and Desktop |
|
|
197 | (10) |
|
|
8 | (199) |
|
7-1b Exploring the Start Screen |
|
|
|
7-1c Switching Between the Start Screen and the Desktop |
|
|
|
7-1d Exploring the Desktop |
|
|
|
7-1e Starting Apps and Applications |
|
|
|
7-2 Resizing and Moving Windows on the Desktop |
|
|
207 | (2) |
|
7-3 Switching Between Open Windows and Running Apps |
|
|
209 | (2) |
|
7-4 Working with the Windows 8 File System |
|
|
211 | (7) |
|
7-4a Opening a File Explorer Window |
|
|
|
7-4b Changing the View of File Explorer Windows |
|
|
|
7-4c Developing an Organizational Strategy |
|
|
|
7-4d Navigating to Folders |
|
|
|
|
218 | (10) |
|
7-5a Extracting Compressed Data Files |
|
|
|
7-5b Creating a Folder or Subfolder |
|
|
|
7-5c Moving or Copying Files and Folders |
|
|
|
7-5d Naming and Renaming Files and Folders |
|
|
|
7-5e Working with Compressed Folders |
|
|
|
7-6 Deleting Files and Working with the Recycle Bin |
|
|
228 | (1) |
|
7-6a Deleting Files and Folders |
|
|
|
7-6b Working with the Recycle Bin |
|
|
|
7-7 Closing Apps and Windows |
|
|
229 | (1) |
|
|
230 | (2) |
|
7-8a Opening Windows Help and Support |
|
|
|
7-8b Browsing Help Topics |
|
|
|
7-8c Using the Search Box |
|
|
|
7-9 Shutting Down Windows |
|
|
232 | (6) |
|
|
|
8 Using Internet Explorer and the Mail and People Apps |
|
|
238 | (38) |
|
8-1 Browsing the Web with Internet Explorer |
|
|
239 | (5) |
|
8-1a Starting the Internet Explorer App and Navigating to Web Pages |
|
|
|
8-1b Visiting Previously Viewed Web Pages |
|
|
|
8-1c Accessing a Search Site from the Address Bar |
|
|
|
8-2 Using the Internet Explorer Desktop Application |
|
|
244 | (3) |
|
|
247 | (3) |
|
8-3a Using Tabs in the Internet Explorer Desktop Application |
|
|
|
8-3b Using Tabs in the Internet Explorer App |
|
|
|
8-4 Personalizing Internet Explorer |
|
|
250 | (6) |
|
|
|
8-4b Saving Web Pages as Favorites |
|
|
|
8-4c Using Internet Explorer History |
|
|
|
|
256 | (3) |
|
8-6 Closing Internet Explorer |
|
|
259 | (1) |
|
|
260 | (9) |
|
|
|
8-7b Creating and Sending Email Using Mail |
|
|
|
8-7c Receiving and Reading Email Using Mail |
|
|
|
8-7d Replying to and Forwarding Email Messages |
|
|
|
8-7e Deleting Email Messages |
|
|
|
8-7f Working with Attachments |
|
|
|
|
|
8-8 Adding Information to the People App |
|
|
269 | (7) |
|
|
|
9 Introducing Microsoft Office 2013 |
|
|
276 | (34) |
|
9-1 Exploring Common Elements of Office Application Windows |
|
|
277 | (3) |
|
|
280 | (11) |
|
9-2a Switching Tabs and Displaying Contextual Tabs |
|
|
|
|
|
9-2c Using Galleries and Live Preview |
|
|
|
9-2d Using Commands in Dialog Boxes |
|
|
|
9-2e Open and Close Task Panes |
|
|
|
9-2f Exploring Backstage View |
|
|
|
9-3 Selecting Text and Using the Mini Toolbar |
|
|
291 | (1) |
|
|
|
9-3b Using the Mini Toolbar |
|
|
|
|
292 | (1) |
|
9-5 Zooming and Scrolling |
|
|
293 | (2) |
|
|
|
|
|
9-6 Working with Office Files |
|
|
295 | (3) |
|
9-6a Saving a File for the First Time |
|
|
|
9-6b Saving a File after Making Changes |
|
|
|
|
|
|
|
|
298 | (3) |
|
9-7a Using the System Clipboard |
|
|
|
9-7b Using the Office Clipboard |
|
|
|
|
301 | (1) |
|
9-9 Closing Office Applications |
|
|
302 | (8) |
|
Capstone ? Windows 8 and Office 2013: Organize Your Files |
|
|
307 | (1) |
|
Web Applications: Saving a File to SkyDrive |
|
|
308 | (2) |
|
|
|
|
310 | (38) |
|
|
311 | (7) |
|
|
|
10-1b Inserting a Date with AutoComplete |
|
|
|
10-1c Correcting Errors as You Type |
|
|
|
|
|
10-2 Creating Documents Based on Existing Documents |
|
|
318 | (1) |
|
|
319 | (2) |
|
10-3a Replacing Selected Text |
|
|
|
10-3b Using Drag and Drop |
|
|
|
10-4 Switching to Another Open Document in Word |
|
|
321 | (1) |
|
|
321 | (3) |
|
10-5a Changing the Font and Font Size |
|
|
|
10-5b Changing Font Styles |
|
|
|
10-5c Changing Text Color |
|
|
|
10-6 Formatting Paragraphs |
|
|
324 | (11) |
|
10-6a Adjusting Paragraph Spacing |
|
|
|
10-6b Adjusting Line Spacing |
|
|
|
10-6c Aligning Paragraphs |
|
|
|
|
|
10-6e Creating a Bulleted List |
|
|
|
10-6f Creating a Numbered List |
|
|
|
10-6g Indenting a Paragraph |
|
|
|
10-6h Adding a Paragraph Border |
|
|
|
10-6i Adding Paragraph Shading |
|
|
|
|
335 | (3) |
|
10-7a Using the Format Painter |
|
|
|
10-7b Using Paste Options |
|
|
|
10-8 Checking Spelling and Grammar |
|
|
338 | (4) |
|
10-8a Checking Flagged Words Individually |
|
|
|
10-8b Checking the Spelling and Grammar in the Entire Document |
|
|
|
10-9 Previewing and Printing Documents |
|
|
342 | (6) |
|
11 Formatting a Long Document |
|
|
348 | (38) |
|
11-1 Finding and Replacing Text |
|
|
349 | (2) |
|
|
|
11-1b Replacing Specific Text |
|
|
|
|
351 | (6) |
|
11-2a Applying a Quick Style |
|
|
|
11-2b Modifying a Quick Style |
|
|
|
11-2c Creating a New Quick Style |
|
|
|
|
357 | (5) |
|
|
|
11-3b Changing the Style Set |
|
|
|
|
|
11-4 Scrolling Through a Long Document |
|
|
362 | (1) |
|
11-5 Working with the Document Outline |
|
|
363 | (3) |
|
11-5a Using the Navigation Pane |
|
|
|
|
|
11-6 Changing the Margins |
|
|
366 | (2) |
|
11-7 Inserting a Manual Page Break |
|
|
368 | (1) |
|
11-8 Adding Page Numbers, Headers, and Footers |
|
|
369 | (4) |
|
11-8a Inserting Page Numbers |
|
|
|
11-8b Adding a Header and Footer |
|
|
|
11-9 Creating Citations and a List of Works Cited |
|
|
373 | (7) |
|
11-9a Creating a New Source and Inserting a Citation |
|
|
|
11-9b Inserting a Citation to an Existing Source |
|
|
|
11-9c Using the Source Manager |
|
|
|
|
|
11-9e Generating a List of Works Cited |
|
|
|
|
|
11-9g Updating the List of Works Cited |
|
|
|
11-10 Creating Footnotes and Endnotes |
|
|
380 | (6) |
|
|
386 | (36) |
|
12-1 Organizing Information in Tables |
|
|
387 | (7) |
|
|
|
12-1b Entering Data in a Table |
|
|
|
12-1c Selecting Parts of a Table |
|
|
|
12-1d Inserting a Row or Column |
|
|
|
12-1e Deleting a Row, Column, or Table |
|
|
|
12-1f Changing Column Widths |
|
|
|
12-1g Formatting Tables with Table Style |
|
|
|
12-1h Aligning Tables and Text in Tables |
|
|
|
12-2 Changing the Page Orientation |
|
|
394 | (1) |
|
12-3 Dividing a Document into Sections |
|
|
394 | (4) |
|
12-3a Inserting a Section Break |
|
|
|
12-3b Formatting a Section Differently from the Rest of the Document |
|
|
|
12-3c Adding Different Headers and Footers in Sections |
|
|
|
12-4 Inserting and Modifying Graphics |
|
|
398 | (5) |
|
12-4a Inserting Online Pictures |
|
|
|
12-4b Examining a Selected Object |
|
|
|
|
|
|
|
12-4e Formatting a Picture |
|
|
|
12-5 Wrapping Text Around Graphics |
|
|
403 | (1) |
|
|
404 | (1) |
|
12-7 Adding Text Effects and WordArt Text Boxes |
|
|
405 | (4) |
|
12-7a Applying Text Effects |
|
|
|
12-7b Inserting WordArt Text Boxes |
|
|
|
12-8 Working with Columns |
|
|
409 | (2) |
|
|
|
|
|
12-9 Working with Building Blocks |
|
|
411 | (11) |
|
12-9a Creating Quick Parts |
|
|
|
12-9b Inserting Quick Parts |
|
|
|
12-9c Managing Building Blocks Capstone - Word: Create a Flyer |
|
|
419 | (1) |
|
Web Applications: Using the Word Web App |
|
|
420 | (2) |
|
|
|
|
422 | (32) |
|
13-1 Understanding Spreadsheets and Excel |
|
|
423 | (5) |
|
13-1a Parts of the Excel Window |
|
|
|
13-1b Moving the Active Cell |
|
|
|
13-1c Inserting and Deleting a Sheet |
|
|
|
13-1d Switching Between Sheets |
|
|
|
|
|
13-1f Moving and Copying a Sheet |
|
|
|
13-2 Entering and Formatting Data |
|
|
428 | (5) |
|
|
|
|
|
|
|
|
|
|
|
|
|
13-3 Editing Cell Content |
|
|
433 | (1) |
|
13-4 Working with Columns and Rows |
|
|
434 | (3) |
|
13-4a Selecting Columns and Rows |
|
|
|
13-4b Changing Column Widths and Row Heights |
|
|
|
13-4c Inserting a Column or Row |
|
|
|
13-4d Clearing or Deleting a Row or Column |
|
|
|
13-5 Working with Cells and Ranges |
|
|
437 | (3) |
|
|
|
13-5b Moving and Copying a Cell or Range |
|
|
|
13-5c Inserting and Deleting a Cell or Range |
|
|
|
13-5d Wrapping Text Within a Cell |
|
|
|
13-6 Entering Simple Formulas and Functions |
|
|
440 | (6) |
|
|
|
13-6b Copying and Pasting Formulas |
|
|
|
13-6c Entering a Function |
|
|
|
|
|
13-7 Previewing and Printing a Workbook |
|
|
446 | (8) |
|
13-7a Changing Worksheet Views |
|
|
|
13-7b Changing the Orientation |
|
|
|
13-7c Previewing and Printing a Workbook |
|
|
|
14 Working with Formulas and Functions |
|
|
454 | (38) |
|
14-1 Using Relative, Absolute, and Mixed Cell References in Formulas |
|
|
455 | (6) |
|
14-1a Using Relative References |
|
|
|
14-1b Using Absolute References |
|
|
|
14-1c Using Mixed References |
|
|
|
|
461 | (6) |
|
14-2a Inserting a Function Using the Insert Function Dialog Box |
|
|
|
14-2b Typing a Function in a Cell |
|
|
|
14-2c Editing Data Used in a Formula |
|
|
|
|
467 | (4) |
|
14-3a Using the Fill Handle to Copy Cell Contents |
|
|
|
|
|
14-4 Working with Date Functions |
|
|
471 | (1) |
|
14-5 Working with the PMT Financial Function |
|
|
472 | (5) |
|
14-5a Understanding Loan Factors |
|
|
|
14-5b Entering the PMT Function |
|
|
|
14-5c Performing What-lf Analysis |
|
|
|
14-6 Formatting Cells and Ranges |
|
|
477 | (15) |
|
14-6a Using the Format Cells Dialog Box |
|
|
|
14-6b Applying Cell Styles |
|
|
|
14-6c Aligning Cell Content |
|
|
|
14-6d Indenting Cell Content |
|
|
|
|
|
14-6f Adding Cell Borders |
|
|
|
14-6g Changing Cell Background Color |
|
|
|
15 Creating an Advanced Workbook |
|
|
492 | (28) |
|
15-1 Making a Workbook User-Friendly |
|
|
493 | (1) |
|
|
493 | (2) |
|
15-3 Entering Formulas with Multiple Calculations |
|
|
495 | (2) |
|
|
497 | (3) |
|
15-5 Working with the IF Logical Function |
|
|
500 | (2) |
|
15-6 Creating a Nested Function |
|
|
502 | (2) |
|
15-7 Highlighting Cells with Conditional Formatting |
|
|
504 | (4) |
|
15-7a Highlighting a Cell Based on Its Value |
|
|
|
15-7b Clearing a Conditional Formatting Rule |
|
|
|
15-8 Hiding Rows and Columns |
|
|
508 | (1) |
|
15-9 Formatting a Worksheet for Printing |
|
|
509 | (11) |
|
15-9a Inserting and Removing Page Breaks |
|
|
|
15-9b Setting the Print Area |
|
|
|
15-9c Adding Print Titles |
|
|
|
15-9d Creating Headers and Footers |
|
|
|
15-9e Setting the Page Margins |
|
|
|
16 Inserting and Formatting Charts |
|
|
520 | (36) |
|
|
521 | (4) |
|
16-1a Selecting a Data Source |
|
|
|
16-1b Selecting a Chart Type |
|
|
|
16-1c Inserting a Pie Chart |
|
|
|
16-1d Selecting Chart Elements |
|
|
|
16-2 Moving and Resizing a Chart |
|
|
525 | (2) |
|
16-2a Moving a Chart to a Different Sheet |
|
|
|
16-2b Repositioning and Resizing a Chart |
|
|
|
|
527 | (6) |
|
16-3a Changing the Chart Style |
|
|
|
16-3b Changing a Chart Layout |
|
|
|
16-3c Positioning and Formatting a Chart Title |
|
|
|
16-3d Positioning the Chart Legend |
|
|
|
16-3e Working with Data Labels |
|
|
|
16-3f Changing the Color of a Data Series |
|
|
|
16-4 Creating an Exploded Pie Chart |
|
|
533 | (1) |
|
16-5 Creating a Column or Bar Chart |
|
|
533 | (5) |
|
16-5a Inserting a Column Chart |
|
|
|
16-5b Formatting a Column Chart |
|
|
|
16-5c Changing the Axis Scale |
|
|
|
16-6 Creating a Line Chart |
|
|
538 | (5) |
|
16-6a Inserting and Formatting a Line Chart |
|
|
|
16-6b Editing the Axis Scale and Labels in a Line Chart |
|
|
|
16-6c Adding and Formatting an Axis Title |
|
|
|
|
|
|
543 | (2) |
|
16-7a Changing a Data Value or Label |
|
|
|
16-7b Adding a Data Series to an Existing Chart |
|
|
|
16-7c Modifying Lines and Data Markers |
|
|
|
16-8 Inserting and Formatting Sparklines |
|
|
545 | (2) |
|
16-9 Inserting and Modifying Data Bars |
|
|
547 | (9) |
|
Capstone - Excel: Create a Budget |
|
|
553 | (1) |
|
Web Applications: Working with the Excel Web App |
|
|
554 | (2) |
|
|
|
|
556 | (34) |
|
17-1 Understanding Database Concepts |
|
|
557 | (1) |
|
|
558 | (2) |
|
17-3 Working in Datasheet View |
|
|
560 | (5) |
|
17-3a Creating a Table in Datasheet View |
|
|
|
|
|
|
|
17-4 Working with Fields and Properties in Design View |
|
|
565 | (7) |
|
17-4a Changing Field Properties in Design View |
|
|
|
17-4b Creating a Table and Setting Properties in Design View |
|
|
|
17-4c Specifying the Primary Key |
|
|
|
17-4d Saving the Table Design and Entering Records |
|
|
|
17-5 Modifying a Table's Structure |
|
|
572 | (3) |
|
17-5a Moving a Field in Design View |
|
|
|
|
|
|
|
17-6 Closing and Opening Objects and Databases |
|
|
575 | (2) |
|
|
|
|
|
|
|
|
|
17-6e Moving Around a Datasheet |
|
|
|
17-7 Creating Simple Queries, Forms, and Reports |
|
|
577 | (7) |
|
17-7a Creating a Simple Query |
|
|
|
17-7b Creating a Simple Form |
|
|
|
17-7c Entering Data in a Form |
|
|
|
17-7d Creating a Simple Report |
|
|
|
17-7e Formatting a Report |
|
|
|
17-7f Viewing a Report In Print Preview |
|
|
|
|
|
17-8 Compacting and Repairing a Database |
|
|
584 | (6) |
|
18 Maintaining and Querying a Database |
|
|
590 | (30) |
|
18-1 Maintaining Database Records |
|
|
591 | (1) |
|
18-1a Editing Field Values |
|
|
|
18-1b Finding and Replacing Data |
|
|
|
|
|
18-2 Working with Queries in Design View |
|
|
592 | (4) |
|
18-2a Designing a Select Query |
|
|
|
|
|
18-3 Sorting and Filtering Data |
|
|
596 | (4) |
|
18-3a Sorting in Datasheet View |
|
|
|
18-3b Sorting Multiple Fields in Design View |
|
|
|
|
|
18-4 Defining Table Relationships |
|
|
600 | (4) |
|
18-4a Defining a One-to-Many Relationship Between Tables |
|
|
|
18-4b Working with Related Data in a Subdatasheet |
|
|
|
18-5 Creating a Multitable Query |
|
|
604 | (1) |
|
18-6 Adding Criteria to a Query |
|
|
605 | (2) |
|
18-7 Creating a Copy of a Query |
|
|
607 | (1) |
|
18-8 Adding Multiple Criteria to Queries |
|
|
608 | (2) |
|
18-8a Using the And Logical Operator |
|
|
|
18-8b Using the Or Logical Operator |
|
|
|
18-9 Creating a Calculated Field |
|
|
610 | (2) |
|
18-10 Using a Property Sheet |
|
|
612 | (1) |
|
18-11 Using Functions in a Query |
|
|
613 | (7) |
|
18-11a Using the Total Row in a Datasheet |
|
|
|
18-11b Creating Queries with Functions |
|
|
|
18-11c Creating Calculations for Groups of Records |
|
|
|
19 Creating Forms and Reports |
|
|
620 | (26) |
|
19-1 Creating a Form Using the Form Wizard |
|
|
621 | (1) |
|
19-2 Modifying a Form's Design in Layout View |
|
|
622 | (4) |
|
19-2a Applying a Theme to a Form |
|
|
|
19-2b Changing the Form Title's Text and Appearance |
|
|
|
19-2c Adding a Logo to a Form |
|
|
|
19-2d Changing the Lines in a Form |
|
|
|
19-3 Finding Data Using a Form |
|
|
626 | (3) |
|
19-3a Searching for a Partial Value |
|
|
|
19-3b Searching with Wildcards |
|
|
|
19-3c Maintaining Table Data Using a Form |
|
|
|
19-4 Creating a Form Based on Related Tables |
|
|
629 | (3) |
|
19-4a Creating a Form with a Main Form and a Subform |
|
|
|
19-4b Modifying a Main Form and Subform in Layout View |
|
|
|
19-4c Displaying Records in a Main Form and a Subform |
|
|
|
19-5 Previewing and Printing Selected Form Records |
|
|
632 | (1) |
|
19-6 Creating a Report Using the Report Wizard |
|
|
633 | (3) |
|
|
|
19-6b Previewing a Report |
|
|
|
19-7 Modifying a Report's Design in Layout View |
|
|
636 | (10) |
|
19-7a Changing a Report's Appearance |
|
|
|
19-7b Resizing Fields and Field Values in a Report |
|
|
|
19-7c Using Conditional Formatting in a Report |
|
|
|
|
|
Capstone - Access: Create a Database |
|
|
645 | (1) |
|
|
|
20 Creating a Presentation |
|
|
646 | (36) |
|
20-1 Creating a Presentation |
|
|
647 | (10) |
|
20-1a Creating a Title Slide |
|
|
|
20-1b Adding a New Slide and Choosing a Layout |
|
|
|
20-1c Moving Between Slides in Normal View |
|
|
|
|
|
|
|
|
|
20-1g Modifying Text and Changing Bullet Levels in Outline View |
|
|
|
20-2 Rearranging Text and Slides, and Deleting Slides |
|
|
657 | (3) |
|
20-2a Moving Bulleted Items |
|
|
|
|
|
|
|
20-3 Adding Speaker Notes |
|
|
660 | (1) |
|
20-4 Running a Slide Show |
|
|
661 | (3) |
|
20-4a Using Slide Show View |
|
|
|
20-4b Using Presenter View |
|
|
|
|
664 | (4) |
|
20-5a Animating a Text Box |
|
|
|
20-5b Animating Bulleted Lists |
|
|
|
20-5c Changing Animation Effects |
|
|
|
20-5d Using the Animation Painter |
|
|
|
20-5e Removing an Animation |
|
|
|
|
668 | (2) |
|
20-7 Adding Footers and Headers |
|
|
670 | (2) |
|
20-7a Inserting Footers, Slide Numbers, and the Date on Slides |
|
|
|
20-7b Inserting Headers and Footers on Notes Pages and Handouts |
|
|
|
20-8 Reviewing, Previewing, and Printing a Presentation |
|
|
672 | (10) |
|
20-8a Checking and Reviewing a Presentation |
|
|
|
20-8b Displaying the Print Screen |
|
|
|
20-8c Printing Full Page Slides |
|
|
|
|
|
20-8e Printing Notes Pages |
|
|
|
20-8f Printing the Presentation as an Outline |
|
|
|
21 Enhancing a Presentation |
|
|
682 | (38) |
|
21-1 Working with Slide Masters |
|
|
683 | (7) |
|
21-1a Working in Slide Master View |
|
|
|
21-1b Modifying Text Placeholders in the Slide Master |
|
|
|
21-1c Deleting a Graphic from the Slide Master |
|
|
|
21-1d Modifying the Slide Background |
|
|
|
21-1e Closing Slide Master View |
|
|
|
|
690 | (6) |
|
21-2a Inserting a Picture File |
|
|
|
|
|
21-2c Adding Text to a Shape |
|
|
|
21-2d Formatting Graphics |
|
|
|
21-3 Creating SmartArt Diagrams |
|
|
696 | (4) |
|
21-3a Creating a SmartArt Diagram |
|
|
|
21-3b Modifying a SmartArt Diagram |
|
|
|
21-3c Formatting a SmartArt Diagram |
|
|
|
21-4 Applying Animations to Graphics |
|
|
700 | (1) |
|
21-5 Modifying Animation Timings |
|
|
700 | (3) |
|
21-5a Modifying the Order of Animations |
|
|
|
21-5b Modifying the Start Timing of an Animation |
|
|
|
21-5c Changing the Speed of Animations |
|
|
|
|
703 | (5) |
|
21-6a Inserting a Video on a Slide |
|
|
|
|
|
|
|
21-6d Changing Video Playback Options |
|
|
|
21-6e Setting a Poster Frame |
|
|
|
21-7 Compressing Pictures and Media |
|
|
708 | (1) |
|
|
709 | (11) |
|
Capstone - PowerPoint: Prepare a Presentation |
|
|
717 | (1) |
|
Web Applications: Working with the PowerPoint Web App |
|
|
718 | (2) |
|
|
|
22 Integrating Word, Excel, Access, and PowerPoint |
|
|
720 | (30) |
|
22-1 Object Linking and Embedding |
|
|
721 | (11) |
|
22-1a Creating an Embedded Excel Chart in Word or PowerPoint |
|
|
|
22.1b Embedding a chart Created in an Excel Worksheet in Word or PowerPoint |
|
|
|
22-1c Editing an Embedded Excel Chart in Word or PowerPoint |
|
|
|
22-1d Linking an Excel Chart to a Word Document or PowerPoint Presentation |
|
|
|
22-1e Linking Excel Worksheet Data to Word or PowerPoint |
|
|
|
22-1f Updating Linked Objects When the Destination File is Open |
|
|
|
22.1g Updating Linked Objects When the Destination File Is Closed |
|
|
|
22-2 Importing and Exporting Data |
|
|
732 | (3) |
|
22-2a Importing an Excel List into an Access Table |
|
|
|
22-2b Exporting Access Data to a Word File |
|
|
|
22-3 Using the Object Command in Word, Excel, and PowerPoint |
|
|
735 | (1) |
|
22-4 Copying and Pasting Among Office Programs |
|
|
736 | (1) |
|
22-5 Creating PowerPoint Slides from a Word Outline |
|
|
737 | (1) |
|
22-6 Creating Form Letters with Mail Merge |
|
|
738 | (12) |
|
22-6a Selecting a Main Document and Data Source |
|
|
|
22-6b Inserting the Merge Fields |
|
|
|
22-6c Previewing the Mail Merge and Checking for Errors |
|
|
|
22-6d Finishing the Mail Merge |
|
|
Index |
|
750 | |