Data Access

  • Thread starter Thread starter Matthew
  • Start date Start date
M

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
 
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.
Click to expand...

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
 
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?
Click to expand...

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.
 
Back
Top