Chapter 1 : Table and objects

1.1 The table

1.1.1 Creating a database

A) The File menu 

B) The Home menu

C) The Create menu

D) The External Data menu

E) The Database Tools menu

1.1.2 The table structure

1.1.3 Designing a table

1.2 Handling the data inside a table

1.2.1 The columns

1.2.2 The filters

1.3 The table properties

1.3.1 The properties of text type

1.3.2 The properties of number type

1.3.3 The properties of type date

1.3.4 The property of AutoNumber type

1.3.5 The replication ID property

1.4 The lookup properties

1.5 The Total row in a table

Chapter 2 : Relationships

2.1 Defining relationships

2.2 The relational model

2.2.1 Selecting tables

2.2.2 Creating the relationship

2.2.3 Modifying the relationship

2.2.4 Enforcing the relationship

2.2.5 The join properties

2.2.6 Viewing links in the table

Chapter 3 : Queries

3.1 Creating a query

3.1.1 The Query wizard

3.1.2 Creating a query manually

3.1.3 Selecting fields

3.1.4 The filter criteria

A) Filtering with two words

B) Filtering with the wildcard * and the Like operator

C) Filtering with a simple date

D) The Null operator

3.1.5 Sorting the data

3.2 Grouping the data and calculating

3.3 Elaborated queries

3.3.1 Creating an Update query

3.3.2 Creating a Delete query

3.3.3 The Append query

3.3.4 The Make table query

3.3.5 The Crosstab query

3.3.6 The Union query

3.3.7 Using the function DatePart in a query

3.3.8 The parameterized query

Chapter 4 : Forms

4.1 Creating a form

4 .1.1 A table-based form

4.1.2 The controls

4.1.3 The Form Wizard

4.1.4 Field tools

4.2 A Form with a subform

4.3 Creating a blank form

Chapter 5 : Macros

5.1 Creating a macro

5.1.1 A macro to filter

5.1.2 Running a macro from a Command Button

5.2 A field, an event and a macro

5.3 Actions and VBA keyword

5.4 A conditional macro

Chapter 6 : The VBA language

6.1 The development environment

6.2 Acting with DoCmd

6.2.1 Opening and searching

6.2.2 Exporting a table to Excel

6.2.3 Importing an Excel spreadsheet

6.2.4 Running a query with DoCmd

6.2.5 Running queries automatically

6.3. Opening a database with VBA