Access 2010 Database Design

Hi there

I am based in the UK and I have developed a new database in Access 2010.

I am now at a standstill, when trying to create correct ‘Relationships’ and then the main ‘Form’, with tabs to act as a switchboard to the other tables.

I am presently using a paper-based system. This presently consists of: 2 double sided A4 pages, which are now included in tables 1 to 4 below. Then I have presently further A4 paper sheets which are double sided, they hold one session on each side are stapled to the back.

The Database it is now completed and includes ‘look-up’ lists to speed completion.

It presently consists of main table 1 and further 19 tables:

1) Client Contact Details, (inc: ‘Active’, ‘Inactive’, ‘Died’)
2) Client Short Symptoms and Background History
3) Client In-depth Background History (if needed?)
4) Client Information and Informed Consent
5) Client Session 1
6) Client Session 2
7) Client Session 3
8) Client Session 4
9) Client Session 5
10) Client Session 6
11) Client Session 7
12) Client Session 8
13) Client Session 9
14) Client Session 10
15) Client Session 11
16) Client Session 12
17) Client Session 13
18) Client Session 14
19) Client Session 15
20) Client Session 16

Clients may vary in whether they need table 3?
Clients may vary as to whether they need anything from 1 session up to 16 sessions?

I am having great difficulty trying to place the correct ‘relationships’.

My method of searching for clients at start of each session,is by their full name, which will include their first name and their family name. If I identify more than one e.g. John Smith, I will then wish to choose correct by asking client their date of birth.

Once I have located correct client, I will just type in the information of each session. Each table is a mirror of the paper system, with some time saving due to some ‘look-up lists.

** I am having great difficulty with setting up the ‘relationships’. Once I locate ‘John Smith’ I want each row in each table to be connected to only the ‘John Smith’ I have selected, after choosing the one with the correct date of birth. Some full names may only have on entry.

Finally, once the ‘relationships’ are sorted, I want to have an overall main ‘form’ which has my practice name and the client: ‘John Smith’ on, going from left to right on top of the page. This main page would also have the contents of table 1. Then underneath from left to right, having 15 single tab for each of the remaining tables of 2 to 16.

How hard is this approximately how expensive is it? Could I send the tables via the email?

**My needs are knowing how to set-up the relationships and then creating the Main Form (table 1) and the how other 19 will tab of it?

Warm Regards, Jeana Hallas