MS Access

Course Process

An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View.

  • A datasheet is a simple way to look at your data in rows and columns without any special formatting.

  • Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry.

  • A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields.

  • You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or when you move the cursor to another row.

  • By default, the fields in an Access database are set to accept a specific type of data, such as text or numbers. You must enter the type of data that the field is set to accept. If you don’t, Access displays an error message −

Let us add some data into your tables by opening the Access database we have created.

Database

Select the Views → Datasheet View option in the ribbon and add some data as shown in the following screenshot.

Datasheet

Similarly, add some data in the second table as well as shown in the following screenshot.

Add Data

You can now see that inserting a new data and updating the existing data is very simple in Datasheet View as working in spreadsheet. But if you want to delete any data you need to select the entire row first as shown in the following screenshot.

Insert Data

Now press the delete button. This will display the confirmation message.

Access

Click Yes and you will see that the selected record is deleted now.

Selected Record