Schulungsunterlagen Access 2016 Weiterführung

Schulungsunterlage Access 2016 Weiterführung Englisch
Table of Contents
1 Theoretical Database Fundamentals .................................................................................... 5
1.1 Principles of a database ................................................................................................. 5
1.2 Conventional data processing and database ................................................................. 6
1.3 Tables ............................................................................................................................ 7
1.4 Primary and secondary keys.......................................................................................... 8
2 Database Design .................................................................................................................. 10
2.1 Normalization ............................................................................................................... 10
2.2 Exercise ....................................................................................................................... 14
2.3 Determining the relationships between the tables ....................................................... 15
2.4 Exercise ....................................................................................................................... 20
2.5 Exercise ....................................................................................................................... 21
3 Connecting Tables ............................................................................................................... 23
3.1 Main and detail table .................................................................................................... 23
3.2 Creating relationships between tables ......................................................................... 23
3.3 Editing relationships ..................................................................................................... 25
3.4 Deleting relationships ................................................................................................... 26
3.5 Referential integrity ...................................................................................................... 26
3.6 Subdatasheets ............................................................................................................. 28
3.7 Exercise ....................................................................................................................... 29
4 Formulas and Functions ..................................................................................................... 30
4.1 Facts on formulas and functions worth knowing .......................................................... 30
4.2 Summary ...................................................................................................................... 33
4.3 Functions...................................................................................................................... 33
5 Queries .................................................................................................................................. 40
5.1 Queries across several tables...................................................................................... 40
5.2 Calculations in queries ................................................................................................. 41
5.3 Field properties in queries ............................................................................................ 43
5.4 Exercise ....................................................................................................................... 45
5.5 Action queries .............................................................................................................. 46
5.6 Parameter query .......................................................................................................... 56
6 Queries Using SQL............................................................................................................... 57
6.1 Basic structure of the SELECT command ................................................................... 57
6.2 Setting the font size in query design and in SQL Editor .............................................. 58
6.3 Summary ...................................................................................................................... 59
6.4 Creating a query using an SQL command................................................................... 59
6.5 Components of the SELECT command ....................................................................... 60
6.6 JOIN operation ............................................................................................................. 64
6.7 Predicates .................................................................................................................... 65
7 Forms .................................................................................................................................... 66
7.1 Creating a new form ..................................................................................................... 66
7.2 Record source .............................................................................................................. 68
7.3 Controls ........................................................................................................................ 69
7.4 Inserting controls .......................................................................................................... 72
7.5 Changing the size and position of the bound fields ..................................................... 76
7.6 Exercise ....................................................................................................................... 77
7.7 Inserting objects ........................................................................................................... 83
7.8 Lines and rectangles .................................................................................................... 84
7.9 Alignment tools ............................................................................................................ 85
7.10 Properties ..................................................................................................................... 85
Musterseite aus dem Dettmer-Verlag, D-76889 Kapellen
www.dettmer-verlag.de
3
Schulungsunterlage Access 2016 Weiterführung Englisch
8
9
10
11
7.11 Defining the field order ................................................................................................. 86
7.12 Exercise ....................................................................................................................... 87
7.13 Split form ...................................................................................................................... 88
7.14 Subforms ...................................................................................................................... 89
7.15 Exercise ....................................................................................................................... 92
Reports .................................................................................................................................. 94
8.1 Creating a new report .................................................................................................. 94
8.2 Report sections ............................................................................................................ 95
8.3 Record source .............................................................................................................. 96
8.4 Group report ................................................................................................................. 96
8.5 Multi-column report ...................................................................................................... 98
8.6 Inserting data fields ...................................................................................................... 99
8.7 Report views .............................................................................................................. 101
8.8 Properties in reports ................................................................................................... 102
8.9 Inserting calculating fields and functions ................................................................... 103
8.10 Exercise ..................................................................................................................... 106
Privacy and Data Security ................................................................................................. 107
9.1 Data security .............................................................................................................. 107
9.2 Privacy ....................................................................................................................... 107
Appendix ............................................................................................................................. 109
10.1 Customizing the Quick Access Toolbar ..................................................................... 109
10.2 Setting the status bar ................................................................................................. 110
10.3 Solutions for the exercises on page 21 and page 29 ................................................ 110
Subject Index ...................................................................................................................... 116
Musterseite aus dem Dettmer-Verlag, D-76889 Kapellen
www.dettmer-verlag.de
4