O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Designing tables in a desktop database

Creating a new desktop database

Creating your first simple table by entering data

Creating a table using Application Parts

Creating a table using Data Type Parts

Creating a table in Design view

Defining fields

Defining a primary key

Defining a table validation rule

Understanding other table properties

Defining relationships

Adding indexes

Setting table design options

Database limitations

DEFINING tables in a Microsoft Access 2013 desktop database (.accdb file) is very easy. This chapter shows you how it’s done. You’ll learn how to:

  • Create a new desktop database application using a database template.

  • Create a new empty database for your own custom application.

  • Create a simple table by entering data directly in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required