Muutke küpsiste eelistusi

E-raamat: MOS Study Guide for Microsoft Access Expert Exam MO-500

4.33/5 (4 hinnangut Goodreads-ist)
  • Formaat: 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 08-Apr-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136628316
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 17,54 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
MOS Study Guide for Microsoft Access Expert Exam MO-500Suurem pilt
  • Formaat: 192 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 08-Apr-2020
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780136628316
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Advance your everyday proficiency with Access 2019. And earn the credential that proves it!

Demonstrate your expertise with Microsoft Access! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Access 2019 certification, this official Study Guide delivers:
  • In-depth preparation for each MOS objective
  • Detailed procedures to help build the skills measured by the exam
  • Hands-on tasks to practice what you&;ve learned
  • Practice files and sample solutions
Sharpen the skills measured by these objectives:
  • Create and manage databases
  • Build tables
  • Create queries
  • Create forms
  • Create reports
About MOS

A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.


Introduction vi
Taking a Microsoft Office Specialist exam xi
About the Author xv
Exam MO-500 Microsoft Access Expert (Access and Access 2019) xvi
Prerequisites xvii
1 Manage databases
1(38)
Objective 1.1 Modify database structure
2(10)
Import objects or data from other sources
2(4)
Delete database objects
6(1)
Hide and display objects in the Navigation Pane
7(5)
Objective 1.2 Manage table relationships and keys
12(17)
Set primary keys
12(1)
Understand relationships
13(4)
Set foreign keys
17(1)
Understand relational database models
18(2)
Set relationships
20(5)
Enforce referential integrity
25(4)
Objective 1.3 Print and export data
29(10)
Configure print options for records, forms, and reports
29(2)
Export objects to alternative formats
31(8)
2 Create and modify tables
39(46)
Objective 2.1 Create tables
40(17)
Import data into a new table
41(6)
Append records from external data
47(2)
Create linked tables from external sources
49(3)
Import tables from other databases
52(5)
Objective 2.2 Manage tables
57(6)
Hide fields in tables
57(1)
Add Total rows
58(2)
Add table descriptions
60(3)
Objective 2.3 Manage table records
63(11)
Find and replace data
63(3)
Sort records
66(2)
Filter records
68(6)
Objective 2.4 Create and modify fields
74(11)
Add and delete fields
74(3)
Add validation rules to fields
77(2)
Modify field properties
79(1)
Automate field values and formatting
80(5)
3 Create and modify queries
85(32)
Objective 3.1 Create and run queries
86(23)
Run queries
87(1)
Create select queries
88(4)
Create crosstab queries
92(4)
Create parameter queries
96(1)
Create action queries
97(5)
Create multiple-table queries
102(2)
Save queries
104(5)
Objective 3.2 Modify queries
109(8)
Show and hide query fields
110(1)
Sort data within queries
111(1)
Use operators
112(1)
Filter data within queries
112(2)
Format fields within queries
114(3)
4 Modify forms in Layout view
117(22)
Objective 4.1 Configure form controls
118(11)
Add and remove controls
118(2)
Move controls
120(2)
Set control properties
122(4)
Manage labels
126(3)
Objective 4.2 Format forms
129(10)
Set tab order
129(2)
Sort records
131(1)
Control form positioning
132(1)
Insert form headers and footers
133(2)
Insert images
135(4)
5 Modify reports in Layout view
139(20)
Objective 5.1 Configure report controls
140(8)
Group and sort records
140(3)
Add controls to a report
143(2)
Add and modify labels
145(3)
Objective 5.2 Format reports
148(11)
Format a report into multiple columns
148(1)
Modify report positioning
149(2)
Format report elements
151(2)
Change report orientation
153(1)
Insert information in report headers and footers
154(1)
Insert images on reports
155(4)
Index 159
Paul McFedries is a Microsoft Access and database expert and full-time technical writer. Paul has been authoring computer books since 1991 and has nearly 100 books to his credit, which combined have sold more than 4 million copies worldwide. His titles include the Microsoft Press Publishing book Formulas and Functions for Microsoft Excel 2019, the Que Publishing books My Office 2016, My Office for iPad, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, aswell as the Wiley Publishing books Teach Yourself VISUALLY Microsoft Access and Teach Yourself VISUALLY Excel Data Analysis. Please drop by Pauls personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/paulmcf.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97801366283162e.html
Märksõnad: