You can set database options that can be used to modify the design of Access desktop database objects by clicking File, Options, and then Object Designers.

You can use the SetProperty action in desktop databases to set the following properties of a control: Enabled, Visible, Locked, Left, Top, Width, Height, Fore Color, Back Color, or Caption.

Access provides several tools that you can use to familiarize yourself with the structure of a particular database. This article also explains how, when, and why you use each tool.

Specifically, Access can help you print table relationships as depicted in the Relationship window, and can help you print the design characteristics of database objects, such as object properties.

This article describes the data types and other field properties available in Access, and includes additional information in a detailed data type reference section.

In an Access database, table properties are attributes of a table that affect the appearance or behavior of the table as a whole. Table properties are set in the table's property sheet, in Design view.

When you create an Access database, you store your data in tables—subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, …

Learn about using macros and VBA code in Access databases to program and automate your applications.

Get help with your questions about Microsoft Access with our how-to articles, training videos, and support content.

In a Microsoft Access database (.mdb or .accdb), you can add the property by using the CreateProperty method and then appending it to the Properties collection of the Database object.