database systems introduction to microsoft access part 1
DESCRIPTION
Database Systems Introduction to Microsoft Access Part 1. Introduction. In its simplest form, Access is a database application It uses a relational database management model, which means you can relate each piece of information to other pieces of information by joining them. Create Tables. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/1.jpg)
1
Database Systems
Introduction toMicrosoft Access
Part 1
![Page 2: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/2.jpg)
2
Introduction• In its simplest form, Access is a
database application• It uses a relational database
management model, which means you can relate each piece of information to other pieces of information by joining them.
![Page 3: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/3.jpg)
3
Create Tables• By using wizard• By entering data• By design view
– specify field name, data type– set general attributes– set primary key
![Page 4: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/4.jpg)
4
Establish Relationships
• Click the relationships button on the toolbar
• Tables are related by matching fields.
![Page 5: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/5.jpg)
5
Types of Queries
• Select query• Update query• Append query• Delete query
![Page 6: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/6.jpg)
6
Create Queries• By using wizard
– select table, fields– Not convenient to design complex
query• By design view• By SQL view
– Input SQL sentence directly
![Page 7: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/7.jpg)
7
Microsoft Access
![Page 8: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/8.jpg)
8
Defining a New Data Base
![Page 9: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/9.jpg)
9
Naming the Data Base
FileNameOK
Change Name/Directory
![Page 10: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/10.jpg)
10
The New Data Base
![Page 11: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/11.jpg)
11
Tables
Rowor Record
Fields
General Relational Data base Table
Id Name Age Address214 Jones 25 1 New St, Malvern215
320
Key Field (Indexed)
![Page 12: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/12.jpg)
12
Access Table
![Page 13: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/13.jpg)
13
Define Fields in Table
![Page 14: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/14.jpg)
14
Add The Name Field
![Page 15: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/15.jpg)
15
Select Field Type
![Page 16: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/16.jpg)
16
Set the Field’s Parameters
![Page 17: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/17.jpg)
17
Name as Primary Key
![Page 18: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/18.jpg)
18
Define the Image Field
SelectOLEObject
![Page 19: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/19.jpg)
19
Image Parameters
![Page 20: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/20.jpg)
20
Click to Save the Table
ClickYes
![Page 21: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/21.jpg)
21
Name the Table
![Page 22: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/22.jpg)
22
Table1 is now in the Database
![Page 23: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/23.jpg)
23
Select Forms
Select NewForm
![Page 24: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/24.jpg)
24
Associate Form with Table
Relate FormTo Table
![Page 25: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/25.jpg)
25
Create Form for Table1
Select FormWizard
![Page 26: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/26.jpg)
26
Select AutoForm
![Page 27: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/27.jpg)
27
New Form -Run Mode
![Page 28: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/28.jpg)
28
Close the Form
![Page 29: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/29.jpg)
29
Save the Form
SelectYes
![Page 30: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/30.jpg)
30
Name the Form
![Page 31: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/31.jpg)
31
Form is part of the Database
Form inDatabase
![Page 32: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/32.jpg)
32
Modify the Form
![Page 33: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/33.jpg)
33
Delete the Current Title
ClickThe TitleandPress Delete
![Page 34: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/34.jpg)
34
Select A in ToolBox for Title
![Page 35: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/35.jpg)
35
Properties
![Page 36: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/36.jpg)
36
Save the Change
![Page 37: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/37.jpg)
37
Run The Form
Click OpenorDouble Click The Form
![Page 38: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/38.jpg)
38
Add an Image Record
![Page 39: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/39.jpg)
39
Type in the Name
![Page 40: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/40.jpg)
40
Select ClipArt File
![Page 41: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/41.jpg)
41
Copy Butterfly to Clipboard
![Page 42: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/42.jpg)
42
Paste Butterfly to Image
![Page 43: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/43.jpg)
43
The Butterfly goes to Image
![Page 44: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/44.jpg)
44
Enter Next Record
![Page 45: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/45.jpg)
45
Insert Object
RightMouseClick
![Page 46: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/46.jpg)
46
Select Object Type
![Page 47: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/47.jpg)
47
Select Graph
![Page 48: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/48.jpg)
48
Graph
![Page 49: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/49.jpg)
49
Clip Art
![Page 50: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/50.jpg)
50
Cartoon
![Page 51: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/51.jpg)
51
Add a “Next” Button
![Page 52: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/52.jpg)
52
Name the Button
![Page 53: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/53.jpg)
53
The Button Event
![Page 54: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/54.jpg)
54
Exit Button
![Page 55: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/55.jpg)
55
Name the “Exit” Button
![Page 56: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/56.jpg)
56
The Exit Button
![Page 57: Database Systems Introduction to Microsoft Access Part 1](https://reader036.vdocuments.us/reader036/viewer/2022081422/5681632f550346895dd3ac16/html5/thumbnails/57.jpg)
57
End of Lecture