Table of Contents

1 Preliminary Notes

2 Theoretical Database Fundamentals

2.1 Principles of a database
2.2 Conventional data processing and database
2.3 Tables
2.4 Primary and secondary keys

3 Database Design

3.1 Normalization
3.2 Exercise
3.3 Determining the relationships between the tables
3.4 Exercise
3.5 Exercise

4 Connecting Tables

4.1 Main and detail table
4.2 Creating relationships between tables
4.3 Editing relationships
4.4 Deleting relationships
4.5 Referential integrity
4.6 Subdatasheets
4.7 Exercise

5 Formulas and Functions

5.1 Facts on formulas and functions worth knowing
5.2 Summary
5.3 Functions

6 Queries

6.1 Queries across several tables
6.2 Calculations in queries
6.3 Field properties in queries
6.4 Exercise
6.5 Action queries
6.6 Parameter query

7 Queries Using SQL

7.1 Basic structure of the SELECT command
7.2 Setting the font size in query design and in SQL Editor
7.3 Summary
7.4 Creating a query using an SQL command
7.5 Components of the SELECT command
7.6 JOIN operation
7.7 Predicates

8 Forms

8.1 Creating a new form
8.2 Record source
8.3 Controls
8.4 Inserting controls
8.5 Changing the size and position of the bound fields
8.6 Exercise
8.7 Inserting objects
8.8 Lines and rectangles
8.9 Alignment tools
8.10 Properties
8.11 Defining the field order
8.12 Exercise
8.13 Split form
8.14 Subforms
8.15 Exercise

9 Reports

9.1 Creating a new report
9.2 Report sections
9.3 Record source
9.4 Group report
9.5 Multi-column report
9.6 Inserting data fields
9.7 Report views
9.8 Properties in reports
9.9 Inserting calculating fields and functions
9.10 Exercise

10 Privacy and Data Security

10.1 Data security
10.2 Privacy

11 Appendix

11.1 Customizing the Quick Access Toolbar
11.2 Setting the status bar
11.3 Solutions for the exercises on page 27 and page 36

12 Subject Index