Working with databases/Create a database/Adding information

Having created our basic table in our database, we are now going to add some information. In database jargon, this is called creating a record.

In order to do this, we will be working with our table in datasheet view. If you’ve had some experience with Excel, you will see that this looks like a spreadsheet.

{{OP Activity |

Adding information to your database
}}
 * 1) Open your bookshop database, then open the table that you have created. As you can see, the first record (or first row) is empty. Remember that the very first field, ID, is an auto-number. Access will put a new number in there for us.
 * 2) Use your mouse and click in the field underneath the heading Year Published.You should see the flashing text cursor. Type 2/1/2010 Hint: You may want to use the calendar button that pops up when you are entering in a date/time field. Click the calendar icon and use the calendar that appears to navigate to the correct date.  [[Image:access-addinfo3.png]]
 * 3) In the next field Paperback book? Tick the box to indicate that yes, this book is a paperback.
 * 4) Here's the rest of the information that you need to fill in the rest of this record:
 * 5) *Title - Introduction to Computing
 * 6) *By Computing for Free
 * 7) *Published - 2/1/2010
 * 8) *ISBN – none.
 * 9) *Paperback
 * 10) *45 pages
 * 11) *Purchase Price - $15.00
 * 12) *Retail Price - $20.00
 * 13) Check your work and save your database.
 * 14) We are now going to provide you with information for 3 other books. Create a new record for each of these books: [[Image:access-addinfo5.png]]
 * 15) Please check your database against the source information. Save your database and close.

Update a record
To make changes or update your records, select the correct record from the table, click in the field and enter in a new value

Delete a record
Deleting a record is very easy in Access.