1 web-enabled decision support systems access introduction: touring access prof. name [email protected]...
TRANSCRIPT
![Page 1: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/1.jpg)
1
Web-Enabled Decision Support Systems
Access Introduction: Touring Access
Prof. Name [email protected] (123) 456-7890University Name
![Page 2: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/2.jpg)
2
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
![Page 3: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/3.jpg)
3
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
![Page 4: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/4.jpg)
4
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
![Page 5: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/5.jpg)
5
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
Presentation Layer
Data Layer
Query Layer
Table 1 Table 2 Table 3
Query 1 Query 2
Form 1 Form 2 Report 1 Report 2
Access DataObject Model
![Page 6: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/6.jpg)
6
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
![Page 7: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/7.jpg)
7
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
![Page 8: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/8.jpg)
8
The Database Window
Database Window
![Page 9: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/9.jpg)
9
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
Database Toolbar
Main Toolbar
![Page 10: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/10.jpg)
10
The Options Dialog Box
The Options Dialog Box for Global Options– Accessible across all database objects
– Choose Tools | Options item from the main menu
![Page 11: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/11.jpg)
11
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
![Page 12: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/12.jpg)
12
Exploring Tables – Datasheet View
Access stores and relates its data in tables Datasheet View
– Two-dimensional grid Columns: data fields
Rows: records
![Page 13: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/13.jpg)
13
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
![Page 14: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/14.jpg)
14
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
![Page 15: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/15.jpg)
15
Relationships
A relationship connects or relates two tables
Database Tables
Attributes
![Page 16: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/16.jpg)
16
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
![Page 17: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/17.jpg)
17
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
![Page 18: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/18.jpg)
18
Exploring Queries – Datasheet View
Datasheet view– Displays results of a query
Query Output
![Page 19: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/19.jpg)
19
Exploring Queries – Design View
Design view– Assists in query design
Table Pane
Design Grid
![Page 20: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/20.jpg)
20
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
![Page 21: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/21.jpg)
21
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
![Page 22: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/22.jpg)
22
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
![Page 23: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/23.jpg)
23
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
![Page 24: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/24.jpg)
24
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
![Page 25: 1 Web-Enabled Decision Support Systems Access Introduction: Touring Access Prof. Name name@email.com Position (123) 456-7890 University Name](https://reader035.vdocuments.us/reader035/viewer/2022062318/5519b2c85503467a578b468e/html5/thumbnails/25.jpg)
25
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