Povo,
I have created a database based on your excel sheets and have included it in the attached zip.
1 table for each sheet. I modified the names to make Access (happy -less syntax critical).
Most fields are text data type, except the long notes that was set to memo and some Day Month that are double.
I let Access assign a PK for each table, but it has no real relevance to you at this point.
I have included a module and table that I use to show tables and fields with attributes (listed below).
I have mixed use of FirstName FName and LastName Surname LName (but I'm sure you'll recognize these).
Errata:
I do see I have misnamed a field FLName in the Deaths table. It should be LName.
In Marriages BribeFName should be BrideFName (73)
[/code]
EntryID table_name field_name ordinal_position data_type length default 1 Births BDay 0 Text 255
2 Births BMth 1 Text 255
3 Births BYer 2 Text 255
4 Births BapRegDay 3 Text 255
5 Births BapRegMth 4 Text 255
6 Births BapRegYer 5 Text 255
7 Births Typ 6 Text 255
8 Births Co 7 Text 255
9 Births FirstName 8 Text 255
10 Births Surname 9 Text 255
11 Births AddrLoc 10 Text 255
12 Births ChurchParish 11 Text 255
13 Births FatherFName 12 Text 255
14 Births FatherLName 13 Text 255
15 Births FatherOcc 14 Text 255
16 Births MotherFName 15 Text 255
17 Births MotherLName 16 Text 255
18 Births Spon1FName 17 Text 255
19 Births Spon1LName 18 Text 255
20 Births Spon2FName 19 Text 255
21 Births Spon2LName 20 Text 255
22 Births Spon3FName 21 Text 255
23 Births Spon3LName 22 Text 255
24 Births Notes 23 Text 255
25 Census ID 0 Long 4
26 Census From 1 Double 8
27 Census To 2 Double 8
28 Census Co 3 Text 255
29 Census FirstName 4 Text 255
30 Census LastName 5 Text 255
31 Census Residence 6 Text 255
32 Census AdditionalNotes 7 Text 255
33 Census Event Place 8 Text 255
34 Census Source 9 Text 255
35 Census DateRef 10 Text 255
36 Census ListDetailsExplanation 11 Text 255
46 Deaths ID 0 Long 4
47 Deaths DeathBurialDay 1 Text 255
48 Deaths DeathBurialMth 2 Text 255
49 Deaths DeathBurialYer 3 Text 255
50 Deaths Typ 4 Text 255
51 Deaths Co 5 Text 255
52 Deaths FName 6 Text 255
53 Deaths FLName 7 Text 255
54 Deaths Age 8 Text 255
55 Deaths AddressLocation 9 Text 255
56 Deaths Occupation 10 Text 255
57 Deaths ParishDistrict 11 Text 255
58 Deaths Notes 12 Text 255
59 Marriages ID 0 Long 4
60 Marriages MDay 1 Double 8
61 Marriages MMth 2 Double 8
62 Marriages MYear 3 Double 8
63 Marriages Type 4 Text 255
64 Marriages Co 5 Text 255
65 Marriages GroomFName 6 Text 255
66 Marriages GroomLName 7 Text 255
67 Marriages GroomAge 8 Text 255
68 Marriages GroomCdn 9 Text 255
69 Marriages GroomLocation 10 Text 255
70 Marriages GroomOccupation 11 Text 255
71 Marriages GroomFather 12 Text 255
72 Marriages GroomFatherOccupation 13 Text 255
73 Marriages BribeFName 14 Text 255
74 Marriages BrideLName 15 Text 255
75 Marriages BrideAge 16 Text 255
76 Marriages BrideCdn 17 Text 255
77 Marriages BrideLocation 18 Text 255
78 Marriages BrideOccupation 19 Text 255
79 Marriages BrideFatherFName 20 Text 255
80 Marriages BrideFatherLName 21 Text 255
81 Marriages BrideFatherOccupation 22 Text 255
82 Marriages Church 23 Text 255
83 Marriages Witness1Forename 24 Text 255
84 Marriages Witness1Surname 25 Text 255
85 Marriages Witness2Forename 26 Text 255
86 Marriages Witness2Surname 27 Text 255
87 Marriages Srce 28 Text 255
88 Marriages SourceDate 29 Text 255
89 Marriages FullDescription 30 Memo 0