Data Access

[Matthew]

I am making a new database, and wanted to know if there was a way to edit
data with a "spreadsheet" view like a data access page. However, I want to
use this to make changes to the data in the database.

Is this possible?

Matthew

 

[Kurt]

I am making a new database, and wanted to know

if there was a way to edit data with a "spreadsheet"
view like a data access page. However, I want to
use this to make changes to the data in the database.

Create your form and change the Default View of the form
to Datasheet. This will give the effect of a spreadsheet,
and the data can be edited.

Subforms (like the Orders subform in Northwind) are often
displayed in Datasheet view.

Kurt

 

[John Vinson]

I am making a new database, and wanted to know if there was a way to edit
data with a "spreadsheet" view like a data access page. However, I want to
use this to make changes to the data in the database.

Is this possible?

Not merely possible, but very easy.

Create a Form based on the table. Set the Form's Default view to
Datasheet. Open the form and start editing.

Or even, though I don't like recommending this, simply create a table
and doubleclick on the table name. A datasheet view of the Table
itself will open, which can be edited.