| Introduction |
|
ix | |
|
|
|
ix | |
|
How this book is organized |
|
|
ix | |
|
Download the practice files |
|
|
x | |
|
Sidebar: Adapting exercise steps |
|
|
xi | |
|
|
|
xii | |
|
Get support and give feedback |
|
|
xii | |
|
|
|
xii | |
|
|
|
xiii | |
|
|
|
xiii | |
| Taking a Microsoft Office Specialist exam |
|
xv | |
|
Microsoft Office Specialist certification |
|
|
xv | |
|
Selecting a certification path |
|
|
xv | |
|
|
|
xvi | |
|
|
|
xvii | |
|
|
|
xviii | |
| Prerequisites |
|
1 | (2) |
| 1 Create and manage databases |
|
3 | (50) |
|
|
|
4 | (12) |
|
Creating desktop databases |
|
|
5 | (2) |
|
|
|
7 | (2) |
|
Working with application parts |
|
|
9 | (5) |
|
Using earlier Access file formats |
|
|
14 | (1) |
|
|
|
15 | (1) |
|
1.2 Manage relationships and keys |
|
|
16 | (6) |
|
|
|
16 | (2) |
|
Setting and viewing relationships |
|
|
18 | (4) |
|
|
|
22 | (1) |
|
1.3 Navigate through databases |
|
|
22 | (9) |
|
Working with Access views |
|
|
23 | (1) |
|
|
|
23 | (2) |
|
Configuring the Navigation pane |
|
|
25 | (3) |
|
Building navigation forms |
|
|
28 | (2) |
|
|
|
30 | (1) |
|
1.4 Protect and maintain databases |
|
|
31 | (7) |
|
Compacting and repairing databases |
|
|
31 | (1) |
|
Encrypting database files |
|
|
32 | (2) |
|
|
|
34 | (1) |
|
Restoring data from a backup |
|
|
34 | (2) |
|
|
|
36 | (1) |
|
|
|
37 | (1) |
|
|
|
38 | (1) |
|
1.5 Print and export databases |
|
|
38 | (13) |
|
|
|
39 | (1) |
|
|
|
39 | (2) |
|
|
|
41 | (5) |
|
Saving databases as templates |
|
|
46 | (2) |
|
Using the Save Database As options |
|
|
48 | (3) |
|
|
|
51 | (1) |
|
|
|
51 | (2) |
| 2 Build tables |
|
53 | (42) |
|
|
|
53 | (15) |
|
Defining tables in Design view |
|
|
54 | (4) |
|
Creating tables in Datasheet view |
|
|
58 | (1) |
|
Importing data into a table |
|
|
58 | (5) |
|
Sidebar: Creating an import spec |
|
|
62 | (1) |
|
Sidebar: Importing data from other formats |
|
|
63 | (1) |
|
|
|
63 | (3) |
|
Creating tables in Access web.apps |
|
|
66 | (1) |
|
|
|
67 | (1) |
|
|
|
68 | (5) |
|
|
|
68 | (1) |
|
|
|
69 | (2) |
|
|
|
71 | (1) |
|
Adding table descriptions |
|
|
71 | (1) |
|
|
|
72 | (1) |
|
|
|
73 | (1) |
|
|
|
73 | (11) |
|
Adding, updating, and deleting records |
|
|
74 | (1) |
|
|
|
75 | (1) |
|
Finding, sorting, and filtering data |
|
|
76 | (8) |
|
|
|
84 | (1) |
|
2.4 Create and modify fields |
|
|
84 | (10) |
|
Adding and deleting fields |
|
|
84 | (3) |
|
Working with field properties |
|
|
87 | (4) |
|
Sidebar: Other field properties available in Datasheet view |
|
|
90 | (1) |
|
Changing field data types |
|
|
91 | (1) |
|
Sidebar: Configuring fields to auto-increment |
|
|
92 | (1) |
|
|
|
92 | (2) |
|
|
|
94 | (1) |
|
|
|
94 | (1) |
| 3 Create queries |
|
95 | (34) |
|
|
|
95 | (21) |
|
|
|
96 | (1) |
|
Saving and deleting queries |
|
|
96 | (1) |
|
|
|
97 | (6) |
|
Creating parameter queries |
|
|
103 | (2) |
|
|
|
105 | (5) |
|
Viewing data in a crosstab query |
|
|
110 | (3) |
|
Sidebar: Union, pass-through, and data definition queries |
|
|
113 | (1) |
|
Managing multiple tables and joins |
|
|
113 | (2) |
|
|
|
115 | (1) |
|
|
|
116 | (4) |
|
Changing the fields in a query |
|
|
116 | (1) |
|
Showing and hiding query fields |
|
|
117 | (1) |
|
Specifying the sort order for queries |
|
|
118 | (1) |
|
Formatting fields in a query |
|
|
119 | (1) |
|
|
|
120 | (1) |
|
3.3 Utilize calculated fields and grouping within queries |
|
|
120 | (8) |
|
Grouping and summarizing query records |
|
|
120 | (4) |
|
Sidebar: Creating custom field names |
|
|
123 | (1) |
|
|
|
124 | (1) |
|
Using operators in query criteria and expressions |
|
|
125 | (1) |
|
Entering expressions in the Zoom dialog box |
|
|
126 | (2) |
|
Sidebar: Getting help from the Expression Builder |
|
|
126 | (2) |
|
|
|
128 | (1) |
|
|
|
128 | (1) |
| 4 Create forms |
|
129 | (42) |
|
|
|
130 | (15) |
|
Building forms by using the Form wizard |
|
|
131 | (2) |
|
Sidebar: Creating a main form and a subform |
|
|
132 | (1) |
|
Creating forms in Layout view |
|
|
133 | (3) |
|
Creating forms in Design view |
|
|
136 | (3) |
|
|
|
139 | (1) |
|
|
|
140 | (2) |
|
Sidebar: Modifying existing forms |
|
|
142 | (1) |
|
Saving and deleting forms |
|
|
142 | (1) |
|
Creating views in an Access web app |
|
|
143 | (2) |
|
|
|
145 | (1) |
|
|
|
145 | (16) |
|
Adding, moving, and deleting form controls |
|
|
146 | (6) |
|
Sidebar: Using control wizards |
|
|
148 | (4) |
|
|
|
152 | (2) |
|
|
|
154 | (2) |
|
Sizing and ordering controls in Design view |
|
|
156 | (1) |
|
Working with control layouts in Layout view |
|
|
157 | (2) |
|
|
|
159 | (1) |
|
|
|
160 | (1) |
|
|
|
161 | (9) |
|
Setting the tab order for forms |
|
|
161 | (2) |
|
|
|
163 | (1) |
|
|
|
164 | (1) |
|
Applying themes to a form |
|
|
165 | (2) |
|
Modifying a form's background |
|
|
167 | (2) |
|
Using a form header and footer |
|
|
169 | (1) |
|
|
|
169 | (1) |
|
|
|
170 | (1) |
|
|
|
170 | (1) |
| 5 Create reports |
|
171 | (34) |
|
|
|
173 | (11) |
|
Running the Report wizard |
|
|
174 | (3) |
|
Building reports in Layout view |
|
|
177 | (3) |
|
Using report design tools |
|
|
180 | (2) |
|
|
|
182 | (1) |
|
|
|
183 | (1) |
|
|
|
183 | (1) |
|
|
|
184 | (10) |
|
Adding controls to a report |
|
|
184 | (1) |
|
Managing report fields and properties |
|
|
185 | (1) |
|
Formatting report controls |
|
|
186 | (1) |
|
|
|
187 | (2) |
|
|
|
189 | (1) |
|
Grouping and sorting fields |
|
|
190 | (4) |
|
|
|
194 | (1) |
|
|
|
194 | (9) |
|
Applying themes to reports |
|
|
194 | (1) |
|
Adding information to report headers and footers |
|
|
195 | (2) |
|
Adding backgrounds and images to a report |
|
|
197 | (1) |
|
Applying page setup options |
|
|
198 | (3) |
|
|
|
201 | (1) |
|
Sorting records in a report |
|
|
202 | (1) |
|
|
|
203 | (1) |
|
|
|
203 | (2) |
| Index |
|
205 | (8) |
| About the author |
|
213 | |
Lisainfo e-raamatute kohta