![]() ![]() In the Open dialog box, select the database that you want to open, and then click Open. If not, select one of the browse options to locate the database. Top of Page Create a new table in an existing databaseĬlick File > Open, and click the database if it is listed under Recent. The new database opens, and a new table named Table1 is created and opens in Datasheet view. To browse to a different location and save the database, click the folder icon. ![]() In the File Name box, type a file name for the new database. Top of Page Create a new table in a new databaseĬlick File > New, and then select Blank desktop database. You can then enter data in the table to start defining your fields. When you create a new, blank database, a new, empty table is automatically inserted for you. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |