Tutorial database creation
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Tutorial: Database Creation PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on
  • Presentation posted in: General

Tutorial: Database Creation. Assignment #2. Access 2000 Tutorial. MS Access Database Objects Tables (tuples and attributes) Queries (questions about the data) Forms (to enter, display, & edit data) Reports (formatted / organised information) Macros (automate repetitive tasks)

Download Presentation

Tutorial: Database Creation

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Tutorial database creation

Tutorial: DatabaseCreation

Assignment #2


Access 2000 tutorial

Access 2000 Tutorial

MS Access Database Objects

  • Tables (tuples and attributes)

  • Queries (questions about the data)

  • Forms (to enter, display, & edit data)

  • Reports (formatted / organised information)

  • Macros (automate repetitive tasks)

  • Modules (programming; larger-scale than macros)

IS for Management


Database assignment overview

Database Assignment Overview

  • Teams of Two (or by yourself)

    • Create 4 database tables

    • Modify field attributes

    • Enter/edit data

    • Add fields to database (if desired)

    • Develop forms for data entry/review

    • Enter data into tables

    • Query database (to list specific information)

  • Deliverables

    • Five specific reports

IS for Management


Database development how tos

Database Development How-Tos

  • Use Database Wizards

    • To create initial database

    • To create initial reports

    • Modification will be required

  • Plan, Analyse, Design, Implement, Maintain (SDLC)

IS for Management


Next class

Next Class

Chapter 6: Telecommunications and Networks

Case: Nav Canada (pages 284-285)

IS for Management


  • Login