Muutke küpsiste eelistusi

E-raamat: MOS 2016 Study Guide for Microsoft Access

4.33/5 (10 hinnangut Goodreads-ist)
  • Formaat: 240 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 28-Dec-2016
  • Kirjastus: Microsoft Press,U.S.
  • Keel: eng
  • ISBN-13: 9781509300228
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 9,75 €*
  • * 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 2016 Study Guide for Microsoft AccessSuurem pilt
  • Formaat: 240 pages
  • Sari: MOS Study Guide
  • Ilmumisaeg: 28-Dec-2016
  • Kirjastus: Microsoft Press,U.S.
  • Keel: eng
  • ISBN-13: 9781509300228
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 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.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97815093002282e.html
Märksõnad: