Transcript MS Access Database

Database Systems
Introduction to
Microsoft Access
Part 3
1
Create Form by Using Wizard
2
Create Form by Using Wizard
3
Create Form by Using Wizard
4
Create Form in Design View
5
Create Form in Design View
6
Sample Form
7
Adding Records Using A Form
8
Form Controls
9
Reports
10
Reports
11
An Access Report with
All Sections Shown
12
Exporting Access Query to Excel
Workbook File
13
Reposition and Resize Controls
in Subreport
14
Query Data Exported to an
Excel Worksheet
15
Import Data from Other
Applications as an Access Table
• You can import data from a variety of other
applications, including Excel lists, as an
Access table.
• If you import data from an Excel list, be
sure that the range of the list is named
before attempting to import the data in the
list.
16
Import Spreadsheet Wizard Dialog Box
17
First Row Contains Column Headings
18
“Choose primary key” Option
19
Imported Trial Balance Table in
Datasheet View
20
Macros in Microsoft Access
•
Use to Open or Close Forms and Reports
•
Print Reports, or send to other Applications
•
Build Menus
•
Execute a command from a Menu
•
Display Messages or Sound Beeps
•
Start Other Applications
21
A Simple Button Menu Form
Open Form A
Open Form B
Exit
22
Button for Form A
23
Name the Button and Finish
24
The Button to Open Form A
25
Button Wizard gives VB Event Procedure
26
Event Procedure for the OpenA Button
27
Cancel Wizard to Define a OpenB
Wizard Off
OpenB
Open Form B
Adjust
Size
28
Define a Macro for OpenB OnClick Event
Click
Dots
Select
Macro
Click
29
Name the Macro
Open Form B
Click
30
Select OpenForm
Click
31
Macro: Open Form B
FormB
Click
32
System Check
Click
33
Add the Exit Button
Wizard
On
Click
Click
34
The Exit Button
35
Exit.OnClick Event Procedure
36
Run the Simple Menu
Click
37
Event Procedure - Form A
38
Event Macro - Form B
39
Form with Local Event Procedures
40
Local Event Procedures or Functions
Click
41
Local VBA Code
42
Module Area
43
Global Values and Procedures
44
How Big with Access
There are file size limitations with MS Access.
Tables
Queries
Forms
Reports
Code
Table Space
Code Space
95
29
511
185
500 (200,000 statements)
800Mb
60Mb
45
Garbage Collection
Regular Compacting is
required to keep size down.
(Tools/Utilities/Compact)
46
MS Access - Offers
Tables Database Table Definition/Entry
Queries
SQL Queries against Tables
Forms
Forms to be displayed
Reports
Reports to be Printed
Macros
Macro Commands
Modules
Visual Basic Code
47
End of Lecture
• MS Access is include with some
versions of MS Office. It can be
learned by experimentation.
• MS Access is not a full featured
database like Oracle but it comes
very close and is a good alternative
for the PC desktop environment.
48