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

setting up database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Setting up a database

Setting up a database

ResolvedVersion 2003

Antonia has attended:
Access Introduction course

Setting up a database

This is probably a really stupid question, but I want to set up a database of people, their contact details, car reg, children, which committees they're on and which groups they're in. What is the best way to link all these tables - would an auto number be the best plan? Or something else?

RE: Setting up a database

Hi Antonia

Thank you for your recent post. Database design and structure needs to be carefully considered and we wouldn't be able to give you a well informed response at this stage.

We do assist clients with similar requests by reviewing their databases or if at an earlier stage helping to create the structure of the database to fit the design parameters.

This type of work due to it's nature falls beyond the scope of the forum and is more consultative. If you would like to know more on how we can assist please let me know.

Kind regards

Jacob

Thu 10 Jun 2010: Automatically marked as resolved.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

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.11 secs.