If you need to share information from your database with someone, but don't want them actually working with your database, you should consider creating a Report. Reports allow you to organise and present your data in a reader-friendly, visually appealing format. Access 2010 makes it easy to create and customise a report using data from any query or table in your database.
In this lesson, you will learn how to create, modify, and print reports.
Download the assignment task and make a start! Step 1: Create your customer table by entering in all required field names and customer details. Enter them straight into the table or create a form to enter the data (you will need to create a form anyway). Make sure you include customers that live in a variety of suburbs in Kwinana (ie Leda, Orelia, Parmelia, Calista, Medina), and also a variety of ages.Make sure you also have set the correct data type for your fields, e.g. select NUMBER for the PHONE field. You should have at least 30 customers! Name your table appropriately. Step 2: Create Queries outlined in the task sheet. Step 3: Create your Reports outlined in the task sheet.
DATABASES:
DESIGNING A REPORT
If you need to share information from your database with someone, but don't want them actually working with your database, you should consider creating a Report. Reports allow you to organise and present your data in a reader-friendly, visually appealing format. Access 2010 makes it easy to create and customise a report using data from any query or table in your database.
In this lesson, you will learn how to create, modify, and print reports.
http://www.gcflearnfree.org/access2010/10.2
Download the assignment task and make a start!
Step 1:
Create your customer table by entering in all required field names and customer details. Enter them straight into the table or create a form to enter the data (you will need to create a form anyway).
Make sure you include customers that live in a variety of suburbs in Kwinana (ie Leda, Orelia, Parmelia, Calista, Medina), and also a variety of ages.Make sure you also have set the correct data type for your fields, e.g. select NUMBER for the PHONE field.
You should have at least 30 customers! Name your table appropriately.
Step 2:
Create Queries outlined in the task sheet.
Step 3:
Create your Reports outlined in the task sheet.