Atnaujinkite slapukų nuostatas

El. knyga: MOS Study Guide for Microsoft Access Expert Exam MO-500

4.33/5 (4 ratings by Goodreads)
  • Formatas: 192 pages
  • Serija: MOS Study Guide
  • Išleidimo metai: 08-Apr-2020
  • Leidėjas: Addison Wesley
  • Kalba: eng
  • ISBN-13: 9780136628316
Kitos knygos pagal šią temą:
MOS Study Guide for Microsoft Access Expert Exam MO-500Didesnis paveikslėlis
  • Formatas: 192 pages
  • Serija: MOS Study Guide
  • Išleidimo metai: 08-Apr-2020
  • Leidėjas: Addison Wesley
  • Kalba: eng
  • ISBN-13: 9780136628316
Kitos knygos pagal šią temą:

DRM apribojimai

  • Kopijuoti:

    neleidžiama

  • Spausdinti:

    neleidžiama

  • El. knygos naudojimas:

    Skaitmeninių teisių valdymas (DRM)
    Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos  čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

    Reikalinga programinė įranga
    Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

    Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga  Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

    Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

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.
Daugiau apie elektronines knygas Daugiau apie elektronines knygas
Pastovi nuoroda: https://www.kriso.lt/db/97801366283162e.html
Raktažodžiai: