Atnaujinkite slapukų nuostatas

El. knyga: MOS 2016 Study Guide for Microsoft Access

4.33/5 (10 ratings by Goodreads)
  • Formatas: 240 pages
  • Serija: MOS Study Guide
  • Išleidimo metai: 28-Dec-2016
  • Leidėjas: Microsoft Press,U.S.
  • Kalba: eng
  • ISBN-13: 9781509300228
Kitos knygos pagal šią temą:
MOS 2016 Study Guide for Microsoft AccessDidesnis paveikslėlis
  • Formatas: 240 pages
  • Serija: MOS Study Guide
  • Išleidimo metai: 28-Dec-2016
  • Leidėjas: Microsoft Press,U.S.
  • Kalba: eng
  • ISBN-13: 9781509300228
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 2016. 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 2016 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 youve 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
Introduction ix
Taking a Microsoft Office Specialist exam xv
Exam 77-730 Access 2016: Core Database Management, Manipulation, and Query Skills 1(1)
Prerequisites 2(3)
1 Create and manage databases
5(52)
Objective 1.1 Create and modify databases
6(14)
Create databases
6(3)
Import database objects and data
9(8)
Delete database objects
17(1)
Objective 1.1 Practice Tasks
18(2)
Objective 1.2 Manage relationships and keys
20(8)
Create and modify relationships
20(4)
Set key fields
24(3)
Objective 1.2 Practice Tasks
27(1)
Objective 1.3 Navigate through a database
28(9)
Navigate specific records
28(2)
Create and modify navigation forms
30(1)
Set a form as the startup option
31(1)
Display objects in the Navigation Pane
31(3)
Change object views
34(2)
Objective 1.3 Practice Tasks
36(1)
Objective 1.4 Protect and maintain databases
37(9)
Compact and repair databases
37(2)
Back up and restore databases
39(2)
Split a database
41(2)
Encrypt database files
43(2)
Objective 1.4 Practice Tasks
45(1)
Objective 1.5 Print and export data
46(11)
Print reports and records
46(2)
Save a database as a template
48(2)
Export data
50(5)
Objective 1.5 Practice Tasks
55(2)
2 Build tables
57(40)
Objective 2.1 Create tables
58(11)
Create tables
58(4)
Create linked tables
62(4)
Create a table from a template by using application parts
66(2)
Objective 2.1 Practice Tasks
68(1)
Objective 2.2 Manage tables
69(6)
Hide fields in tables
69(2)
Add Total rows
71(1)
Add table descriptions
72(1)
Rename tables
72(2)
Objective 2.2 Practice Tasks
74(1)
Objective 2.3 Manage records in tables
75(11)
Add, update, and delete records
75(1)
Append records from external data
76(2)
Find, sort, and filter data
78(7)
Objective 2.3 Practice Tasks
85(1)
Objective 2.4 Create and modify fields
86(11)
Add and delete fields
86(3)
Add validation rules to fields
89(1)
Modify field properties
90(2)
Automate field values and formatting
92(3)
Objective 2.4 Practice Tasks
95(2)
3 Create queries
97(38)
Objective 3.1 Create queries
98(22)
Run queries
98(1)
Create select queries
99(5)
Create crosstab queries
104(3)
Create parameter queries
107(2)
Create action queries
109(4)
Create multiple-table queries
113(2)
Save queries
115(3)
Objective 3.1 Practice Tasks
118(2)
Objective 3.2 Modify queries
120(6)
Rename queries
120(1)
Change the fields in a query
120(2)
Show and hide query fields
122(1)
Specify the sort order for queries
123(1)
Format fields in a query
123(2)
Objective 3.2 Practice Tasks
125(1)
Objective 3.3 Create calculated fields and grouping within queries
126(9)
Use calculated fields
126(2)
Set filter criteria
128(2)
Group and summarize query records
130(2)
Group data by using operators
132(2)
Objective 3.3 Practice Tasks
134(1)
4 Create forms
135(40)
Objective 4.1 Create forms
136(11)
Create quick forms
137(1)
Create forms by using the Form Wizard
138(1)
Create forms from scratch
139(5)
Create forms from templates by using application parts
144(1)
Save forms
145(1)
Objective 4.1 Practice Tasks
146(1)
Objective 4.2 Configure form controls
147(15)
Move controls
147(2)
Add and remove controls
149(2)
Set control properties
151(5)
Modify data sources
156(1)
Manage labels
157(1)
Create subforms
158(2)
Objective 4.2 Practice Tasks
160(2)
Objective 4.3 Format forms
162(13)
Set tab order
162(2)
Configure print settings
164(1)
Sort records
165(1)
Apply themes to forms
165(3)
Control form positioning
168(2)
Modify the background of a form
170(2)
Insert form headers and footers
172(1)
Insert images
173(1)
Objective 4.3 Practice Tasks
174(1)
5 Create reports
175(30)
Objective 5.1 Create reports
176(9)
Use the Report Wizard
177(3)
Create reports from scratch
180(4)
Objective 5.1 Practice Tasks
184(1)
Objective 5.2 Configure report controls
185(9)
Group and sort records
185(2)
Modify data sources
187(2)
Add controls to a report
189(2)
Add and modify labels
191(2)
Objective 5.2 Practice Tasks
193(1)
Objective 5.3 Format reports
194(11)
Apply page setup options
194(3)
Add a calculated field
197(1)
Format report elements
198(2)
Add information to report headers and footers
200(2)
Objective 5.3 Practice Tasks
202(3)
Index 205(12)
About the author 217
John Pierce is a freelance editor and writer. He is the author of Team Collaboration: Using Microsoft Office for More Effective Teamwork and other books about Microsoft Office, including the MOS 2013 Study Guide for Microsoft Access.
Daugiau apie elektronines knygas Daugiau apie elektronines knygas
Pastovi nuoroda: https://www.kriso.lt/db/97815093002282e.html
Raktažodžiai: