Entering new records in Access 2007

The UK's most regular instructor-led training courses.
Training information: ms access courses · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Mirja has attended:
Access Introduction course

by - delegate Mirja [1 post] (2008 Mar 17 Mon, 16:50) Reply

How can I enter/add new records in the form view and utilise previous entries: eg if we have multiple entries where the contact details would be almost similar in our contacts database?
Thanks in advance.
Mirja

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Oct 16 Thu	Tooting	0	FULL
2007	2008 Oct 23 Thu	Bloomsbury	5	book now	£212	£224
2003	2008 Oct 28 Tue	Bayswater	7	book now	£188	£215
2002/XP	2008 Oct 29 Wed	Tooting	0	FULL
2003	2008 Nov 4 Tue	Southwark	6	book now	£193	£215
2003	2008 Nov 11 Tue	Bloomsbury	0	FULL
Full Schedule: See all 65 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Entering new records in Access 2007

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 09:35) Reply

Hi Mirja, Thank you for the post, welcome to the forum, in answer to your question, I realise that your database is already set up, however where you have duplication of data it is perhaps more correct when considering Database Normalisation, to hive these fields off into another table and link to that table by creating a relationship on a one to many basis, then when utilising a query to add/enter new records, where the one side is common to the records, the many side is the only part which needs to be updated or added to. In the situation that you find yourself there is a keyboard combination CTRL+' (apostrophy) which will duplicate information as found in the same field in the previous record. I hope that is of help, best regards Pete

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Microsoft Access Tighten your Security Controls
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Access VBA Handling Errors and Debugging Code
· Microsoft Access 2007: New Features

Please browse our web site to find out more about
ms access courses and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips