473,326 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

data entry form for large data set w/many fields

I am using Access 2000 but I also have the 2003 version.

I am working on creating a data entry form in Access for a research study. Since there is a maximum of 255 fields per table in Access, I have to split the fields up (unfortunately). I am creating a form for each section and all of the respective fields, and then I am putting all these forms into one larger form as subforms. I have a few questions & am hoping someone has answers:

1) Once data has been entered and I have data on about 100 or so subjects (about 700 fields or so, in total), can I export all of this data together into, say, a flat file? I would ultimately like to bring one file of all the data into SPSS.

2) Should I be using a continuous form instead of a bunch of subforms embedded in one main form? How would I do this if Access doesn't allow more than 255 fields?

3) Does anyone know of a better way I could be designing this? I am concerned that once the data has been entered I am going to have some serious trouble getting it out of Access to analyze it.

Thank you in advance.

totally exhausted from working on this project...
Jul 12 '07 #1
2 3327
missinglinq
3,532 Expert 2GB
The maximum of 255 fields per table in Access means the total number of fields per record! A table with 10 fields and 100 records would still only have 10 fields, not 1000! If you're saying that each record has 700 fields, I can almost assuredly tell you that your database is not properly normalized; some experts believe that a table with more than 25-30 fields means a non-normalized db. If you truly have 700 fields, you need more tables, joined by a common field, such as one uniquely identifying each subject.
How, exactly have you "split the fields up?" Let us know this and whether you actually have 700 fields per record, and we'll try to to advise on your best method of handling this!

Linq ;0)>
.
Jul 12 '07 #2
Thanks for the speedy reply.

I have ~700 fields per record. No records exist yet though. This will be used for data entry. I want to make a data entry form for someone who will be entering data on at least 100 subjects. I split the fields up based upon the subject matter (e.g., one table is the subject's demographic data, one table is the subject's mother's data etc.). Each table can be joined on an ID number. My concern, though, is that I won't be able to export all the data later on in a flat file for data analysis in SPSS.

The other issue is the form I made based on 8 subforms. I don't want the data entry person to have to enter the subject's ID on every form.

Hope this clarifies a little...

The maximum of 255 fields per table in Access means the total number of fields per record! A table with 10 fields and 100 records would still only have 10 fields, not 1000! If you're saying that each record has 700 fields, I can almost assuredly tell you that your database is not properly normalized; some experts believe that a table with more than 25-30 fields means a non-normalized db. If you truly have 700 fields, you need more tables, joined by a common field, such as one uniquely identifying each subject.
How, exactly have you "split the fields up?" Let us know this and whether you actually have 700 fields per record, and we'll try to to advise on your best method of handling this!

Linq ;0)>
.
Jul 12 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

12
by: Santosh | last post by:
Since I just started my new work, I have inherited a MS Access database which has nearly 13000 records in a single table. Now, my mandate is to clean the database and maybe split the table into...
6
by: Wayne | last post by:
I am designing a database which needs approximately 50 fields per record. The database user requires data entry to be via a single screen. If I follow good database design practice and split the...
2
by: filbennett | last post by:
Hi Everyone, I'm generally unfamiliar with Access form design, but have programmed Cold Fusion applications for a couple of years. I'd like to build a data entry form in Access that allows the...
17
by: Timothy.Rybak | last post by:
Hello all, This is my first attempt at an application, so kid gloves are appreciated. I need to make a very simple form that only has a few elements. One is TraceCode - a text field that is...
4
by: =?Utf-8?B?Q2FybGluIEFuZGVyc29u?= | last post by:
I have a large classic ASP web application which needs to now support chinese character entry (I don't have to worry about the UI yet - the data entry people can read english). Other than changing...
20
by: hippomedon | last post by:
Hello everyone, I'm looking for some advice on whether I should break the normalization rule. Normally, I would not consider it, but this seems to be a special case. I have created an...
2
kcdoell
by: kcdoell | last post by:
Hello: I have four tables: tblDivision tblWorking_Region tblCredit_Region tblForecast (This is the main data entry table for all forecasting records) tblDivision has the following fields:
11
by: RobertJohn | last post by:
Hi all I am using Access 2007 to start a small home library application, and so far it has two tables. 1. Books, with fields Book_ID (Primary Key) and Title, and 2. Authors, with fields...
2
by: AlexanderDeLarge | last post by:
Hi! I got a problem that's driving me crazy and I'm desperately in need of help. I'll explain my scenario: I'm doing a database driven site for a band, I got these tables for their discography...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.