a dynaset object can be used to retrieve information from a recordset and use the resault of the query to then edit the records and it also can get resaults from more than one table. On the other hand the snaphot gets information from only one table on the query and the data can not be edited or updated
A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database. Design view allows you to create or change the table, form or any other database object.
a pool table has balls but billard table has balls to play i would reccommed the pool table
A desk is where you do work, like at the computer A table is more kitchen associated
dont know haha :P
Datasheet Form
You can enter it through the datasheet. You can enter it through a form. You can also use an Append Query to add records to a table from another table.
Datasheet view.
Datasheet
a. by selecting a table in Datasheet view
query takes a table and given the criteria entered into it it displays the results that meet that search. While a report just spits out a table in the database
grid
The database table has a physical existence in the database. A view is a virtual table, that is one that does not actually exist. View is made up of a query on one or many tables in a database.
Design view shows the field and their types and other properties, but not the data. You can make changes to the design of the table there. Datasheet view shows you the actual data and you can change the data in it, but not the design of the table.
Datasheet view
Update queries modify information within a record at one or more fields at a time.Append queries copy complete records at a time, adding to the existing set of records in a table.For example, if an "Address" field needs to be changed for the records in a table, you can use an update query to make that change. If you have two tables with various "Customer Information" listings, you can use an append query to copy the records of one table to the other.
There is a Make Table query and also a data definition query. Either can be used to do it. If you go into Design view of a query you can change the query type through the query menu. If you select a Make Table query it will bring you through the options you need. You can do things like take data from an existing table and create a new table out of it using some or all of the fields and some or all of the records.