Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft database training - automatic formtable creation

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft database training - Automatic Form/Table creation

microsoft database training - Automatic Form/Table creation

ResolvedVersion Standard

Automatic Form/Table creation

Why does Access add a table to my form when I use the AutoForm option?

RE: Automatic Form/Table creation

Answer to the question:
Access will analyse the table before an AutoForm is created, if there are relationships in place; where your table is the 'one' side of a 'one to many' relationship, then Access will include the secondary table as a sub-form, this will enable you to view the main table records 'one side' and also scroll through any of the 'many side' records on the sub-form.
If you wish to create a Form from your secondary table and use that rather than the default secondary table, you must insert the sub-form manually in the main Form's design view.
Sub-Forms are covered in detail on the Access Advanced course.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.