MS Access 2002: Fundamental.


81 views
Uploaded on:
Category: News / Events
Description
MS Access 2002: Essential Teacher: Vicki Weidler MS Access: Database Ideas Diagram Get comfortable with MS Access database wording Figure out how to begin MS Access, open a database and explore the product interface Comprehend database objects and their comparing capacities
Transcripts
Slide 1

MS Access 2002: Basic Instructor: Vicki Weidler

Slide 2

MS Access: Database Concepts

Slide 3

Overview Become acquainted with MS Access database wording Learn how to begin MS Access, open a database & explore the product interface Understand database objects & their comparing capacities Use standard configuration standards to arrange a database Explore connections between tables Use Help alternatives to discover data on MS Access subjects Learn how to close a database & MS Access

Slide 4

Databases What is a database? At the point when do you utilize a database? 3 fundamental sorts of databases Flat document Relational Object-situated

Slide 5

Microsoft Access A social database administration program that permits you to store, arrange, and recover data in a viable way.

Slide 6

Planning a Database What is the motivation behind the database? What do you require it to do? Who will utilize it? What number of will utilize it? At the point when will they utilize it? (i.e. each one in turn, at the same time) How will they utilize it? (i.e. desktop, server, web-interface) Who will make it? Who will look after & adjust it? Who will do information section? Do you have to assemble in efforts to establish safety? Who will give specialized backing to it? What sorts of data need to go in it? By what means will this be sorted out into tables? By what means will these tables identify with each other? What sorts of questions will you have to make? Will you have to make any structures? What number of? What kind? Will you have to make any reports? What number of? What kind? Will you have to make any pages? What number of? What kind?

Slide 7

Common Mistakes to Avoid Don’t expect each issue can be fathomed with a database Don’t leave too long between surveys Don’t invest an excess of energy in the model Don’t add to the database until you completely comprehend what you require it to do Don’t add to the database until it is clear where all obligations lie Don’t go for 100% usefulness first time around; utilization 80-20% principle Involve all clients in the database arranging, outline & testing Has any other person tackled the issue? Don’t rehash the wheel Plan on an iterative advancement procedure Use reliable database models and naming traditions Use steady, widespread coding Use predictable survey principles Keep adequate documentation; incorporate with the database when conceivable Tech bolster, technical support, tech support………..

Slide 8

Database Development Life-Cycle Database Design Database Production Database Prototype Database Testing Database Development

Slide 9

Summary Become acquainted with MS Access database phrasing Learn how to begin MS Access, open a database & explore the product interface Understand database objects & their comparing capacities Use standard configuration standards to arrange a database Explore connections between tables Use Help alternatives to discover data on MS Access themes Learn how to close a database & MS Access

Slide 10

Independent Practice Activity Question #2: 3 sorts (tables, inquiries, reports) Question #3: 5 fields and 10 records Question #5: Database, Table, Data Value Question #6: Table, Query, Report

Slide 11

MS Access: Access Basics

Slide 12

Overview Explore the review choices for MS Access tables, structures, inquiries & reports Learn how to explore in a table and a structure Learn how to run an inquiry

Slide 13

Views in MS Access Design View - shows the structure of a table, question, shape or report Datasheet View – shows information in an even organization containing lines & segments in tables, questions & structures; view & alter PivotTable View – spreadsheet-like table used to break down information powerfully in diverse courses in tables, questions & frames PivotChart View – presents information in a graph structure in tables, questions & shapes SQL View – permits you to make questions utilizing SQL proclamations Form View – permits you to see and alter information in a structure Layout Preview – permits you to check a report’s outline; indicates plan components & simply enough records to confirm the outline is right Print Preview – permits you to view a report including moving around a solitary page, numerous pages, take a gander at a few pages without a moment\'s delay & change amplification to view points of interest

Slide 14

Using Queries to Retrieve Data Define the accompanying: The conditions that you need the information to meet The fields that you need to find in the inquiry come about The tables from which you’ll separate the fields The method for removing information

Slide 15

Summary Explore the survey choices for MS Access tables, structures, inquiries & reports Learn how to explore in a table and a structure Learn how to run a question

Slide 16

Independent Practice Activity Datasheet View-demonstrates information is a plain arrangement Design View-gives control over table structure Navigation Button-catches at base of datasheet perspective used to travel through records Record Selector-little box to left of every record in a table that you can snap to choose a record

Slide 17

MS Access: Creating Databases

Slide 18

Overview Learn how to make & spare a database Use the Table Wizard to make a table & set an essential key Use Design perspective to make tables & enter records

Slide 19

Naming Rules A database, question or field name: Can have any blend of letters, numbers, exceptional characters, & implanted spaces Cannot contain more than 64 characters & can\'t begin with a space Can exclude a period (.), outcry mark (!), an accent effortlessness (‘), or sections ([ ]) CAUTION: Good practice to utilize underscores (_) rather than inserted spaces in light of the fact that it is less demanding to allude to an item name & evade potential issues

Slide 20

Practice Inventory_ _ Control Yes, albeit one underscore is the acknowledged standard .Access.Database 1 No, on the grounds that the name contains periods & spaces ought to be dodged finanCIAL$Transaction Yes, despite the fact that attempt to utilize names that are as basic & spellbinding as could be allowed Contact [Client] Address No, on the grounds that the name contains sections & spaces ought to be maintained a strategic distance from SalesPerson3 Yes, it is fine to run words together & use distinctive cases

Slide 21

Summary Learn how to make & spare a database Use the Table Wizard to make a table & set an essential key Use Design perspective to make tables & enter records

Slide 22

Independent Practice Activity

Slide 23

MS Access: Working with Fields & Records

Slide 24

Overview Learn how to adjust a table’s outline by altering fields & setting field properties Learn how to include & erase records Use the Find highlight to discover & supplant records Use the Spell Checker to right slip-ups in a table Learn how to sort & channel records

Slide 25

Effective Field Names Meaningful Descriptive Self-Explanatory Purposeful Understandable Readable Consistent

Slide 26

Text Formatting Characters @ at slightest one letter or space must be entered in the field < the letters entered in the field will be converted to lowercase letters > the letters entered in the field will be converted to capitalized letters & letters can\'t be entered in the field

Slide 27

Sorting & Filtering Sorting Organize field information values in a specific succession (i.e. climbing, diving) Filtering Temporarily confine a subset of records to dissect

Slide 28

Sorting Multiple Fields must be neighboring one another in Datasheet perspective Sorts from left to right

Slide 29

Summary Learn how to alter a table’s outline by altering fields & setting field properties Learn how to include & erase records Use the Find highlight to discover & supplant records Use the Spell Checker to right mix-ups in a table Learn how to sort & channel records

Slide 30

Independent Practice Activity

Slide 31

MS Access: Querying Tables Instructor: Vicki Weidler Assistant: Joaquin Obieta

Slide 32

Overview Learn how to make, run, print, and spare questions Use inquiries to sort information and channel inquiry results Learn how to adjust question results Understand how to change inquiries by using so as to include/uprooting fields and examination administrators Learn how to utilize AND as well as conditions Learn how to discover records with unfilled fields Perform computations in inquiries by utilizing expressions and total capacities

Slide 33

Comparison Operators > Greater than < Less than = Equal to <= Less than or equivalent to >= Greater than or equivalent to <> Not equivalent to

Slide 34

OR Conditions Used to determine two conditions in the criteria Example: Unit_price is more prominent than 2 OR Qty_Available is equivalent to 700

Slide 35

AND Conditions Used to demonstrate just the records that fulfill all the predefined conditions Example: Unit_price is more noteworthy than 1.4 AND under 1.9

Slide 36

Wildcard Operators Used to find content qualities when you can’t recollect the precise content or word; placeholder ? Used to substitute for a single character * Used to substitute for any number of characters

Slide 37

Empty Fields Unknown (vacant) values in fields are referred to as invalid qualities Null qualities can\'t be utilized as a part of primary key fields or in estimations Can show or evacuate invalid qualities to avoid/avoid issues

Slide 38

Calculations in Queries When figurings are incorporated with inquiries (and not put away in the source tables) it guarantees the most up and coming data Calculations are performed every time the inquiry is run Perform figurings on single records or on a gathering of records Examples: Totals, Averages, Counts

Slide 39

Summary Learn how to make, run, print, and spare inquiries Use inquiries to sort information and channel question results Learn

Recommended
View more...