Muutke küpsiste eelistusi

Exam 77-885 Microsoft Access 2010 with Microsoft Office 2010 Evaluation Software [Pehme köide]

4.00/5 (2 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 464 pages, kõrgus x laius x paksus: 274x208x18 mm, kaal: 885 g
  • Sari: Delisted
  • Ilmumisaeg: 26-Jun-2025
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 0470907681
  • ISBN-13: 9780470907689
Teised raamatud teemal:
Exam 77-885 Microsoft Access 2010 with Microsoft Office 2010 Evaluation SoftwareSuurem pilt
  • Formaat: Paperback / softback, 464 pages, kõrgus x laius x paksus: 274x208x18 mm, kaal: 885 g
  • Sari: Delisted
  • Ilmumisaeg: 26-Jun-2025
  • Kirjastus: John Wiley & Sons Inc
  • ISBN-10: 0470907681
  • ISBN-13: 9780470907689
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780470907689.html
The Microsoft Official Academic Courseware (MOAC) Office 2010 Series is the only Official Academic Course Material. The new and enhanced MOAC/ Microsoft Office Access 2010 by Keith Hoell features Enhanced Wiley Desktop Editions as well as many other enhanced features designed to re-enforce workforce skills. The addition of animated tutorials in the Enhanced Wiley Desktop Editions and WileyPLUS courses, textbooks include additional materials on different skill levels to help users keep pace. WileyPLUS and an automatic Office assignment grader provides immediate feedback on every assignment, to help users practice and hone skills at their own pace.MOAC/ Microsoft Office Access 2010 is built from the ground-up around the MOS® certification objectives- making it a great way to learn all the workforce-oriented tasks required for certification. The Test Bank now offers greater flexibility and provides more than 75 questions and 3 projects per lesson, as well as automated grading via OfficeGrader. Furthermore, the latest editions use of color in screen captures allows users to follow on screen much easier, as screen captures will look the exact same as the application. Additional projects throughout the book helps  users comprehend how a task is applied on the job. OfficeGrader functionality added to WileyPLUS provides immediate feedback on all homework, assignments, and projects and additional animated tutorials on key Office tasks provides additional help on difficult topics.
1 Database Essentials 1(29)
Lesson Skill Matrix
1(1)
Key Terms
1(1)
Software Orientation: Microsoft Access' Opening Screen
2(1)
Getting Started
3(3)
Starting Access
3(1)
Opening an Existing Database
4(2)
Working in the Access Window
6(1)
Software Orientation: Navigation Pane
6(7)
Using the Navigation Pane
7(3)
Using ObjectTabs
10(1)
Changing Views
11(2)
Using the On-Screen Tools
13(3)
Using the Ribbon
13(1)
Using the Quick AccessToolbar
14(1)
Using Key Tips
15(1)
Software Orientation: Introducing the Backstage View
16(1)
Using the Backstage View
17(1)
Using the Backstage View
17(1)
Using the Microsoft Office Access Help Button
18(2)
Using the Help Button and Connection Status Command
18(2)
Defining Data Needs and Types
20(5)
Defining Table Fields
21(1)
Defining and Modifying DataTypes for Fields
21(3)
Defining DatabaseTables
24(1)
Skill Summary
25(5)
Knowledge Assessment
26(1)
Competency Assessment
27(1)
Proficiency Assessment
27(1)
Mastery Assessment
28(1)
Internet Ready
29(1)
Workplace Ready
29(1)
2 Create Database Tables 30(19)
Lesson Skill Matrix
30(1)
Key Terms
30(1)
Software Orientation: Getting Started with Microsoft Access
31(1)
Creating a Database
32(6)
Using a Template to Create a Database
32(4)
Creating a Blank Database
36(2)
Software Orientation: Templates Group and Application Parts
38(1)
Creating a Table
38(4)
Using the Application Parts Gallery and Quick Start
39(1)
Creating a Table from Another Table
40(2)
Saving a Database Object
42(2)
Saving a Table
43(1)
Skill Summary
44(5)
Knowledge Assessment
44(2)
Competency Assessment
46(1)
Proficiency Assessment
47(1)
Mastery Assessment
47(1)
Internet Ready
48(1)
3 Work With Tables And Database Records 49(29)
Lesson Skill Matrix
49(1)
Key Terms
49(1)
Navigating Among Records
50(2)
Navigating Using the Keyboard
50(1)
Using Navigation Buttons
51(1)
Software Orientation: Records Group, Record Selector Box, and Record Shortcut Menu
52(1)
Entering, Inserting, Editing, and Deleting Records
53(2)
Entering, Editing, and Deleting Records
53(2)
Working with Primary Keys
55(1)
Defining a Primary Key
55(1)
Defining and Modifying a Multifield Primary Key
56(1)
Finding and Replacing Data
56(2)
Finding and Replacing Data
57(1)
Attaching and Detaching Documents
58(2)
Attaching and Detaching Documents
58(2)
Sorting and Filtering Data and Setting Field Viewing Options within a Table
60(1)
Software Orientation: Sort & Filter Group
60(8)
Sorting Data within a Table
60(2)
Filtering Data within a Table
62(3)
Removing a Filter
65(1)
Freezing/Unfreezing and Hiding/Unhiding Fields
66(2)
Software Orientation: Relationship Tools on the Ribbon
68(1)
Understanding Table Relationships
68(5)
Defining Table Relationships
68(2)
Modifying Table Relationships
70(2)
Printing Table Relationships
72(1)
Skill Summary
73(5)
Knowledge Assessment
73(1)
Competency Assessment
74(1)
Proficiency Assessment
75(1)
Mastery Assessment
76(1)
Internet Ready
77(1)
4 Modify Tables and Fields 78(29)
Lesson Skill Matrix
78(1)
Key Terms
78(1)
Modifying a Database Table
79(4)
Modifying Table Properties
79(2)
Renaming a Table
81(2)
Deleting a Table
83(1)
Software Orientation: Field Properties
83(1)
Creating Fields and Modifying Field Properties
84(8)
Setting Field Properties
84(2)
Defining Input Masks
86(2)
Allowing Zero-Length Strings in a Field
88(1)
Setting Memo Fields as Append Only
89(1)
Setting Data Validation Rules
89(2)
Entering Captions
91(1)
Software Orientation: Add & Delete Group
92(9)
Creating Fields
92(5)
Deleting a Field
97(1)
Creating Multivalued Fields
98(3)
Skill Summary
101(6)
Knowledge Assessment
101(2)
Competency Assessment
103(1)
Proficiency Assessment
104(1)
Mastery Assessment
105(1)
Internet Ready
106(1)
5 Create Forms 107(27)
Lesson Skill Matrix
107(1)
Key Terms
107(1)
Software Orientation: Forms Group
108(1)
Creating Forms
108(10)
Creating a Simple Form
109(1)
Creating a Form in Design View
110(3)
Creating a Form in Layout View
113(1)
Using the Form Wizard
114(2)
Applying a Theme
116(2)
Sorting and Filtering Data within a Form
118(6)
Sorting Data within a Form
118(1)
Filtering Data within a Form
119(3)
Using Filter by Form
122(2)
Skill Summary
124(5)
Knowledge Assessment
124(1)
Competency Assessment
125(1)
Proficiency Assessment
126(1)
Mastery Assessment
127(1)
Internet Ready
128(1)
Circling Back 1
129(5)
6 Create Reports 134(21)
Lesson Skill Matrix
134(1)
Key Terms
134(1)
Software Orientation: Reports Group
135(1)
Creating Reports
135(8)
Creating a Simple Report
135(2)
Using the Report Wizard
137(3)
Creating a Report in Design View
140(3)
Applying a Theme
143(2)
Applying a Theme
143(2)
Working with Reports
145(5)
Sorting Data within a Report
145(2)
Filtering Data within a Report
147(2)
Finding Data within a Report
149(1)
Skill Summary
150(5)
Knowledge Assessment
150(1)
Competency Assessment
151(1)
Proficiency Assessment
152(1)
Mastery Assessment
153(1)
Internet Ready
154(1)
7 Create and Modify Querries 155(28)
Lesson Skill Matrix
155(1)
Key Terms
155(1)
Software Orientation: Queries Group
156(1)
Creating a Query
156(10)
Creating a Query from a Table
156(3)
Creating a Find Duplicates Query
159(2)
Creating a Query from Multiple Tables
161(2)
Finding Unmatched Records
163(3)
Software Orientation: Design Tab
166(1)
Modifying a Query
167(5)
Adding a Table to a Query
167(1)
Removing a Table from a Query
168(1)
Adding Criteria to a Query
168(4)
Sorting and Filtering Data within a Query
172(1)
Sorting Data within a Query
172(5)
Filtering Data within a Query
175(2)
Skill Summary
177(6)
Knowledge Assessment
177(2)
Competency Assessment
179(1)
Proficiency Assessment
180(1)
Mastery Assessment
181(1)
Internet Ready
182(1)
8 Use Controls In Reports And Forms 183(41)
Lesson Skill Matrix
183(1)
Key Terms
183(1)
Software Orientation: Controls and Header/Footer Groups in Reports and Forms
184(1)
Adding Bound and Unbound Controls
184(15)
Adding Unbound Controls
185(2)
Adding Bound Controls
187(5)
Adding Calculated Controls
192(2)
Adding Controls Using a Wizard
194(2)
Adding Button Controls Using the Wizard
196(3)
Defining Control Tab Order
199(2)
Software Orientation: Report Design Tools FormatTab
201(1)
Formatting Controls
201(7)
Formatting Controls
201(3)
Formatting Controls on a Form
204(2)
Creating Conditional Formatting on Controls
206(2)
Software Orientation: ArrangeTab
208(1)
Arranging Control Layout
208(6)
Adding, Moving, and Removing a Control
210(2)
Arranging and Anchoring Controls
212(2)
Arranging Control Alignment, Size, and Position
214(3)
Skill Summary
217(7)
Knowledge Assessment
218(1)
Competency Assessment
219(2)
Proficiency Assessment
221(1)
Mastery Assessment
222(1)
Internet Ready
223(1)
9 Advanced Tables 224(16)
Lesson Skill Matrix
224(1)
Key Terms
224(1)
Creating a Custom Table
225(3)
Creating a Custom Table
225(2)
Inserting and Deleting Rows
227(1)
Using the Table Analyzer
228(5)
Using the Table Analyzer
228(5)
Summarizing Table Data
233(2)
Summarizing Table Data
233(2)
Skill Summary
235(5)
Knowledge Assessment
236(1)
Competency Assessment
236(1)
Proficiency Assessment
237(1)
Mastery Assessment
238(1)
Internet Ready
239(1)
10 Advanced Forms 240(25)
Lesson Skill Matrix
240(1)
Key Terms
240(1)
Software Orientation: The Templates Group and the Forms Group
241(1)
Creating Advanced Forms
242(8)
Creating a Multi-Item Form
242(1)
Creating a Split Form
243(4)
Creating a Subform
247(3)
Using Application Parts to Create Blank Forms
250(3)
Creating a Navigation Form
253(2)
Skill Summary
255(6)
Knowledge Assessment
255(2)
Competency Assessment
257(1)
Proficiency Assessment
258(1)
Mastery Assessment
259(1)
Internet Ready
260(1)
Circling Back 2
261(4)
11 Advanced Reports 265(21)
Lesson Skill Matrix
265(1)
Key Terms
265(1)
Defining Groups
266(7)
Using the Report Wizard
266(3)
Adding Group Headers and Footers
269(2)
Changing Grouping Options
271(2)
Creating Aggregate Fields
273(2)
Creating Aggregate Fields
273(2)
Software Orientation: Print PreviewTab
275(1)
Creating the Print Layout
275(2)
Using Print Preview to Create a Print Layout
275(2)
Using the Label Wizard
277(4)
Creating Labels Using the Label Wizard
277(4)
Skill Summary
281(5)
Knowledge Assessment
282(1)
Competency Assessment
282(1)
Proficiency Assessment
283(1)
Mastery Assessment
284(1)
Internet Ready
285(1)
12 Advanced Queries 286(39)
Lesson Skill Matrix
286(1)
Key Terms
286(1)
Creating Crosstab Queries
287(4)
Creating Crosstab Queries
287(4)
Creating a Subquery
291(5)
Creating a Subquery
292(4)
Saving a Filter as a Query
296(2)
Saving a Filter as a Query
296(2)
Creating Action Queries
298(12)
Creating an Append Query
299(3)
Creating a MakeTable Query
302(2)
Creating an Update Query
304(3)
Creating a Delete Query
307(3)
Understanding Advanced Query Modification
310(8)
Creating a Join
310(2)
Creating a Calculated Query Field
312(3)
Creating Aggregated Queries
315(3)
Skill Summary
318(7)
Knowledge Assessment
319(1)
Competency Assessment
320(2)
Proficiency Assessment
322(1)
Mastery Assessment
323(1)
Internet Ready
324(1)
Workplace Ready
324(1)
13 Display and Share Data 325(25)
Lesson Skill Matrix
325(1)
Key Terms
325(1)
Creating a Chart Using the Chart Wizard
326(4)
Creating a Chart Using the Chart Wizard
326(4)
Formatting a Chart
330(6)
Changing Chart Options
330(4)
Changing Format Options
334(2)
Refreshing Data in a Chart
336(1)
Changing ChartTypes
336(2)
Changing ChartTypes
336(2)
Building a PivotChart
338(4)
Creating a Pivot Chart
338(2)
Formatting a PivotChart
340(2)
Changing the PivotChartType
342(1)
Saving a Database Object as Another FileType
342(2)
Using the Save & Publish Tab
343(1)
Printing a Database Object
344(2)
Skill Summary
346(4)
Knowledge Assessment
346(1)
Competency Assessment
347(1)
Proficiency Assessment
348(1)
Mastery Assessment
349(1)
Internet Ready
349(1)
14 Import And Export Data 350(32)
Lesson Skill Matrix
350(1)
Key Terms
350(1)
Software Orientation: External Data Tab
351(1)
Importing Data
351(9)
Importing Data from a Specific Source
351(6)
Linking to an External Data Source
357(3)
Saving and Running Import Specifications
360(7)
Saving Specifications
361(4)
Running Import Specifications
365(2)
Exporting Data
367(4)
Exporting from a Table
367(3)
Exporting from a Query
370(1)
Saving and Running Export Specifications
371(5)
Saving Export Specifications
372(2)
Running Export Specifications
374(2)
Skill Summary
376(6)
Knowledge Assessment
376(2)
Competency Assessment
378(1)
Proficiency Assessment
379(1)
Mastery Assessment
380(1)
Internet Ready
381(1)
15 Database Tools 382(24)
Lesson Skill Matrix
382(1)
Key Terms
382(1)
Maintaining a Database
383(4)
Backing Up a Database
383(2)
Saving as a Previous Version
385(1)
Compacting and Repairing a Database
386(1)
Setting Database Properties
387(1)
Encrypting a Database
388(2)
Encrypting and Decrypting a Database
389(1)
Configuring Database Options
390(3)
Configuring Database Options
391(2)
Software Orientation: DatabaseToolsTab
393(1)
Using DatabaseTools
393(4)
Identifying Object Dependencies
393(1)
Using the Database Documenter
394(2)
Splitting a Database
396(1)
Skill Summary
397(4)
Knowledge Assessment
397(1)
Competency Assessment
398(1)
Proficiency Assessment
399(1)
Mastery Assessment
399(1)
Internet Ready
400(1)
Circling Back 3
401(5)
Appendix A 406(4)
Appendix B 410(1)
Glossary 411(3)
Credits 414(1)
Index 415
The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and studenttechnical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.