new perspectives on microsoft access 2013 tutorial answers

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. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.

New perspectives on microsoft access 2013 tutorial answers