The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access.training - Adding fields

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

access.training - Adding fields

Resolved · Low Priority · Version Standard

ReplyWed 21 Mar 2007, 10:04Delegate Martin said...

Adding fields

Can I add a field whenever I need to to an existing database?

For upcoming training course dates see: Pricing & availability

ReplyWed 21 Mar 2007, 14:04Trainer Rich said...

RE: Adding fields

Hi Martin,

Yes, you can add additional fields to databases whenever you like. The new field in each record will usually be given the default value if you specify one.

Regards, Rich

Access articles

· Understanding Primary And Foreign Keys In Microsoft Access
· Discover How To Link An Excel Spreadsheet To An Access Database
· How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?
· Microsoft Access Courses
· Keeping Your Access Database Updated

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

I have a Database (Db1) which is the main database I need to compact and repair regularly. Since a number of people regularly work away from the office it has proved impractical to set the database to compact on close since if their connection is slow the..

» Forum post: Programing an automatic compact and repair

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions