It explains how to create a desktop database by using a template, and how to build a database from scratch by creating your own tables, forms, reports, and other database objects.

When you design your database, always try to record each fact just once. If you find yourself repeating the same information in more than one place, such as the address for a particular …

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 customize various settings for your Access desktop databases by clicking File > Options > Client Settings. The settings that you make from this category apply to all Access desktop …

If you want to organize and manage your data with Access but just don't want to spend time creating a database from scratch, try using a desktop database template. What is an Access …

In Access, you customize the Ribbon by creating customization XML and then adding code or setting database properties that instruct Access to use that XML when it creates the Ribbon.

Design your database with your data processing and reporting needs in mind. To improve the long-term usefulness of your databases, follow these five design steps:

Add structured or blank tables to the web app, or create tables from existing data sources. Search for a table template based on the type of information you want to track, create a table from the …

You can select the way in which the objects in the database are displayed in the Navigation Pane. For example, you can include the creation or modified dates, or display objects as icons or lists.

Create custom categories and groups in the Navigation Pane, so you can organize your Access database objects to fit your needs.