Access-+tables

Type in the content of your page here. Let’s create some tables and forms in access. In the create tab there are groups like: tables, forms, reports, and other. These are four most important parts of access. Let me show you how to use tables group. Open new access worksheet. Once you do that, click on blank database, located on the left hand side. On your right hand side on the button of the screen there is a field called fill name. We need to give a name to the database. Let’s called it Magda’s database, and then hit create button. Right now you are looking at the empty database which soon we will fill with tables. Let’s create a table in design view. In order for you to do this, you need to go to datasheet tab, then in the view group click on the view arrow. Next click on the design view. Now you should have small box which asks you for a name of the documents, let’s call it products, and click ok. We will allow access to create our primary key. Now we will create our table. Under ID field type name. Once you click tab to go to the next field you will to see a massage on your screen. Just click ok, next in the field column type in category, price, and supplier. Now we need to specified data type. Data type for price it will be currency. Click on the data type column, then click the arrow down and choose currency style. We have defined all our fields. There are more options in the field below our database. If you would like to, you are welcome to take a look at it. And save it. Now in the upper left hand corner in the design tab in the view group, click on the view arrow and choose datasheet view. We are ready to use our database and actually enter more information into the database. Let’s enter same information. In the name field type in Milky Way bar, then category: food, price: $1.20 and supplier Mars. You are allowed to type as much information you would like to. Make sure you save all your hard work. We just created a table which is a way to keep track of information about specific entities. The data in a table does not have to be physically stored in the database. Views are also relational tables, but their data are calculated at query time. Other examples are nicknames, which represent a pointer to a table in another database. In addition to that let’s create another table. Go to the create tab, then in the tables group click on the table design button. Now we are going to create table for all our customers. In the field name type ID, and in the date type choose auto number. There are many circumstances which you could follow as the search dominant. Let’s keep track of our database based on their last name, which would be a text field. You can also need first name, email address, date of birth which is going to be date type as date / time. You can use as much information as you think is necessary. After entering all needed information go to left hand corner, in the view group, then click on view arrow and choose datasheet view. Prior to that you need to save your work. Then name your database. We are going to name it as customer table. Microsoft Office Access will ask you if there are no primary key defined, just click yes. Now we can go ahead and enter all information about our customers. Once you enter necessary information your table is ready. Go ahead and play with all the access options. It is amazing program, if used correctly it may make your task easier.