Muutke küpsiste eelistusi

GO! with Microsoft Office 365, Access 2019 Comprehensive [Spiraalköide]

, , ,
  • Formaat: Spiral bound, 800 pages, kaal: 1540 g
  • Ilmumisaeg: 18-Mar-2019
  • Kirjastus: Pearson
  • ISBN-10: 0135442044
  • ISBN-13: 9780135442043
Teised raamatud teemal:
GO! with Microsoft Office 365, Access 2019 ComprehensiveSuurem pilt
  • Formaat: Spiral bound, 800 pages, kaal: 1540 g
  • Ilmumisaeg: 18-Mar-2019
  • Kirjastus: Pearson
  • ISBN-10: 0135442044
  • ISBN-13: 9780135442043
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780135442043.html
Märksõnad:

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative.

For introductory courses in Microsoft® Access™.

Seamless digital instruction, practice, and assessment
For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they’re needed. Updated to Office 365, GO! with Microsoft® Office 365®, Access 2019 Comprehensive adds revised instructional projects and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
MyLab™ is the teaching and learning platform that empowers you to reach every student. By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek. Learn more about MyLab IT.

Microsoft Office and Windows 10 1(1)
Chapter 1 Microsoft Office Features And Windows 10 File Management
1(100)
Project 1A Chef Notes
2(5)
Objective 1 Explore Microsoft Office
3(1)
Activity 1.01 Exploring Microsoft Office
4(2)
Objective 2 Create a Folder for File Storage
6(1)
Activity 1.02 Creating a Folder for File Storage
7(1)
More Knowledge Creating a Microsoft Account
7(18)
Objective 3 Download and Extract Zipped Files, Enter and Edit Text in an Office Application, and Use Editor to Check Documents
10(1)
Activity 1.03 Downloading and Extracting Zipped Files from MyLab IT and Entering and Editing Text in an Office Program
11(3)
Activity 1.04 Checking Spelling
14(1)
Objective 4 Perform Office Commands and Apply Office Formatting
15(1)
Activity 1.05 Performing Commands from a Dialog Box
15(3)
Activity 1.06 Using Undo and Applying Text Effects
18(1)
Activity 1.07 Performing Commands from and Customizing the Quick Access Toolbar
19(2)
Activity 1.08 Performing Commands from the Ribbon
21(4)
Activity 1.09 Minimizing the Ribbon
25(1)
More Knowledge Displaying Key Tips
25(1)
Activity 1.10 Changing Page Orientation and Zoom Level
25(1)
More Knowledge Zooming to Page Width
26(15)
Activity 1.11 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles
27(3)
Activity 1.12 Using Format Painter
30(2)
Activity 1.13 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste
32(4)
Activity 1.14 Adding Alternative Text for Accessibility
36(1)
Objective 5 Finalize an Office Document
37(1)
Activity 1.15 Inserting a Footer, Inserting Document Info, and Adding Document Properties
37(1)
Activity 1.16 Inspecting a Document
38(1)
Activity 1.17 Inserting a Bookmark and a 3D Model
39(1)
Activity 1.18 Printing a File and Closing a Desktop App
40(1)
More Knowledge Creating an Electronic Image of Your Document
41(3)
Objective 6 Use the Office Help Features
41(1)
Activity 1.19 Using Microsoft Office Tell Me, Tell Me More, the Help Tab, and Adding Alt Text to an Excel Chart
41(3)
More Knowledge Don't Type, Talk! With the New Dictate Feature
44(1)
Project 1B Hotel Files
45(14)
Objective 7 Explore Windows 10
46(1)
Activity 1.20 Recognizing User Accounts in Windows 10
47(2)
Activity 1.21 Turning On Your Computer, Signing In, and Exploring the Windows 10 Environment
49(4)
Activity 1.22 Pinning a Program to the Taskbar
53(1)
Objective 8 Prepare to Work with Folders and Files
54(1)
Activity 1.23 Creating a New Folder to Store a File
54(5)
More Knowledge Use OneDrive as Cloud Storage
59(1)
Activity 1.24 Creating and Saving a File
59(1)
More Knowledge Jump to a Lettered Section of the Apps List Quickly
60(5)
More Knowledge The Hamburger Icon
65(18)
Activity 1.25 Downloading and Extracting Zipped Files
65(1)
Activity 1.26 Locating and Inserting a Saved File Into a PowerPoint Presentation
66(1)
Activity 1.27 Using Snap and Task View
66(4)
Objective 9 Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files
70(1)
Activity 1.28 Navigating with File Explorer
71(2)
Activity 1.29 Using File Explorer to Extract Zipped Files
73(1)
Activity 1.30 Using File Explorer to Display Locations, Folders, and Files
74(4)
Objective 10 Start Programs and Open Data Files
78(1)
Activity 1.31 Starting Programs
78(2)
Activity 1.32 Opening Data Files
80(3)
More Knowledge Do Not Clutter Your Desktop by Creating Desktop Shortcuts or Storing Files
83(8)
Activity 1.33 Searching, Pinning, Sorting, and Filtering in File Explorer
84(1)
Objective 11 Create, Rename, and Copy Files and Folders
85(1)
Activity 1.34 Copying Files from a Removable Storage Device to the Documents Folder on the Hard Disk Drive
85(2)
Activity 1.35 Creating Folders, Renaming Folders, and Renaming Files
87(2)
Activity 1.36 Copying Files
89(1)
Activity 1.37 Moving Files
90(1)
More Knowledge Using Shift + Click to Select Files
91(3)
Activity 1.38 Copying and Moving Files by Snapping Two Windows
92(2)
More Knowledge Deleting Files and Using the Recycle Bin
94(1)
Go! To Work
95(1)
End of
Chapter
96(5)
Summary GOI Learn It Online
96(1)
Glossary
97(4)
Access 2019
101(2)
Chapter 1 Getting Started With Microsoft Access 2019
103(1)
Project 1A Student Advising Database with Two Tables
104(1)
Objective 1 Identify Good Database Design
105(1)
Activity 1.01 Using Good Design Techniques to Plan a Database
105(1)
Objective 2 Create a Table and Define Fields in a Blank Desktop Database
106(1)
Activity 1.02 Starting with a Blank Database
107(2)
Activity 1.03 Assigning the Data Type and Name to Fields
109(2)
More Knowledge Create Fields by Entering Data
111(3)
Activity 1.04 Renaming Fields, Changing Data Types, and Setting Field Size in a Table
111(1)
Activity 1.05 Adding a Record to a Table
112(2)
More Knowledge Renaming or Deleting a Table
114(6)
Activity 1.06 Adding Additional Records to a Table
114(1)
Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table
114(3)
Objective 3 Change the Structure of Tables and Add a Second Table
117(1)
Activity 1.08 Deleting a Table Field in Design View
117(2)
Activity 1.09 Adding Field Descriptions and Changing Field Size
119(1)
More Knowledge Add a Table Description
120(18)
Activity 1.10 Viewing the Primary Key in Design View
120(1)
Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet
121(3)
Activity 1.12 Adjusting Column Widths and Viewing a Table in Print Preview
124(2)
Activity 1.13 Viewing a Table in Print Preview
126(3)
Objective 4 Create a Query, Form, and Report
129(1)
Activity 1.14 Creating a Query by Using the Simple Query Wizard
129(3)
Activity 1.15 Creating a Form
132(2)
Activity 1.16 Creating and Modifying a Report
134(3)
Objective 5 Close a Database and Close Access
137(1)
Activity 1.17 Closing a Database and Closing Access
137(1)
Go! With Google
138(3)
Objective Export an Access Table to an Excel Spreadsheet, Open as a Google Sheet, Edit a Record, and Save to Your Computer
138(3)
Project 1B Student Workshops Database
141(8)
Objective 6 Use a Template to Create a Database
142(1)
Activity 1.18 Using a Template to Create a Database
142(1)
Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form
143(2)
Activity 1.20 Appending Records by Importing from an Excel Spreadsheet
145(1)
Objective 7 Organize Objects in the Navigation Pane
146(1)
Activity 1.21 Grouping Database Objects in the Navigation Pane
146(2)
Objective 8 Create a New Table in a Database Created with a Template
148(1)
Activity 1.22 Using the Table Tool to Create a New Table
148(1)
More Knowledge Create a Table from a Template with Application Parts
149(3)
Activity 1.23 Entering Records Into a New Table
149(2)
Objective 9 View a Report
151(1)
Activity 1.24 Viewing a Report
151(1)
Go! With Google
152(2)
Objective Export an Access Table to a Word Document, Save to Google Drive, Add a Record, and Save to Your Computer
152(2)
Go! To Work
154(1)
End of
Chapter
155(24)
Summary GO! Learn It Online GO! Collaborative Team Project
155(1)
Project Guide for Access
Chapter 1
156(1)
Glossary
157(2)
Chapter Review
159(7)
Mastering Access
166(10)
Rubric
176(1)
GO! Think
177(2)
Chapter 2 Sort And Query A Database
179(76)
Project 2A Instructors and Courses
180(6)
Objective 1 Open and Save an Existing Database
181(1)
Activity 2.01 Opening an Existing Database and Resolving Security Alerts
181(1)
Objective 2 Create Table Relationships
182(1)
Activity 2.02 Selecting the Tables and Common Field to Establish the Table Relationship
182(3)
Activity 2.03 Setting Relationship Options
185(1)
More Knowledge Edit or Delete a Relationship
186(2)
Activity 2.04 Saving a Relationship Report
187(1)
Activity 2.05 Displaying Subdatasheet Records
187(1)
More Knowledge Other Types of Relationships: One-to-One and Many-to-Many
188(8)
Activity 2.06 Testing Cascade Options
188(2)
Objective 3 Sort Records in a Table
190(1)
Activity 2.07 Sorting Records in a Table in Ascending or Descending Order
190(1)
Activity 2.08 Sorting Records in a Table on Multiple Fields
191(1)
Objective 4 Create a Query in Design View
192(1)
Activity 2.09 Creating a New Select Query in Design View
193(1)
Activity 2.10 Running, Saving, and Closing a Query
194(1)
Objective 5 Create a New Query From an Existing Query
195(1)
Activity 2.11 Copying an Existing Query
196(1)
More Knowledge Rename a Query
196(3)
Activity 2.12 Modifying the Design of a Query
196(2)
Objective 6 Sort Query Results
198(1)
Activity 2.13 Sorting Query Results
198(1)
More Knowledge Sorting in Design View or Datasheet View
199(5)
Objective 7 Specify Criteria in a Query
199(1)
Activity 2.14 Specifying Text Criteria in a Query
199(2)
Activity 2.15 Specifying Criteria and Hiding the Field in the Query Results
201(1)
Activity 2.16 Using Is Null Criteria to Find Empty Fields
202(2)
Go! With Google
204(2)
Objective Export a Relationship Report to a PDF File, Save the PDF File to Google Drive, and then Share the File
204(2)
Project 2B Athletic Scholarships Database
206(11)
Objective 8 Specify Numeric Criteria in a Query
207(1)
Activity 2.17 Opening an Existing Database and Importing a Spreadsheet as a New Table
207(1)
Activity 2.18 Creating a One-to-Many Table Relationship
208(2)
Activity 2.19 Specifying Numeric Criteria in a Query
210(1)
Activity 2.20 Using Comparison Operators in Criteria
210(1)
Activity 2.21 Using the Between And Comparison Operator
211(1)
Objective 9 Use Compound Criteria in a Query
212(1)
Activity 2.22 Using AND Criteria in a Query
212(1)
Activity 2.23 Using OR Criteria in a Query
213(1)
Objective 10 Create a Query Based on More Than One Table
214(1)
Activity 2.24 Creating a Query Based on More Than One Table
214(2)
Objective 11 Use Wildcards in a Query
216(1)
Activity 2.25 Using a Wildcard in a Query
216(1)
More Knowledge Using the Wildcard Character to Search for a Single Unknown Character
217(8)
Objective 12 Create Calculated Fields in a Query
218(1)
Activity 2.26 Creating a Calculated Field in a Query
218(1)
Activity 2.27 Creating a Second Calculated Field in a Query
219(1)
Activity 2.28 Formatting Calculated Fields
220(1)
Objective 13 Calculate Statistics and Group Data in a Query
221(1)
Activity 2.29 Using the Min, Max, Avg, and Sum Functions in a Query
221(1)
Activity 2.30 Grouping Records in a Query
222(1)
Objective 14 Create a Crosstab Query
223(1)
Activity 2.31 Creating a Crosstab Query Using the Query Wizard
223(2)
More Knowledge Creating a Crosstab Query Using Data From Two Related Tables
225(2)
Objective 15 Create a Parameter Query
225(1)
Activity 2.32 Creating a Parameter Query With One Criteria
225(2)
More Knowledge Parameter Query Prompts
227(1)
Go! With Google
228(2)
Objective Export a Relationship Report to a PDF File, Save the PDF File to Google Drive, and then Share the File
228(2)
Go! To Work
230(1)
End of
Chapter
231(24)
Summary GO! Learn It Online GO! Collaborative Team Project
231(1)
Project Guide for Access
Chapter 2
232(1)
Glossary
233(1)
Chapter Review
234(9)
Mastering Access
243(10)
Rubric
253(1)
GO! Think
254(1)
Chapter 3 Forms, Filters, And Reports
255(72)
Project 3A Students and Majors Database
256(13)
Objective 1 Create and Use a Form to Add and Delete Records
257(1)
Activity 3.01 Opening and Saving an Existing Database and Viewing a Table Relationship
257(1)
Activity 3.02 Creating a Form and Viewing Records
258(2)
Activity 3.03 Creating a Second Form
260(1)
Activity 3.04 Adding Records to a Table by Using a Form
261(2)
Activity 3.05 Deleting Records from a Table by Using a Form
263(1)
Objective 2 Filter Records
264(1)
Activity 3.06 Filtering Data by Selection of One Field
264(2)
Activity 3.07 Using Filter By Form
266(2)
Activity 3.08 Using Advanced Filter/Sort
268(1)
More Knowledge Using the Filter Button
269(14)
Objective 3 Create a Form by Using the Form Wizard
270(1)
Activity 3.09 Creating a Form by Using the Form Wizard
270(1)
Objective 4 Modify a Form in Layout View and in Design View
271(1)
Activity 3.10 Grouping Controls in Layout View
272(1)
Activity 3.11 Applying a Theme and Formatting a Form in Layout View
273(1)
Activity 3.12 Adding, Resizing, and Moving Controls in Layout View
274(2)
Activity 3.13 Formatting Controls in Layout View
276(2)
Activity 3.14 Modifying a Form in Design View
278(3)
Activity 3.15 Printing a Single Form
281(2)
Go! With Google
283(2)
Objective Export an Access Form to an Excel Spreadsheet, Save to Google Drive as a Google Sheet, Edit a Record, and Save to Your Computer
283(2)
Project 3B Job Openings Database
285(17)
Objective 5 Create a Report by Using the Report Tool and Modify the Report in Layout View
286(1)
Activity 3.16 Opening and Saving an Existing Database, Renaming Objects, and Viewing a Table Relationship
286(1)
Activity 3.17 Creating a Report by Using the Report Tool and Applying a Theme to the Report
287(1)
Activity 3.18 Modifying a Report in Layout View
288(2)
Objective 6 Create a Report by Using the Report Wizard
290(1)
Activity 3.19 Creating a Report by Using the Report Wizard
291(2)
Objective 7 Modify the Design of a Report
293(1)
Activity 3.20 Formatting and Deleting Controls in Layout View
293(1)
Activity 3.21 Modifying Controls in Layout View
294(3)
Activity 3.22 Aligning Controls in Design View
297(1)
Objective 8 Keep Grouped Data Together in a Printed Report
298(1)
Activity 3.23 Keeping Grouped Data Together in a Printed Report
299(3)
Go! With Google
302(2)
Objective Export an Access Report to a Word File, Upload the Word File to Google Drive, and Edit the Report in Google Docs
302(2)
Go! To Work
304(1)
End of
Chapter
305(22)
Summary GO! Learn It Online GO! Collaborative Team Project
305(1)
Project Guide for Access
Chapter 3
306(1)
Glossary
307(1)
Chapter Review
308(8)
Mastering Access
316(8)
Rubric
324(1)
GO! Think
325(2)
Chapter 4 Enhancing Tables
327(64)
Project 4A City Directory
328(2)
Objective 1 Manage Existing Tables
329(1)
Activity 4.01 Backing Up a Database
329(1)
More Knowledge Recover Data from a Backup
330(2)
Activity 4.02 Adding File Locations to Trusted Locations
330(2)
More Knowledge Remove a Trusted Location
332(2)
Activity 4.03 Duplicating a Table and Modifying the Structure
332(1)
Activity 4.04 Copying and Appending Records to a Table
333(1)
More Knowledge Add a Table Description
334(1)
More Knowledge Append Records
335(5)
Activity 4.05 Splitting a Table into Two Tables
335(2)
Activity 4.06 Appending Records from Another Database
337(2)
Objective 2 Modify Existing Tables
339(1)
Activity 4.07 Finding and Deleting Records
339(1)
More Knowledge Why the Dept ID Field Data Did Not Renumber Sequentially
340(4)
Activity 4.08 Finding and Modifying Records
341(1)
Activity 4.09 Adding and Moving Fields in Design View and Datasheet View
342(2)
More Knowledge Hide/Unhide Fields in a Table
344(5)
Activity 4.10 Checking Spelling
344(1)
Objective 3 Change Data Types
345(1)
Activity 4.11 Changing Data Types
345(1)
Objective 4 Attach Files to Records
346(1)
Activity 4.12 Attaching a Word Document to a Record
346(3)
Project 4B IT Tasks
349(3)
Objective 5 Create a Table in Design View
350(1)
Activity 4.13 Creating a Table in Design View
350(2)
More Knowledge The Caption Property
352(10)
Activity 4.14 Adding Fields to a Table in Design View
353(1)
Objective 6 Create a Lookup Field
354(1)
Activity 4.15 Creating a Lookup Field Based on a List of Values
355(1)
Activity 4.16 Creating a Lookup Field Based on Data in Another Table
356(1)
Objective 7 Set Field Properties
357(1)
Activity 4.17 Creating an Input Mask Using the Input Mask Wizard
357(3)
Activity 4.18 Creating an Input Mask Using the Input Mask Properties Box
360(2)
More Knowledge The Differences Between Input Masks and Display Formats
362(2)
Activity 4.19 Specifying a Required Field
362(2)
More Knowledge Allowing Blank Data in a Required Short Text or Long Text Field
364(1)
More Knowledge Using the Current Date as a Default Value
364(7)
Activity 4.20 Setting Default Values for Fields
364(1)
Activity 4.21 Indexing Fields in a Table
365(1)
Objective 8 Create Data Validation Rules and Validation Text
366(1)
Activity 4.22 Creating Data Validation Rules and Validation Text
366(2)
Activity 4.23 Testing Table Design and Field Properties
368(3)
Go! To Work
371(1)
End of
Chapter
372(19)
Summary GO! Learn It Online
372(1)
Project Guide for Access
Chapter 4
373(1)
Glossary
374(1)
Chapter Review
375(6)
Mastering Access
381(7)
Rubric
388(1)
GO! Think
389(2)
Chapter 5 Enhancing Queries
391(64)
Project 5A Store Inventory
392(1)
Objective 1 Create Calculated Fields in a Query
393(1)
Activity 5.01 Creating a Calculated Field Based on Two Existing Fields
393(3)
Activity 5.02 Creating a Calculated Field Based on One Existing Field and a Number
396(3)
Objective 2 Use Aggregate Functions in a Query
399(1)
Activity 5.03 Adding a Total Row to a Query
399(3)
More Knowledge Removing the Aggregate Function and Removing the Total Row
402(1)
Activity 5.04 Creating a Totals Query
402(1)
More Knowledge Changing the Name of the Totals Query Result
403(7)
Objective 3 Create a Crosstab Query
404(1)
Activity 5.05 Creating a Select Query as the Source for a Crosstab Query
405(1)
Activity 5.06 Creating a Crosstab Query
406(2)
Objective 4 Find Duplicate and Unmatched Records
408(1)
Activity 5.07 Finding Duplicate Records
409(1)
More Knowledge Removing Duplicate Records
410(1)
Activity 5.08 Finding Unmatched Records
410(1)
More Knowledge Finding Unmatched Records in a Table with Multivalued Fields
411(2)
Objective 5 Create a Parameter Query
411(1)
Activity 5.09 Creating a Parameter Query Using One Criterion
411(2)
More Knowledge Parameter Query Prompts
413(1)
Activity 5.10 Creating a Parameter Query Using Multiple Criteria
413(1)
More Knowledge Creating a Parameter Query Using Multiple Criteria
414(1)
Project 5B Customer Orders
415(8)
Objective 6 Create a Make Table Query
416(1)
Activity 5.11 Creating a Select Query
416(1)
Activity 5.12 Converting a Select Query to a Make Table Query
417(2)
Objective 7 Create an Append Query
419(1)
Activity 5.13 Creating an Append Query for a Table in the Current Database
419(2)
Activity 5.14 Creating an Append Query for a Table in Another Database
421(2)
More Knowledge Running the Same Append Query a Second Time
423(6)
Objective 8 Create a Delete Query
424(1)
Activity 5.15 Creating a Delete Query
424(3)
Objective 9 Create an Update Query
427(1)
Activity 5.16 Creating an Update Query
427(1)
Activity 5.17 Creating an Update Query with an Expression
428(1)
More Knowledge Restrictions for Update Queries
429(5)
Objective 10 Modify the Join Type
430(1)
Activity 5.18 Viewing the Results of a Query Using an Inner Join
430(2)
Activity 5.19 Changing the Join Type to an Outer Join
432(2)
More Knowledge Other Types of Joins
434(1)
Go! To Work
435(1)
End of
Chapter
436(19)
Summary GO! Learn It Online
436(1)
Project Guide for Access
Chapter 5
437(1)
Glossary
438(1)
Chapter Review
439(6)
Mastering Access
445(7)
Rubric
452(1)
GO! Think
453(2)
Chapter 6 Customizing Forms And Reports
455(66)
Project 6A Locations
456(3)
Objective 1 Create a Form in Design View
457(1)
Activity 6.01 Creating a Form in Design View
457(2)
More Knowledge Remove Unnecessary Form Controls
459(1)
More Knowledge Horizontal and Vertical Spacing Between Controls
459(4)
Activity 6.02 Adding Sections to a Form
460(1)
Objective 2 Change and Add Controls
461(1)
Activity 6.03 Changing Controls on a Form
461(2)
More Knowledge Validate or Restrict Data in Forms
463(4)
Activity 6.04 Adding Controls to a Form
463(3)
Objective 3 Format a Form
466(1)
Activity 6.05 Adding a Background Color
466(1)
More Knowledge Changing the Theme Colors
467(1)
More Knowledge Adding a Shape Fill to Controls
468(3)
Activity 6.06 Adding a Background Picture to a Form
468(1)
Activity 6.07 Modifying the Borders of Controls
469(2)
More Knowledge Adding Borders to Label Controls
471(2)
Objective 4 Make a Form User Friendly
471(1)
Activity 6.08 Adding a Message to the Status Bar
471(2)
More Knowledge Conflicting Field Description and Status Bar Text Property Setting
473(5)
Activity 6.09 Creating Custom Control Tips
473(1)
Activity 6.10 Changing the Tab Order
474(4)
Project 6B Rosebud Cafe
478(5)
Objective 5 Create a Report Based on a Query Using a Wizard
479(1)
Activity 6.11 Creating a Report Using a Wizard
479(1)
Activity 6.12 Modifying a Report Created Using a Wizard
480(1)
Objective 6 Create a Report in Design View
481(1)
Activity 6.13 Creating a Report in Design View
482(1)
More Knowledge Using the Tabular Arrangement
483(1)
Activity 6.14 Modifying the Sections of a Report
483(1)
More Knowledge Formatting a Report
484(2)
Objective 7 Add Controls to a Report
484(1)
Activity 6.15 Adding Label and Text Box Controls to a Report
484(2)
More Knowledge Adding a Hyperlink to a Report
486(11)
Activity 6.16 Adding an Image Control to a Report
486(2)
Objective 8 Group, Sort, and Total Records in Design View
488(1)
Activity 6.17 Adding a Grouping and Sort Level to a Report
488(3)
Activity 6.18 Adding Calculated Controls to a Report
491(6)
More Knowledge Changing the Margins in Print Preview
497(1)
Go! To Work
498(1)
End of
Chapter
499(22)
Summary GO! Learn It Online
499(1)
Project Guide for Access
Chapter 6
500(1)
Glossary
501(1)
Chapter Review
502(8)
Mastering Access
510(9)
Rubric
519(1)
GO! Think
520(1)
Chapter 7 Creating Advanced Forms And Reports
521(66)
Project 7A MWB Schedule
522(2)
Objective 1 Create a Split Form
523(1)
Activity 7.01 Creating a Split Form Using the Split Form Tool
523(1)
More Knowledge Converting an Existing Form to a Split Form
524(5)
Activity 7.02 Formatting a Split Form
525(4)
More Knowledge Adding or Deleting a Field
529(3)
Objective 2 Create a Form and a Subform
529(1)
Activity 7.03 Creating a Form and a Subform Using the Form Tool
530(2)
More Knowledge Sort Records in a Form
532(1)
More Knowledge Create Forms with Application Parts
533(6)
Activity 7.04 Creating a Form and a Subform Using the Form Wizard
534(1)
Activity 7.05 Modifying a Form and a Subform
535(4)
More Knowledge Adding the Table Name to the Subform
539(7)
Objective 3 Create a Multi-Page Form
539(1)
Activity 7.06 Creating a Multi-Page Form Using the Tab Control
539(4)
Activity 7.07 Creating a Subform by Dragging a Related Table onto an Existing Form
543(3)
More Knowledge Creating a Form with Two Subforms or Nested Subforms
546(1)
Project 7B Online Orders
547(14)
Objective 4 Create and Modify a Subreport
548(1)
Activity 7.08 Using the SubReport Wizard to Create a Subreport
548(2)
Activity 7.09 Modifying a Subreport
550(2)
Activity 7.10 Creating a Subreport by Adding an Object to an Existing Report
552(1)
Activity 7.11 Displaying a Total from a Subreport on the Main Report
553(5)
Objective 5 Create a Report Based on a Parameter Query
558(1)
Activity 7.12 Creating a Report Based on a Parameter Query
558(1)
Activity 7.13 Placing the Parameters in the Report
559(2)
Objective 6 Create an Alphabetic Index
561(1)
Activity 7.14 Creating an Alphabetic Index
561(1)
More Knowledge Inserting an Image in a Report
561(4)
Go! To Work
565(1)
End of
Chapter
566(21)
Summary GO! Learn It Online
566(1)
Project Guide for Access
Chapter 7
567(1)
Glossary
568(1)
Chapter Review
569(8)
Mastering Access
577(9)
GO! Think
586(1)
Chapter 8 Creating Macros
587(58)
Project 8A Employee Records
588(14)
Objective 1 Create a Standalone Macro with One Action
589(1)
Activity 8.01 Creating a Standalone Macro
589(4)
Activity 8.02 Opening a Form in Its Own Window
593(2)
Activity 8.03 Creating a Standalone Macro That Executes Automatically
595(2)
Objective 2 Add Multiple Actions to a Standalone Macro
597(1)
Activity 8.04 Adding Multiple Actions to an Existing Standalone Macro
597(5)
More Knowledge Debugging a Macro
602(10)
Objective 3 Create an Embedded Macro
602(1)
Activity 8.05 Creating an Embedded Macro on a Form
602(5)
Activity 8.06 Creating an Embedded Macro on a Report
607(1)
Objective 4 Print Macro Details
608(1)
Activity 8.07 Printing Macro Details
608(4)
Project 8B Employee Benefits
612(11)
Objective 5 Create a Macro Group
613(1)
Activity 8.08 Creating the First Macro in a Macro Group
613(1)
Activity 8.09 Creating a Second Macro in a Macro Group
614(5)
Activity 8.10 Creating a Third Macro in a Macro Group
619(1)
Objective 6 Associate a Macro with an Event
620(1)
Activity 8.11 Associating a Command Button with a Macro
620(2)
Objective 7 Create a Data Macro
622(1)
Activity 8.12 Creating an Event-Driven Macro
622(1)
More Knowledge Adding a Total Row to a Table
623(2)
Activity 8.13 Printing Macro Group Details
624(1)
Go! To Work
625(1)
End of
Chapter
626(19)
Summary GO! Learn It Online
626(1)
Project Guide for Access
Chapter 8
627(1)
Glossary
628(1)
Chapter Review
629(6)
Mastering Access
635(7)
Rubric
642(1)
GO! Think
643(2)
Chapter 9 Integrating Access With Other Applications
645(58)
Project 9A Liberty Motors
646(8)
Objective 1 Import Data from a Word Table
647(1)
Activity 9.01 Preparing a Word Table for Importing
647(3)
Activity 9.02 Importing Data from a Word Table
650(4)
More Knowledge Importing from Other Applications
654(2)
Objective 2 Import Data from an Excel Workbook
655(1)
Activity 9.03 Importing Data from an Excel Worksheet
655(1)
More Knowledge Importing from a Workbook That Contains a Chart
656(7)
Activity 9.04 Appending Data from Excel to an Access Table
657(1)
Objective 3 Insert an Excel Chart into a Report
658(1)
Activity 9.05 Creating a Query and a Report
658(1)
Activity 9.06 Inserting an Excel Chart into a Report
659(2)
Objective 4 Import from and Link to Another Access Database
661(1)
Activity 9.07 Importing Data from Another Access Database
661(2)
Activity 9.08 Linking to a Table in Another Access Database
663(1)
More Knowledge Recover Data from a Backup File
663(2)
Project 9B Used Inventory
665(13)
Objective 5 Export Data to Word
666(1)
Activity 9.09 Exporting an Access Query to Word
666(3)
Activity 9.10 Exporting an Access Report to Word
669(1)
Objective 6 Use Mail Merge to Integrate Access and Word
670(1)
Activity 9.11 Merging an Access Table with a Word Document
670(4)
Objective 7 Export Data to Excel
674(1)
Activity 9.12 Exporting Selected Records to Excel
674(2)
Activity 9.13 Copying Selected Records to an Existing Excel Workbook
676(2)
More Knowledge Exporting Data to Another Access Database
678(3)
Objective 8 Export Data to an HTML File and an XML File
678(1)
Activity 9.14 Exporting a Report to an HTML File
678(1)
Activity 9.15 Exporting a Report to an XML File
679(2)
More Knowledge Exporting Data to Alternate Formats
681(2)
Go! To Work
683(1)
End of
Chapter
684(19)
Summary GO! Learn It Online
684(1)
Project Guide for Access
Chapter 9
685(1)
Glossary
686(1)
Chapter Review
687(6)
Mastering Access
693(7)
Rubric
700(1)
GO! Think
701(2)
Chapter 10 Administering Databases And Writing Sql Statements
703(1)
Project 10A Lawyer Recruitment
704(1)
Objective 1 Create a Navigation Form
705(1)
Activity 10.01 Creating a Navigation Form Using the Navigation Form Tool
705(2)
Objective 2 Use Microsoft Access Analysis Tools
707(1)
Activity 10.02 Using the Table Analyzer
707(2)
Activity 10.03 Using the Performance Analyzer
709(2)
Activity 10.04 Viewing Object Dependencies
711(1)
More Knowledge Deleting Database Objects
711(8)
Objective 3 Modify Access Views and Behaviors
712(1)
Activity 10.05 Modifying Access Options
712(2)
Activity 10.06 Customizing the Quick Access Toolbar
714(2)
Activity 10.07 Setting Current Database Options
716(1)
Activity 10.08 Set Navigation Options
717(2)
More Knowledge Saving a Database as a Template
719(2)
Objective 4 Use the Database Splitter
719(1)
Activity 10.09 Splitting a Database
719(2)
More Knowledge Moving the Back End to a Microsoft SQL Server
721(6)
Objective 5 Encrypt and Decrypt Databases
722(1)
Activity 10.10 Encrypting a Database with a Password
722(1)
Activity 10.11 Decrypting a Database with a Password
723(1)
Objective 6 Create a Locked Database (ACCDE File)
724(1)
Activity 10.12 Creating a Secure ACCDE File
724(3)
Project 10B Overdue Accounts
727(11)
Objective 7 Modify a Query in SQL View
728(1)
Activity 10.13 Modifying a Query in SQL View
728(2)
Objective 8 Create a Query in SQL View
730(1)
Activity 10.14 Creating an SQL Statement
730(2)
Activity 10.15 Specifying the Join Type in SQL
732(1)
Objective 9 Create a Union Query Using SQL
733(1)
Activity 10.16 Creating a Union Query in SQL View
733(1)
Objective 10 Create Calculated Fields and SQL Aggregate Functions
734(1)
Activity 10.17 Creating Calculated Fields in SQL
734(1)
Activity 10.18 Writing SQL Aggregate Functions
735(3)
Go! To Work
738(1)
End of
Chapter
739(1)
Summary GO! Learn It Online
739(1)
Project Guide for Access
Chapter 10
740(1)
Glossary
741(1)
Chapter Review
742(5)
Mastering Access
747(7)
Rubric
754(1)
GO! Think
755
Appendix 1(1)
Glossary 1(1)
Index 1
About our authors Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.

Nancy Graviett (Access author) is a professor and department chair in Business Technology at St. Charles Community College inCottleville, Missouri. She holds a bachelor's degree in marketing and a master's degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect, Google, Microsoft Outlook, and Microsoft Access.