Access Forms & Reports:
Exercise 4-4

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016


You need to use what you just learned, and maybe learn a little more. Complete all parts of the following exercises. Don't forget to backup your Class disk when you have completed the exercises or whenever you stop for the day and saved a document along the way.

This exercise does not use any resource files.
Full floppy disk How to handle a full disk

 

 


 

Where you are:
JegsWorks > Lessons > Databases

Before you start...

Project 1: Intro

Project 2: Access Basics

Project 3: Tables & Queries

Project 4: Forms & Reports
    Import/Export/LinkTo subtopics
    Designing FormsTo subtopics
    Designing ReportsTo subtopics
    Special Forms & ReportsTo subtopics
    Summary
    Quiz
    Exercises Arrow: subtopic open
    Icon: Exercise Ex. 4-1 Scouts
    Icon: Exercise Ex. 4-2 Ornaments
    Icon: Exercise Ex. 4-3 Computers Today
    Icon: Exercise Ex. 4-4 On Your Own


Search  
Glossary
  
Appendix



Exercise Database 4-4: On Your Own


What you will do: Create a database of your own

You will create a database of your own which includes numbers for some kind of calculation. These might be prices or scores or whatever is useful to you.

Suggestions for type of database:

  • club members with addresses, phone numbers, dues paid or not, club office held...
  • records of a science fair experiment
  • sales of several products by type or date or region or salesman...
  • events scheduled at a theater or show ring with name of event, responsible person or organization, dates, times, fee, paid or not, description of event
  • customers and their orders (requires 3 main tables)
  • courses taken with data on semester or dates, instructor, name of course, school, details of course content, final grade, cost, average grades...
  1. Create a new, blank database. Save it with the name ex4-your name.mdb to your Class disk in the folder databases project4. (Replace "yourname" in the file name with your own name, of course!)
  2. Create at least 3 related tables, using the method of your choice.
  3. Create at least 1 query that used fields from at least 2 tables.
  4. Create at least 1 form to enter data into one of your tables.
  5. Include a subform to show the related records.
  6. Add at least 10 records to your primary table and at least 4 related records for some of those in the primary table.
  7. Create a printable form and Icon: Printer Print one of the records.
  8. Create a report that summarizes the data.
  9. Create a report that uses a subreport, either with each record or providing a summary in the report header or footer.
  10. Create one of the special forms and reports: switchboard, custom dialog, labels report, chart report, report with multiple columns
  11. Icon: Printer Print all of your reports.
  12. Icon: Printer Print the Relationships.

LessonsWorking with Databases Previous Page Next Page




Teachers: Request permission to use this site with your class
 
Copyright 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD

Want to help?


~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God.  ~~


Last updated: 30 Apr 2012