Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

ResolvedVersion 2007

Tue 14 Apr 2009, 14:13 Delegate Dobromira said...

Dobromira has attended:
Word Introduction course
Excel Introduction course
Access Introduction course
PowerPoint Introduction course

Access

whats the difference between record and database?

Tue 14 Apr 2009, 14:53 Trainer Rich said...

RE: access

Hi Dobromira,

Thanks for your question.

A record is one entry within the database. For example, you may have a database of names and addresses. Say you have two friends, Adam and Bill. Adam has one record allocated to him, with all his address, phone number and contact details; and Bill has another record.

And the database is the collection of all the records.

If this answer resolves your query, please mark the question as 'resolved' (see below). Otherwise, please post a follow-up response to this post, and I will assist you further.

Regards, Rich

Tue 21 Apr 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Access

Access

RE: access

Access articles

Access tip:

Deleting duplicate records from a table