AIS PowerPoint Presentations - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

AIS PowerPoint Presentations

Description:

Title: AIS PowerPoint Presentations Subject: Topic 1 - The Study of Accounting Information Systems Author: Marianne Bradford, M.B.A., C.P.A. The University of Mississippi – PowerPoint PPT presentation

Number of Views:99
Avg rating:3.0/5.0
Slides: 41
Provided by: Mariann176
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: AIS PowerPoint Presentations


1
(No Transcript)
2
Chapter 5 Database Forms and Reports
  • Introduction
  • Forms
  • Reports

3
Forms
  • 3 Major Sections
  • Heading section
  • Detail section
  • Navigation bar
  • 3 Advantages
  • Avoid accidental replacement of data
  • All data entry points on one screen
  • Can be customized

4
Form Example
5
(No Transcript)
6
Creating Simple Forms
  • Enter the appropriate settings in the Form Wizard
    dialog boxes
  • Customize the Form
  • Form Controls
  • Bound Controls
  • Unbound Controls
  • Property Sheet Window
  • Control Source Property

7
Form Wizard Screen Shots
8
Form Wizard Screen Shots
9
Form Wizard Screen Shots
10
Property Sheet Window
11
Creating Simple Forms
  • Refine your Design
  • Toggle between run mode and design mode
  • Continue to adjust the design as needed
  • Reset the Tab Order
  • Create a custom order for the objects

12
Subforms - Showing Data from Multiple Tables
  • A form within a form
  • Displays data related to the information on main
    form
  • Two Methods to Creating Subforms
  • When using the Form Wizard
  • After the creation of the main form

13
Form with a Subform
14
Study Break 1
  • In Access, you can use a form to perform all of
    the following tasks except
  • Create a new record in a specific table
  • Change the information in an existing record of
    a table
  • View the information from many different records
    sequentially
  • All of these are tasks that can be performed
    with an Access form

15
Study Break 1 - Answer
  • In Access, you can use a form to perform all of
    the following tasks except
  • Create a new record in a specific table
  • Change the information in an existing record of
    a table
  • View the information from many different records
    sequentially
  • All of these are tasks that can be performed
    with an Access form

16
Study Break 2
  • A form control that does not change from record
    to record is probably
  • A design-time control
  • A bound control
  • An unbound control
  • A mistake

17
Study Break 2 - Answer
  • A form control that does not change from record
    to record is probably
  • A design-time control
  • A bound control
  • An unbound control
  • A mistake

18
Study Break 3
  • If the form onscreen appears with grid lines and
    you can view the Toolbox, this form is most
    likely in
  • Design mode
  • Run mode
  • Sleep mode
  • Wizard mode

19
Study Break 3 - Answer
  • If the form onscreen appears with grid lines and
    you can view the Toolbox, this form is most
    likely in
  • Design mode
  • Run mode
  • Sleep mode
  • Wizard mode

20
(No Transcript)
21
Reports
  • Provide custom information to database users
  • Can be simple documents or complex outputs
  • Are strictly outputs, do not allow for input of
    data

22
Report Example
23
Report Components
24
Creating Simple Reports
  • Launch the Report Wizard
  • Select the Underlying Data Source and Desired
    Fields
  • Indicate any Grouping Levels

25
Report Wizard Screen Shots
26
Report Wizard Screen Shots
27
Report Wizard Screen Shots
28
Report Wizard Screen Shots
29
Report Wizard Screen Shots
30
Creating Simple Reports
  • Indicate any Sort Fields and Select the Desired
    Report Format
  • Name the Report
  • Modify the Design of the Report as Desired

31
Report at Design Time
32
Additional Items
  • Calculated Fields
  • System must calculate the field based on other
    data fields
  • Recomputed when needed
  • Grouped Data
  • Useful organizations of information
  • Control break

33
Report with Calculated Fields
34
Calculated Fields with Grouped Data
35
Study Break 4
  • Which of these best identifies the underlying
    data source for an Access report?
  • Only tables
  • Only queries
  • Both tables and queries
  • Tables, queries, and forms

36
Study Break 4 - Answer
  • Which of these best identifies the underlying
    data source for an Access report?
  • Only tables
  • Only queries
  • Both tables and queries
  • Tables, queries, and forms

37
Study Break 5
  • Which of the following is not a typical part of a
    printed report using Access?
  • Report header
  • Report footer
  • Navigation bar
  • Detail line

38
Study Break 5 - Answer
  • Which of the following is not a typical part of a
    printed report using Access?
  • Report header
  • Report footer
  • Navigation bar
  • Detail line

39
Chapter 5
40
(No Transcript)
About PowerShow.com