Hi David,
as you are designing your tables, it is best to avoid using spaces and special characters in the field names and come up with some naming conventions such as.
For date fields, something like:
dtCollect
and if time is important also:
dtmAnalysis
One reason I like to put dt first is because on the reports in this free tool lists all fields in the database in alphabetical order (Field List):
On report menus, I sometimes give users a choice of which date to use for criteria and this makes them easier to see. I also have a tool to make a calendar with any data and, of course, that also needs a date.
I might put something at the end to indicate what kind of data it is. When I end a field name with ID, it is a key field (primary key or foreign key) and the data type is Long Integer. AutoNumber is a special form of Long Integer.
Access Basics
http://www.accessmvp.com/strive4peace/Index.htm
You asked about creating records for easy filling. That would be an Append Query, which is in Access Basics.
Picking good names is not easy. Except for key fields, which I like to be the same wherever they are used since they represent the same information, it is a good idea to make sure every field in the database has a unique name. Access also has lots of reserved words that shouldn't be used.
Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html
On this page is a Database Issue Checker Utility you can download and run on the database to check names and other possible issues.
respectfully,
crystal
~ have an awesome day ~
On 12/6/2016 9:34 PM, david.pratt@outlook.com [MS_Access_Professionals] wrote:
OK. Thanks for telling me about the message history. this is my first time and I did not know the difference.
I apologize but I am not following about the table design. Isn't the "extra table" between 4 and 5 the Templates table that I originally asked about?
I am thinking that I need perhaps two additional tables; one that is the Templates table and one that is the Template details table. The template table would contain the sample identification and the details table would contain the analyses associated with that sample Template?
I will create those tables and then come back with hopefully a more focused question.
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
David=
You appear to be replying on the web. When you do that, you need to be sure to click Show Message History so that those of us on email see the original thread.
Because you have one row per test in table 5 in your original post, you should have one row per test for each analysis for the "standard" tests. When the user picks an analysis type, you need code in After Update of the combo box that picks the analysis to populate table 5. Come to think of it, you need an extra table between 4 and 5 that lists for each sample the type of analysis required.
Fix that and come back with a complete list of the fields in each of your tables, and I'll try to help you with the code.
John Viescas, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access Applications(Paris, France)
On Dec 6, 2016, at 9:21 PM, david.pratt@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
My question may not be too vague, but apparently my skill set is too low to understand the advice.
I think I want the user to pick a sample template, not an analysis; e.g. "weekly raw water testing", which would be the description of a template record. But I don't know what fields to include in each template record. Every template will not have the same number of analyses. Should I just put in more fields for analyses than would ever be required? And thus some fields would remain null and not get inserted? Or is this leading me to another join table of some design.
And I am not experienced in this at all. Could you give me some example coding of the insert query?
I apologize for being "challenged" and I promise I will try to do as much work on my own as I can and not just ask this group for everything.
————————————————
David-
The template table sounds like the way to go. When the user selects an analysis, pre-fill the lab reports table with the template rows. You would need a bit of code to do that - run an INSERT query to add the appropriate rows from the template. The user is then free to delete or add rows and record the results.
No, your question is not to vague or complex!
John Viescas, AuthorEffective SQLSQL Queries for Mere MortalsMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access Applications(Paris, France)
On Dec 6, 2016, at 8:45 PM, David Pratt david.pratt@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi, I am new to the group and this is my first post so hopefully I will get this done in a manner that allows for easy response.Access 2016
I am working on a database to record and report lab data. I need to create an input form to enter the results of lab tests. I have these tables:1. Table of analyses (many different analytical procedures may be performed)2. Table of sample points (many different sample points may be sampled)
__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar