If you add a table with 10 records to a query
Records may be added to tables in three ways: manually through the table GUI, using an SQL INSERT query to add a single record, and using an INSERT query to add multiple records in bulk. Show
A. Adding records manuallyThis method is by far the easiest, but also the most tedious. It is most suitable for populating small tables.
B. Adding a single record using an INSERT query
C. Adding records from another table in bulkThe last method of adding records to a table is perhaps the most common one, the bulk insertion of records that are already in some other digital form. To enable you to see how this method works in Access, I've created a comma-delimited text file of albums released in the 1960s by the three artists above.
|