A field in a database is where you keep a record of data. Each record can have more than one field and a field can have subordinate fields with related data in them.
Sometimes when you add fields, you will find that at a later stage you need more because you want to add more information. For example, you may have created a database with all your friend’s addresses but then decide you want to add other information like their birthdays too.
To do this, all you need to do is to open your database file in Microsoft Access and use the F11 key to open the database view. Click onto the ‘Tables’ tab and you will find that a list of tables will appear. Choose the table that you want and click ‘Open’.
Place your cursor in the field immediately before where you want your new field to appear. For example, if you have fields that are called Mickey, Minnie and Donald, and you want a new column between Mickey and Minnie, then place your cursor on Mickey.
Go to the ‘Insert’ menu and click on to ‘Column’ a new column will appear to the right of your cursor location and will be called Field 1. When you click onto that, a menu will appear. Click on ‘Rename’. The column will turn black and you will be able to add information to it. Once you’ve done that, don’t forget to save it.
Sometimes when you add fields, you will find that at a later stage you need more because you want to add more information. For example, you may have created a database with all your friend’s addresses but then decide you want to add other information like their birthdays too.
To do this, all you need to do is to open your database file in Microsoft Access and use the F11 key to open the database view. Click onto the ‘Tables’ tab and you will find that a list of tables will appear. Choose the table that you want and click ‘Open’.
Place your cursor in the field immediately before where you want your new field to appear. For example, if you have fields that are called Mickey, Minnie and Donald, and you want a new column between Mickey and Minnie, then place your cursor on Mickey.
Go to the ‘Insert’ menu and click on to ‘Column’ a new column will appear to the right of your cursor location and will be called Field 1. When you click onto that, a menu will appear. Click on ‘Rename’. The column will turn black and you will be able to add information to it. Once you’ve done that, don’t forget to save it.
