INTRODUCTION TO COMPUTER APPLICATIONS IN FORESTRY
INTRODUCTION TO COMPUTER APPLICATIONS IN FORESTRY FOR 112
Popular in Course
Popular in Natural Resource Ecology And Mgmt
This 4 page Class Notes was uploaded by Miss Theresia Fay on Monday October 19, 2015. The Class Notes belongs to FOR 112 at Oregon State University taught by Staff in Fall. Since its upload, it has received 17 views. For similar materials see /class/224467/for-112-oregon-state-university in Natural Resource Ecology And Mgmt at Oregon State University.
Reviews for INTRODUCTION TO COMPUTER APPLICATIONS IN FORESTRY
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 10/19/15
FOR 112 Week 9 Notes and Homework Tips Microsoft Access What s with all the warnings when open a database file In ccess 39 i i b amed 39 39 A A L c How many Warnings you see depeids onthe level ofsecurity 39 39 Hae L 39 uni lit Do you want to block unsafe expressions select No The le may not be safe to opei se ec LL pmquot Ifyou opei a database le in our class folder you will receive a message that the le will be opeied as Read my How do create a new database You can create a blank database and thei add the tables forms reports and othaquot objects lanai this is the most a 39 quot 39 39 H L4 L 39 L Eitherwayyoucanmodifyand but in exteid your database at any time a aquot ithas hem created 1 Click the New icon on the Access toolbar rst icon on the le 1n the New File task ane on the right side ofthe scram Lindaquot New click Blank Database 3 1n the File New Database dialog box specify a name and location for the database and thei click Create 39 app a an you L 39 39 dam u Why are tables so im portant in Access Tables contain all the data in the database Thae are othaquot objects eg Queries Forms and Reports in the 39 r 39 r39 39 39 inlhemhle How do view my forms tables queries etc on the le hand side click on the blue bar next to the arrows ltlt located directly unda the ribbon Down Lindaquot film by group select what you wish to View er a n a l Paste mm L a Frmnav panda Navigate In meow How do I determine how many fields are in a table 39 quot 39 A 39 View and39 r 39 39 uineld It sthatsimple How do deter e how many records are in a table A MADW PupiavAve Albany 3311 W Vaklma Way Curvallls lam W Eamqu Dv Curvallls ElZN Oak St Albany 290 N m St Phllumath Thls labl e quota E39Eiolal 0W9 recordsu EEEAl27nE Retold u 4 l gt n we are Is there a maximum number of fields that can be in a table yes Excel 2007 allows 16384 Whlle Excel 2003 and earller allows 256 total elds Is there a maximum number of records that can be in atable Notreally bunhere IS a llmll on how big the enure database le can be 2 glgabyles Tables can easlly have 2003 and earller only allows 65536 records What is the advantage of using a relational database like Access to store and work with data as opposed to using Microsoft Excel ll b1 M l 0 al mr nmdumnr r TnF lw n lbl worksheet mm l data as ln the saemshot below Mam Menu Managemem Q E uwgnggs nuw can I vi w How do I use a query in Microsoft Access h w What s the difference between a Select query and an Action query r r quot und w r rd an Exxstmg table The gure below contams relatedmfor manon about query types Sage Y may manna 242 3 mm 1 5 Date Cuztm mamas 151 Date Mnm ed 1192007 1043 I 39 39 a 39 Access didn t ask me ifl wanted to save the changes Why is that That s r m n v V t eases baekup copies ofyour database mew How do I export a table or query InAceess y In the Search Forquot a y Then hck on Export data or database objectsquot m the Search Results ust A separate help wmdow will open and s t u t ct
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'