Information Stockpiling and Recovery: Access rather than Exceed expectations .

Uploaded on:
Category: General / Misc
Data Storage & Retrieval: Access instead of Excel. Melissa Pico Summer 08. Two Peas in a… Microsoft package. Both Access and Excel… run queries to sort and filter data Run calculations Generate reports Use forms to navigate your data Have similar aesthetic components. Access vs. Excel.
Slide 1

Information Storage & Retrieval: Access rather than Excel Melissa Pico Summer 08

Slide 2

Two Peas in a… Microsoft bundle Both Access and Excel… run questions to sort and channel information Run estimations Generate reports Use structures to explore your information Have comparative stylish parts

Slide 3

Access versus Exceed expectations In Access you can make numerous social tables, while, in Excel, you can just have non-social or level worksheets- - they don\'t associate with each other In Access you can store a greater number of information than in Excel (numerous a large number of passages, versus 15,000 columns) Access is better for long content "string sort" information, though Excel is better when working predominantly with numeric information and running factual examinations with that information

Slide 4

Relational Databases Access permits the client to make connections between comparative fields crosswise over various tables or questions Ex: If your study is gathering demographic data, and pre and post test information for the same subjects, making a relationship between the subject and their reactions, empower the demographic information to be connected to your subject\'s reactions without entering the information different times

Slide 5

Relationships: Integrity is the key Access databases are all intended to implement the idea of referential respectability, which guarantees that connections between tables stay reliable. TableA & TableB  We may not add a record to the TableA unless it focuses to a legitimate record in TableB. On the off chance that the essential key for a record in the TableB table changes, every single relating record in the TableA must be adjusted utilizing a falling redesign. In the event that a record in the TableB is erased, every relating record in the TableA must be erased utilizing a falling erase.

Slide 6

Monogamy isn\'t for everyone One-to-one connections : 1 record in TableA relates to 1 record in TableB . One-to-numerous connections : every record in TableA may have numerous connected records in TableB , yet every record in TableB may have just 1 comparing record in TableA . Numerous to-numerous connections : every record in TableA may have numerous connected records in TableB and the other way around.

Slide 7

Storing Data An exceptional trait of Access is that it stores your information (as tables) inside Access itself. This permits the client to interface with an all the more amicable format called "structure view" without losing the datasheets (tables) out of sight. In structure see, the client can play out all the same undertakings as in the datasheet view (change, erase, or add to a record), however it is exhibited in an all the more tastefully satisfying way

Slide 8

Retrieving Data Unlike Excel, with a social database you can likewise utilize an inquiry to seek various tables without a moment\'s delay! On the other hand, you can utilize an inquiry to combine the information of two tables to make another table Note: you can characterize the particular "criteria" you are searching for in a question! For criteria cases, look "criteria" in the help menu, situated in the upper right hand corner, distinguished by a question mark 

Slide 9

Retrieving Data You can likewise recover information utilizing a structure with parameters. To do this, first make an inquiry, and in the criteria field, enter the content you need the exchange pop-up box to say, with sections at the every end. For instance: [what cartoon?] Then, make a structure (utilizing structure plan), and characterize the "record source" as the inquiry you made, the discourse box will appear when you open the structure

Slide 10

Starting your Access database A Bottom - up procedure Think about what you will require you database to do with the information you have will you should have the capacity to sort by date? inquiry people by age? enter numerous records for one individual? on the other hand one record for every individual? these inquiries are crucial to characterize before beginning in access! Build up a rundown of inquiries you will need your database to have the capacity to reply.

Slide 11

Access 2007 Resources  help and how-to  Access 2007 help UW library online (inquiry through the uw inventory): Access 2007 first off: the missing manual Access 2007: the missing manual

View more...