03 – Tables

In this post we will be examining tables, data types and primary keys. Being able to manipulate tables is a fundamental requirement of working with Microsoft Access. We will be showing you how to work with different data types, how to set primary keys, how indexing works and much more.

List of topics covered:

  • Creating a New Table
  • Table Design View
  • Adding Fields
  • Save the Table
  • Data Types
  • Primary Keys
  • Setting the Primary Key
  • Indexes and Primary Keys
  • Composite Primary Keys - InvoiceLines
  • Default Values and Field Properties
  • Datasheet View
  • Adding A New Record
  • Deleting A Record
  • Navigating the Datasheet
  • Updating Records
  • Sorting and Filtering
  • Printing Records
  • Formatting the Datasheet
  • Background Colour and Alternate Rows
  • Adding Records
  • Field Lookups

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!