Database Development using Microsoft Access CMPCP0015

1
Database Development using Microsoft
AccessCMPCP0015

• Lecture 11
• Coursework Review
• Mengjie Yu
• M.Yu_at_2001.ljmu.ac.uk

2
Coursework
The necessary forms, reports, queries and
other objects needed to complete this coursework
!!!
3
Coursework

• Forms
• Data Edit Interface (see in Tutorial 7)
• Add New records or edit the existing records
• e.g. Staff, Product, Suppliers, Customers
• Create forms by using wizard
• Data Entry Interface
• Allows the data entry only !!!
• Open existing forms in the Data Entry model
  1) through switchboard (see Tutorial 9)
  Choose the command Open Form in Add Model
• 2) through the DoCmd command (see Tutorial
  10) DoCmd.OpenForm "Member", acNormal, ,
  , acFormAdd

4
Coursework

• Forms
• Main Form with Sub Form (see in Tutorial 8)

e.g. Customer order / Order Details
5
Coursework

• Forms
• Filter records bound with form (Optional)
• Use Macro (see in Tutorial 9)
• Create Macro object and assigned with the
  control on the form
• Use DoCmd (see in Tutorial 10)
• Use DoCmd to open the form by setting the
  filter condition
• e.g. Create a form to set the criteria to
  open the placing order form

6
Coursework
7
Coursework

• Forms
• Switchboard Design ( see in Tutorial 9)
• Designed as the start-up form for the database
  application
• Contain the sub-switchboards to group the
  functionalities

Short-cuts for Data Entry Interface
8
Coursework

• Reports
• Order Pad
• Pick List Sheet for the warehouse
• Invoice for the customers

9
Coursework

• Order Pad Report
• Data Resource a query across tables (see
  Tutorial 5)
• Customer Order and Order Details Tables
• Preview the report
• Associated with a parameter query (see Tutorial
  6)
• Use prompt boxes to accept the criteria values
  e.g. CustomRef Date
• Opened from the form that places the customer
  orders
• Use DoCmd to open the report with the criteria
• DoCmd.openReport OrderPad,,,WHERE (see
  Tutorial 10)

Optional
10
Coursework

• Invoice for the customers Report
• Data Resource
• Add summary fields
• Sub_Total Total fields (see Tutorial 8)
• Preview the report
• Associated with a Parameter Query
• Use prompt boxes to accept the criteria values
  e.g. CustomRef Date
• Opened from the form that places the customer
  orders
• Use DoCmd to open the report with the
  criteria
• DoCmd.openReport OrderPad,,,WHERE (see
  Tutorial 10)

11
Coursework

• Pick List sheet for the warehouse Report
• Preview the report
• Associated with a Parameter Query
• Use prompt box to accept the criteria value
• e.g. Date
• Create a form to set the criteria to open the
  report Use DoCmd to open the report with the
  criteria
• DoCmd.openReport OrderPad,,,WHERE (see
  Tutorial 10)

12
Coursework

• Queries
• used as record sources for forms or reports
  design
• used as control sources for the controls design
• e.g. Combo box displays the list of Sales staff
  in the Microbrew company
• !! Filter the table by using the criteria
  positionSA (see Tutorial 5 specify
  criteria in query)