Microsoft Access 2013

Section 2: Creating a custom Web App - Page 23
Starting Access - Page 24
Creating a custom Web App - Page 25
Adding a table template - Page 26
Showing the navigation pane - Page 27
Adding a blank table - Page 28
Launching a Web App - Page 29
Working with the List view - Page 30
Working with the Datasheet view - Page 31
Working with a summary view - Page 32
Finding your site and navigating to the team site - Page 33
Creating a Web App using a template - Page 34
Section 3: Modifying a Web App - Page 35
Importing from an Access desktop database - Page 36
Importing from an Access desktop database - Page 37
Changing the design of a table - Page 38
Changing the design of a table - Page 39
Creating a lookup/relationship - Page 40
Creating a lookup/relationship - Page 41
Designing with a List Details view - Page 42
Designing with a List Details view - Page 43
Designing with a Datasheet view - Page 44
Designing with a Datasheet view - Page 45
Designing with a summary view - Page 46
Designing with a summary view - Page 47
Designing with a blank view - Page 48
Designing with a blank view - Page 49
Open, rename, duplicate, or delete a view - Page 50
Open, rename, duplicate, or delete a view - Page 51
Creating a query - Page 52
Creating a query - Page 53
Modifying the Table Selector - Page 54
Modifying the Table Selector - Page 55
Working with reports - Page 56
Section 4: Creating a desktop database - Page 57
Creating a blank desktop database - Page 58
Creating a blank desktop database - Page 59
Creating a table in design view - Page 60
Creating a table in design view - Page 61
Creating a table in layout view - Page 62
Creating a table in layout view - Page 63
Working with data parts in layout view - Page 64
Working with data parts in layout view - Page 65
Creating a table by using application parts - Page 66
Creating a table by using application parts - Page 67
Adding a primary key - Page 68
Improving performance by indexing data - Page 69
Validate that data in a field is of the correct type - Page 70
Validate that data in a field is of the correct type - Page 71
Validate that data in a field is of the correct type - Page 72
Validate that data in a field is of the correct type - Page 73
Comparing field values by using table validation - Page 74
Formatting a field - Page 75
Recording changes to text and rich text formatting - Page 76
Recording changes to text and rich text formatting - Page 77
Creating relationships by using the Lookup Wizard - Page 78
Creating relationships by using the Lookup Wizard - Page 79
Viewing relationships - Page 80
Deleting relationships - Page 81
Adding relationships - Page 82
Adding relationships - Page 83
Adding relationships - Page 84
Section 5: Working with data in datasheets - Page 85
Changing Access database options - Page 86
Changing Access database options - Page 87
Altering the presentation by ordering, hiding, and freezing fields - Page 88
Altering the presentation by ordering, hiding, and freezing fields - Page 89
Moving between records and using Find And Replace - Page 90
Sorting datasheet rows - Page 91
Filtering datasheet rows - Page 92
Filtering datasheet rows - Page 93
Filtering combinations of choices with Filter By Form - Page 94
Filtering combinations of choices with Filter By Form - Page 95
Filtering combinations of choices with Advanced Filter/Sort - Page 96
Inserting and updating records - Page 97
Deleting records - Page 98
Deleting records - Page 99
Creating summary data for records - Page 100
Displaying related information with a subdatasheet - Page 101
Adjusting column/row height and formatting - Page 102
Adjusting column/row height and formatting - Page 103
Selecting data to copy and paste - Page 104
Selecting data to copy and paste - Page 105
Displaying more information with the Zoom box - Page 106
Changing the datasheet presentation - Page 107
Changing the datasheet presentation - Page 108
Section 6: Selecting data using queries - Page 109
Selecting all columns from a table - Page 110
Selecting all columns from a table - Page 111
Selecting individual columns from one or more tables - Page 112
Selecting individual columns from one or more tables - Page 113
Joining tables to see unmatched or missing records - Page 114
Joining tables to see unmatched or missing records - Page 115
Filtering by single and multiple combinations of choices - Page 116
Filtering by single and multiple combinations of choices - Page 117
Adding calculations with the expression builder - Page 118
Adding calculations with the expression builder - Page 119
Returning the top matched records - Page 120
Eliminating duplicate values - Page 121
Creating a summary calculation - Page 122
Prompting to filter data with parameters - Page 123
Creating a crosstab query with the Query Wizard - Page 124
Creating a crosstab query with the Query Wizard - Page 125
Simplifying a problem with a query by using other queries - Page 126
Adding two sets of query results together - Page 127
Resolving ambiguous outer joins - Page 128
Creating an additional query to resolve a problem with mixed joins - Page 129
Creating an additional query to resolve a problem with mixed joins - Page 130
Section 7: Modifying data using queries - Page 131
Creating a table by using a Make Table query - Page 132
Creating a table by using a Make Table query - Page 133
Changing data in a table with an Update query - Page 134
Changing data in a table with an Update query - Page 135
Adding data to an existing table with an Append query - Page 136
Deleting data in tables with a Delete query - Page 137
Updating a column based on an expression - Page 138
Updating a column based on an expression - Page 139
Adding only new data that is not already in a table - Page 140
Resetting an AutoNumber with an Append query - Page 141
Resetting an AutoNumber with an Append query - Page 142
Section 8: Improving presentations with forms - Page 143
Creating a continuous form with the multiple items template - Page 144
Creating a continuous form with the multiple items template - Page 145
Creating a datasheet form with conditional formatting - Page 146
Creating a datasheet form with conditional formatting - Page 147
Creating a single record form with the Form Wizard - Page 148
Creating a split form - Page 149
Working with form views - Page 150
Working with control layouts - Page 151
Creating a parent/child form with the Form Wizard - Page 152
Creating a parent/child form with the Form Wizard - Page 153
Altering link master and link child fields - Page 154
Controlling editing and data entry in a form - Page 155
Changing the data source for a form - Page 156
Changing the data source for a form - Page 157
Organizing your database with navigation forms - Page 158
Organizing your database with navigation forms - Page 159
Adding fields to a form in design view - Page 160
Adding fields to a form in design view - Page 161
Adding fields to a form in layout view - Page 162
Adding fields to a form in layout view - Page 163
Adding a subform to an existing form - Page 164
Section 9: Using controls effectively - Page 165
Creating labels and text boxes - Page 166
Creating lines and rectangles - Page 167
Creating check boxes, option buttons, and toggle buttons - Page 168
Creating check boxes, option buttons, and toggle buttons - Page 169
Creating option groups - Page 170
Creating option groups - Page 171
Creating list boxes - Page 172
Creating list boxes - Page 173
Creating combo boxes - Page 174
Creating combo boxes - Page 175
Creating hyperlinks - Page 176
Creating logos and titles - Page 177
Creating bound and unbound object frames - Page 178
Creating bound and unbound object frames - Page 179
Creating image controls - Page 180
Creating image controls - Page 181
Creating attachments - Page 182
Creating web browser controls - Page 183
Working with tab controls - Page 184
Working with tab controls - Page 185
Creating command buttons - Page 186
Setting control defaults - Page 187
Applying Office themes - Page 188
Section 10: Preparing data to print using reports - Page 189
Creating a tabular report with multiple tables - Page 190
Creating a tabular report with multiple tables - Page 191
Creating a tabular report with multiple tables - Page 192
Creating a tabular report with multiple tables - Page 193
Altering the presentation of controls on a page - Page 194
Altering the presentation of controls on a page - Page 195
Working with controls and sections - Page 196
Working with controls and sections - Page 197
Using the Can Grow and Can Shrink Properties - Page 198
Adding a running sum - Page 199
Managing data and page breaks - Page 200
Managing data and page breaks - Page 201
Adding sorting and grouping on reports - Page 202
Adding sorting and grouping on reports - Page 203
Avoiding blank pages - Page 204
Adding conditional formatting - Page 205
Creating a single record report with the Report Wizard - Page 206
Creating a single record report with the Report Wizard - Page 207
Creating a parent/child report - Page 208
Creating a parent/child report - Page 209
Using labels and managing columns and rows - Page 210
Using labels and managing columns and rows - Page 211
Working with layout view, report view, and Print Preview - Page 212
Working with layout view, report view, and Print Preview - Page 213
Working with layout view, report view, and Print Preview - Page 214
Section 11: Exchanging data - Page 215
Importing data and objects from Access - Page 216
Importing data and objects from Access - Page 217
Linking to data in Access - Page 218
Linking to data in Access - Page 219
Importing data from Excel - Page 220
Importing data from Excel - Page 221
Linking to data in Excel - Page 222
Refreshing linked tables when files are changed - Page 223
Importing data from text files using specifications - Page 224
Importing data from text files using specifications - Page 225
Importing data from text files using specifications - Page 226
Importing data from text files using specifications - Page 227
Exporting data to Excel - Page 228
Exporting data to Excel - Page 229
Working with saved imports and exports - Page 230
Working with saved imports and exports - Page 231
Exporting data as PDF documents - Page 232
Section 12: Introducing the power of macros - Page 233
Enabling macro commands and disabling Trusted Documents - Page 234
Enabling macro commands and disabling Trusted Documents - Page 235
Linking together forms - Page 236
Linking together forms - Page 237
Linking a form to a query - Page 238
Linking a form to a query - Page 239
Validating data entered in controls - Page 240
Validating data entered in controls - Page 241
Making controls change other controls - Page 242
Making controls change other controls - Page 243
Processing data with action queries - Page 244
Processing data with action queries - Page 245
Executing a saved import/export - Page 246
Section 13: Administrating a database - Page 247
Compacting and repairing your database - Page 248
Compacting and repairing your database - Page 249
Analyzing your database - Page 250
Analyzing your database - Page 251
Protecting your data - Page 252
Protecting your data - Page 253
Viewing object dependencies - Page 254