Introducing Microsoft Access Using Macro Programming Techniques: An Introduction to Desktop Database Development by Example

© Flavio Morgado 2021

F. MorgadoIntroducing Microsoft Access Using Macro Programming Techniqueshttps://doi.org/10.1007/978-1-4842-6555-0_2

2. Creating and Using Database Tables

Flavio Morgado¹  

(1)

Teresopolis, Rio de Janeiro, Brazil

 

In this chapter, you will learn how to create and use Access database tables. You’ll define field types and properties, use the AutoNumber field type to create a primary key, and find out how a table behaves as records are inserted and deleted. You will also learn about record locks and how Microsoft Access manages them.

In this chapter, you’ll do the following:

• Understand related tables and where information is stored.

• Learn the ins and outs of the many useful things in Microsoft Access such as the primary key, autonumbering, ...