We are going to create a simple Orders table. It allows you to create separate sets of data, and link them together, to keep your information organized. This is the main benefit of creating databases. Now, we're going to create a second table, and then link it to the first table. Once you enter data into the blank line, a new blank line will appear. You can enter this data by typing it into the cell, and pressing Tab or clicking on the next cell. Interested in learning more? Why not take an online Microsoft Access 2013 course? We're going to make our Primary Key ISBN. By clicking on ID, you can also add your Primary key. In Design View, you can go ahead and name the table columns and apply constraints over them in the Field Properties at the bottom of the above pictured window. This is where you can design the table by determining what fields you want to store in the table.Īccess will ask you to name the table. There are several different views in Access 2013. On the left hand side of the screen, right click Table1 and select Design View. You can click on the Table1 or Table2 tab to navigate between tables. Click Table to add another table.Īccess creates one table for you by default, so when we do this, we'll have two tables, as shown below. You'll see it to the right of the File tab. To create a new table, go to the Create tab. But remember, to add data, we must first create tables.
0 kommentar(er)
