Web-Enabled Decision Support Systems by JK42AfX

VIEWS: 2 PAGES: 25

									     Web-Enabled Decision Support Systems
              Access Introduction: Touring Access




Prof. Name                                          name@email.com
Position                                              (123) 456-7890
University Name
                                1
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    2
                             Introduction
   Microsoft Access is a relational database management system
    – Data definition
    – Data creation
    – Data management


   Why Access?
    – Ease of learning
    – Integration with MS Office
    – Popular usage
         Small to mid sized businesses
         Academia
    – Support of standard query languages




                                          3
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                  4
    The Architecture of Microsoft Access
   An Access Database is a collection of elements named data objects
    – Examples:
         Tables, queries, forms, reports, relationships, toolbars, etc.
    – Facilitate:
         Creation, manipulation, and presentation of data



             Form 1         Form 2             Report 1         Report 2       Presentation Layer

                                                                      Access
                                                                      Data
                          Query 1                 Query 2             Object   Query Layer
                                                                      Model




                Table 1              Table 2                Table 3
                                                                               Data Layer




                                                    5
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    6
                         The Task Pane
   Appears on Access startup
   Includes frequently used tasks

   How-to Display:
     – Choose: View | Toolbars |
       Customize
     – Choose the Task Pane check box
       under the Toolbars tab
     – Click Close




   Open the University database file available on
    http://www.dssbooks.com | Hands-On Tutorial Files | Chapter 05



                                     7
              The Database Window
   Database Window




                       8
             Access Toolbars and Menus
   Access offers more than a dozen built in toolbars
   Most frequently used:
     – Main Menu
          File, Edit, Insert, Tools, Window, Help
     – Database Toolbar
          New, Open, Copy, Paste, Relationships


                                                        Main Toolbar


                                                            Database Toolbar




                                            9
                The Options Dialog Box
   The Options Dialog Box for Global Options
    – Accessible across all database objects
    – Choose Tools | Options item from the main menu




                                      10
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    11
      Exploring Tables – Datasheet View
   Access stores and relates its data in tables
   Datasheet View
     – Two-dimensional grid
          Columns: data fields
          Rows: records




                                     12
        Exploring Tables – Design View
   Design view
    – User interface for creation or changing of table structure
    – Design Grid
         Define fields, data types, and descriptions
    – Field Properties
         Set validation and appearance preferences




                                                            Design Grid




                                                            Field Properties



                                           13
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    14
                         Relationships
   A relationship connects or relates two tables




                                                    Database Tables




                                                    Attributes




                                    15
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    16
                          Exploring Queries
   A query is a question posed against database tables
    – Powerful tools
    – Serve as epicenter of any database management system
    – Built using:
         Graphical query design grid (Query By Example, QBE)
         Standard Query Language (SQL) statements
   Query Types
    – Select queries
         List of data rows
         Aggregate values (Sum, Count, Avg)
         Grouped lists
    – Action queries
         Insert
         Update
         Delete


                                        17
     Exploring Queries – Datasheet View
   Datasheet view
    – Displays results of a query




                                         Query Output




                                    18
       Exploring Queries – Design View
   Design view
    – Assists in query design




                                     Table Pane




                                     Design Grid




                                19
                             Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    20
                    Getting Access Help
   There are several was we can invoke online help:

    – Pressing the F1 function key


    – Selecting Help | Microsoft Access Help from the main menu


    – Clicking on the Microsoft Access “Help” icon on the toolbar




                                       21
          Getting Access Help – How-to
   Getting help on “Compressing Database Size”
    – Goal: To improve storage efficiency


   How-to:
    1. Open the Access help as described earlier


    2. In the Search text box enter, “How do I compact a
        database?” Click the Start Searching button


    3. The help displays several relevant topics. Select the
        “Compact and repair an access file” option


    4. Read and follow the help topic description




                                        22
                              Overview
   5.1 Introduction
   5.2 The Architecture of Microsoft Access
   5.3 Access’ Development Environment
   5.4 Exploring Tables
   5.5 Relationships
   5.6 Exploring Queries
   5.7 Getting Access Help
   5.8 Summary




                                    23
                                Summary
   Microsoft Access is a relational database management system
   An Access Database is a collection of elements named data objects
     – Tables, queries, forms, reports, etc.
   Access Development Environment
     – Task Pane
     – Database Window
     – Toolbars and Menus
   Access stores and relates its data in tables
     – Datasheet View
     – Design View
   A relationship connects or relates two tables
   A query is a question posed against database tables
     – Datasheet View
     – Design View

                                         24
                      Additional Links
   Review more sample Access database files on the book website:
    http://www.dssbooks.com.

   To read more about MS Access product and its benefits visit:
    http://office.microsoft.com/en-us/access/default.aspx




                                    25

								
To top