Muutke küpsiste eelistusi

Exploring Microsoft Office Access 2019 Comprehensive [Spiraalköide]

3.00/5 (6 hinnangut Goodreads-ist)
, ,
  • Formaat: Spiral bound, 640 pages, kõrgus x laius x paksus: 100x100x100 mm, kaal: 100 g
  • Ilmumisaeg: 22-Mar-2019
  • Kirjastus: Pearson
  • ISBN-10: 0135435811
  • ISBN-13: 9780135435816
Teised raamatud teemal:
Exploring Microsoft Office Access 2019 ComprehensiveSuurem pilt
  • Formaat: Spiral bound, 640 pages, kõrgus x laius x paksus: 100x100x100 mm, kaal: 100 g
  • Ilmumisaeg: 22-Mar-2019
  • Kirjastus: Pearson
  • ISBN-10: 0135435811
  • ISBN-13: 9780135435816
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780135435816.html
Now live! SUMMER 2020 DIGITAL UPDATE for digital content Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For courses covering introductory Microsoft® AccessTM. Beyond point-and-click The Exploring Microsoft® Office 365® series moves students beyond rote tasks to a deeper comprehension of how, when, and why to apply Office skills. A market leader for over 20 years, the collection helps students achieve high-level learning outcomes by engaging them in the way they learn best through hands-on practice. A dozen exercises in each chapter range from multiple-choice questions to open-ended projects. Revised to reflect Microsoft Office 365, the 2019 edition adds new critical thinking assignments to help students build fundamental 21st-century skills. Also available with MyLab IT 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. Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information. If you would like to purchase both the physical text and MyLab IT, search for: 0135825741 / 9780135825747 Exploring: Microsoft Access 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e Package consists of:





0135402468 / 9780135402467 MyLab IT with Pearson eText -- Access Card -- for Exploring Microsoft Office 2019, 1/e 0135435811 / 9780135435816 Exploring Microsoft Office Access 2019 Comprehensive, 1/e
Microsoft Office 2019
Chapter One Office 365 Common Features: Taking The First Step
2(68)
Case Study Spotted Begonia Art Gallery
2(2)
Get Started With Office Applications
4(15)
Starting an Office Application
5(1)
Working with Files
6(3)
Using Common Interface Components
9(6)
Getting Help
15(2)
Installing Add-ins
17(2)
Hands-On Exercise 1
19(6)
Format Document Content
25(12)
Using Templates and Applying Themes
25(2)
Modifying Text
27(3)
Relocating Text
30(2)
Reviewing a Document
32(2)
Working with Pictures
34(3)
Hands-On Exercise 2
37(8)
Modify Document Layout And Properties
45(8)
Changing Document Views
45(1)
Changing the Page Layout
46(3)
Creating a Header and a Footer
49(1)
Configuring Document Properties
50(1)
Previewing and Printing a File
51(2)
Hands-On Exercise 3
53(5)
Chapter Objectives Review
58(2)
Key Terms Matching
60(1)
Multiple Choice
61(1)
Practice Exercises
62(3)
Mid-Level Exercises
65(2)
Running Case
67(1)
Disaster Recovery
67(1)
Capstone Exercise
68(2)
Microsoft Office Access 2019
Chapter One Introduction To Access: Navigating An Access Database
70(62)
Case Study Managing A Business In The Global Economy
70(2)
Databases Are Everywhere!
72(19)
Opening, Saving, and Enabling Content in a Database
72(2)
Recognizing Database Object Types
74(11)
Modifying, Adding, and Saving Data
85(3)
Using Database Utilities
88(3)
Hands-On Exercise 1
91(7)
Filters And Sorts
98(6)
Working with Filters
98(4)
Performing Sorts
102(2)
Hands-On Exercise 2
104(5)
Access Database Creation
109(6)
Creating a Database
109(6)
Hands-On Exercise 3
115(4)
Chapter Objectives Review
119(1)
Key Terms Matching
120(1)
Multiple Choice
121(1)
Practice Exercises
122(5)
Mid-Level Exercises
127(2)
Running Case
129(1)
Disaster Recovery
129(1)
Capstone Exercise
130(2)
Chapter Two Tables And Queries In Relational Databases: Designing Databases And Extracting Information
132(70)
Case Study Bank Internship
132(2)
Table Design, Creation, And Modification
134(11)
Designing a Table
134(4)
Creating and Modifying Tables and Working with Data
138(7)
Hands-On Exercise 1
145(4)
Multiple-Table Databases
149(8)
Importing Data from External Sources
149(3)
Establishing Table Relationships
152(5)
Hands-On Exercise 2
157(7)
Single-Table Queries
164(10)
Creating a Single-Table Query
164(3)
Using the Query Wizard
167(2)
Specifying Query Criteria
169(3)
Specifying Query Sort Order and Running a Query
172(1)
Copying and Modifying a Query
172(2)
Hands-On Exercise 3
174(3)
Multitable Queries
177(5)
Creating a Multitable Query
177(1)
Modifying a Multitable Query
178(4)
Hands-On Exercise 4
182(4)
Chapter Objectives Review
186(2)
Key Terms Matching
188(1)
Multiple Choice
189(1)
Practice Exercises
190(6)
Mid-Level Exercises
196(2)
Running Case
198(1)
Disaster Recovery
199(1)
Capstone Exercise
200(2)
Chapter Three Query Calculations And Expressions: Performing Calculations And Summarizing Data Using Queries
202(46)
Case Study Real Estate Investors
202(2)
Calculated Fields And Expressions
204(8)
Creating a Query with a Calculated Field
204(5)
Formatting Calculated Results
209(1)
Recovering from Common Errors
210(1)
Verifying Calculated Results
211(1)
Hands-On Exercise 1
212(5)
The Expression Builder And Functions
217(5)
Creating Expressions Using the Expression Builder
217(1)
Using Built-in Functions
218(4)
Hands-On Exercise 2
222(4)
Aggregate Functions
226(6)
Adding Aggregate Functions to Datasheets
226(1)
Creating Queries with Aggregate Functions
227(5)
Hands-On Exercise 3
232(4)
Chapter Objectives Review
236(1)
Key Terms Matching
237(1)
Multiple Choice
238(1)
Practice Exercises
239(3)
Mid-Level Exercises
242(2)
Running Case
244(1)
Disaster Recovery
245(1)
Capstone Exercise
246(2)
Chapter Four Basic Forms And Reports: Simplifying Data Entry And Producing Information
248(54)
Case Study Coffee Shop Starts New Business
248(2)
Create Basic Forms To Simplify Data Management
250(14)
Creating Forms Using Form Tools
250(8)
Modifying Forms
258(3)
Using the Form Layout Control
261(2)
Sorting Records in a Form
263(1)
Hands-On Exercise 1
264(7)
Create Basic Reports To Present Information
271(12)
Creating Reports Using Report Tools
272(5)
Using Report Views
277(1)
Modifying a Report
278(3)
Sorting and Grouping Records in a Report
281(2)
Hands-On Exercise 2
283(5)
Chapter Objectives Review
288(2)
Key Terms Matching
290(1)
Multiple Choice
291(1)
Practice Exercises
292(4)
Mid-Level Exercises
296(2)
Running Case
298(1)
Disaster Recovery
298(1)
Capstone Exercise
299(3)
Chapter Five Data Validation And Data Analysis: Reducing Errors And Extracting Better Information
302(42)
Case Study Implementing A New Database At Tommy'S Shelter
302(2)
Restrict Table Data
304(7)
Establishing Data Validation
304(3)
Controlling the Format of Data Entry
307(2)
Controlling Input with a Lookup Field
309(2)
Hands-On Exercise 1
311(6)
Data Analysis With Advanced Queries And Functions
317(10)
Customizing Output Based on User Input
317(2)
Using Advanced Functions
319(8)
Hands-On Exercise 2
327(5)
Chapter Objectives Review
332(1)
Key Terms Matching
333(1)
Multiple Choice
334(1)
Practice Exercises
335(3)
Mid-Level Exercises
338(2)
Running Case
340(1)
Disaster Recovery
341(1)
Capstone Exercise
342(2)
Chapter Six Action And Specialized Queries: Advancing Beyond The Select Query
344(44)
Case Study Virtual Registry, Inc.
344(2)
Action Queries
346(11)
Determining When to Use an Action Query
346(2)
Updating Data with an Update Query
348(3)
Adding Records to a Table with an Append Query
351(2)
Creating a Table with a Make Table Query
353(2)
Deleting Records with a Delete Query
355(2)
Hands-On Exercise 1
357(7)
Specialized Queries
364(11)
Summarizing Data with a Crosstab Query
364(5)
Finding Duplicate Records with a Query
369(2)
Finding Unmatched Records with a Query
371(4)
Hands-On Exercise 2
375(13)
Chapter Objectives Review
378(1)
Key Terms Matching
379(1)
Multiple Choice
380(1)
Practice Exercises
381(3)
Mid-Level Exercises
384(1)
Running Case
385(1)
Disaster Recovery
386(1)
Capstone Exercise
387(1)
Chapter Seven Advanced Forms And Reports: Moving Beyond The Basics
388(50)
Case Study Yellowstone County Technical Services
388(2)
Advanced Forms
390(9)
Restricting Edits in a Form
390(1)
Understanding Combo Boxes
391(3)
Setting the Tab Order
394(2)
Understanding Subforms
396(3)
Hands-On Exercise 1
399(6)
Controls And Sections
405(15)
Understanding Controls
405(7)
Understanding Sections
412(8)
Hands-On Exercise 2
420(7)
Chapter Objectives Review
427(1)
Key Terms Matching
428(1)
Multiple Choice
429(1)
Practice Exercises
430(4)
Mid-Level Exercises
434(1)
Running Case
435(1)
Disaster Recovery
436(1)
Capstone Exercise
437(1)
Chapter Eight Get Connected: Exchanging Data Between Access And Other Applications
438(62)
Case Study Property Management Data Exchange
438(2)
Connect Access To External Files
440(8)
Creating a Hyperlink Field
440(2)
Adding an Attachment Field
442(3)
Adding Attachment Controls to Forms and Reports
445(3)
Hands-On Exercise 1
448(6)
Export Data To Office And Other Applications
454(10)
Exporting Data to Excel
454(3)
Exporting Data to Word
457(3)
Exporting Data to a PDF or XPS Document
460(2)
Exporting Objects to Another Access Database
462(2)
Hands-On Exercise 2
464(7)
Import And Link Data In Access Databases
471(9)
Linking to an Access Table
471(3)
Linking to and Importing an Excel Spreadsheet
474(2)
Importing an Excel Spreadsheet
476(1)
Importing a Text File
477(3)
Hands-On Exercise 3
480(9)
Chapter Objectives Review
489(1)
Key Terms Matching
490(1)
Multiple Choice
491(1)
Practice Exercises
492(4)
Mid-Level Exercises
496(1)
Running Case
497(1)
Disaster Recovery
498(1)
Capstone Exercise
499(1)
Chapter Nine Fine-Tuning The Database: Designing For Performance
500(52)
Case Study The Metropolitan Zoo
500(2)
Database Normalization
502(9)
Understanding First Normal Form
503(2)
Understanding Second Normal Form
505(2)
Understanding Third Normal Form
507(2)
Finalizing the Design
509(2)
Hands-On Exercise 1
511(4)
Built-In Analysis And Design Tools
515(10)
Using the Database Documenter Tool
516(2)
Using the Performance Analyzer Tool
518(2)
Using the Table Analyzer Tool
520(3)
Using the Database Splitter Tool
523(2)
Hands-On Exercise 2
525(5)
Database Security
530(6)
Controlling Navigation
530(2)
Encrypting and Password Protecting a Database
532(2)
Creating an Executable Form of a Database
534(2)
Hands-On Exercise 3
536(4)
Chapter Objectives Review
540(1)
Key Terms Matching
541(1)
Multiple Choice
542(1)
Practice Exercises
543(3)
Mid-Level Exercises
546(2)
Running Case
548(1)
Disaster Recovery
549(1)
Capstone Exercise
550(2)
Chapter Ten Enhanced Database Techniques: Using Macros And Sql In Access
552(59)
Case Study Retirement Plan Contributions
552(2)
Macro Design
554(7)
Understanding the Purpose of a Macro
554(1)
Creating a Standalone Macro
555(2)
Attaching an Embedded Macro to an Event
557(4)
Hands-On Exercise 1
561(7)
Data Macros
568(4)
Identifying When to Use a Data Macro
568(1)
Creating an Event-Driven Data Macro
568(1)
Creating a Named Data Macro
569(3)
Hands-On Exercise 2
572(6)
Structured Query Language
578(6)
Understanding the Fundamentals of SQL
578(1)
Interpreting an SQL SELECT Statement
579(2)
Using an SQL SELECT Statement as a Record Source
581(3)
Hands-On Exercise 3
584(3)
Chapter Objectives Review
587(1)
Key Terms Matching
588(1)
Multiple Choice
589(1)
Practice Exercises
590(5)
Mid-Level Exercises
595(2)
Running Case
597(1)
Disaster Recovery
597(1)
Capstone Exercise
598(2)
Application Capstone Exercises Access Application Capstone Exercise (Chs. 1--4)
600(4)
Access Comprehensive Application Capstone Exercise (Chs. 5--10)
604(4)
Microsoft Office 2019 Specialist Access
608(3)
Glossary 611(5)
Index 616
About our authors Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management.

Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.

Amy Rutledge, Access Author, is a special Instructor of MIS (management information systems) at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft® Office applications and introductory management information systems courses for the School of Business Administration. Before joining Oakland University as an instructor, Amy spent several years working for a music distribution company and automotive manufacturer in various corporate roles, including IT project management. She holds a BS in business administration, specializing in MIS, and a BA in French modern language and literature. She holds an MBA from Oakland University. She resides in Michigan with her husband, Dan, and daughters, Emma and Jane.

Jerri Williams, Access Author, is a senior instructor at Montgomery County Community College in Pennsylvania, and currently works as a technical editor and content developer in addition to her teaching responsibilities. Jerri worked as a live and virtual corporate trainer and developer in major pharmaceutical and other companies for many years prior to joining the Exploring Access 2013, 2016, and 2019 teams. She is interested in travel, history, cooking, theater, movies, and tending to her colonial farmhouse (a work in progress). Jerri is married to Gareth and is the mother of two daughters, Holly (an accountant/office manager, and mother of an adorable son, Meir) and Gwyneth (a corporate defense/employment attorney). Jerri and Gareth live outside of Philadelphia, and enjoy their home and garden, spending time with family and friends, watching the Philadelphia Eagles, and visiting the Jersey Shore any time of the year.