You can create a table by creating a new database, by inserting a table into an existing database, or by importing or linking to a table from another data source - such as a Microsoft Excel workbook, a Microsoft Word document, a text file, or another database. ![]() When you create a new database, you create a new file on your computer that acts as a container for all of the objects in your database, including your tables. ![]() Many databases, however, use several tables. For more information, see Introduction to tables.Ī simple database, such as a contact list, might use only a single table. This article explains how to create a table, add fields to a table, set a table's primary key, and how to set field and table properties.īefore you create tables and add fields, make sure you understand the background concepts. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. When you create an Access database, you store your data in tables-subject-based lists that contain rows and columns. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
0 Comments
Leave a Reply. |