forms - Microsoft Access: I need help planning my first database -


i new user microsoft access , little fuzzy on database design. have several excel spreadsheets info on chemical concentrations @ different locations company manages. each of these spreadsheets organized location name , test date. have spreadsheet each of chemicals needs tracked; 7 sheets more come in future. these sheets have column of location names on far left , row of dates chemical tests taken on top. each sheet looks this.

          june-13    july-13    aug-13   ...

location 1

location 2

location 3

...

each location , date repeated on each spreadsheets; difference between 7 of them type of chemical track. have transferred each of these spreadsheets access tables. have created relationships between location name data creating location table. allowed me create query & form search through data location name. problem inexperienced ms access , not sure how rearrange original tables allow date , chemical type search. ideally set database allow query , form let others search through data location name, date, , chemical type. understand basics of query , form design data not seem planned out in such way allow me search location name. can suggest way can layout tables or create new tables me this? appreciated new ms access.

thank you.

there 2 major concepts need grapple before can started ms access. first access lies in overall space of computing. second difference between tabulated data , crosstabulated data.

ms access lies @ intersection of 3 major aspects of information management. databases, applications, , documents. access file document. intended managed other kinds of documents, such word or excel documents. it's easy move data between different kinds of documents, such spreadsheets , access tables. ease can deceptive. it's easy may think have mastered information management when ankle deep.

an access file contains application. of application design issues simplified wizards lot of tedious work you, such creating form based on 1 or 2 tables, etc. can started no background in application design.

an access file contains database. data in database laid out tables, , table rows linked each other foreign key/primary key relationship. it's lot easier started access with, say, sql server or oracle. but, again, ease of starting might conceal existence of discipline can require effort learn. database design isn't complicated. abstract. , unless can think @ appropriate level of abstraction, repeatedly shoot in foot.

within limits of desktop processing, can needs done in access, , can started small fraction of learning curve needed other tools. have careful.

switching gears, want alert difference between cross tabulated data , tabulated data. spreadsheet showed us, dates spread out across top , locations spread out down left side, classic example of cross tabulated data. spreadsheets built work data in form. relational databases not. other answers pointing designs tabulated data, not benefit answers until understand difference.

in general, transforming cross tabulated data tabulated data easier done excel pivot table tool tools in access. suggest figure out system of relational tables data, , use excel transform data before loading access. when first learn pivot tables, learn how transform tabulated data cross tabulated data. going other way little harder, it's doable.

in connection, please note there no wizards in access transform set of information requirements system of tables. have before start in first wizard.

this tip of ice berg.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more