OPERATE A DATABASE APPLICATION
MICROSOFT ACCESS 2003

In this course you will cover the following chapters: Access 2003 Orientation; Designing a Lookup Database; Creating a Lookup Database; Adding Records to a Table; Adding Transactional Records; Working With Records; Sorting and Filtering; Creating Queries; Query Techniques; Multi-Table Queries; Creating and Using Reports; Modifying Reports; Multi-Table Reports; Creating and Using Forms; Modifying Forms; and Multi-Table Forms.

Please do not hesitate to call us if you have any difficulties throughout this course. We will be more than happy to assist you.

---

This course requires Microsoft Access 2003.

WHEN YOU ARE READY TO BEGIN

Step 1: Ensure your Practice Files are installed on your personal computer. We recommend that you make a new Folder on your Desktop and name it Database or Access 2003. Then click on the link to each File in the following table. When the file opens, select the 'Save As' option and save it to your Database folder. Do not change the file name, so that you can locate the correct file when your workbook instructs you to open it.

File 1	File 11	File 21	File 31	File 41	File 51	File 61	File 71	File 81	File 91	File 101
File 2	File 12	File 22	File 32	File 42	File 52	File 62	File 72	File 82	File 92	File 102
File 3	File 13	File 23	File 33	File 43	File 53	File 63	File 73	File 83	File 93	File 103
File 4	File 14	File 24	File 34	File 44	File 54	File 64	File 74	File 84	File 94	File 104
File 5	File 15	File 25	File 35	File 45	File 55	File 65	File 75	File 85	File 95	File 105
File 6	File 16	File 26	File 36	File 46	File 56	File 66	File 76	File 86	File 96	File 106
File 7	File 17	File 27	File 37	File 47	File 57	File 67	File 77	File 87	File 97	File 107
File 8	File 18	File 28	File 38	File 48	File 58	File 68	File 78	File 88	File 98	File 108
File 9	File 19	File 29	File 39	File 49	File 59	File 69	File 79	File 89	File 99
File 10	File 20	File 30	File 40	File 50	File 60	File 70	File 80	File 90	File 100

Step 2: Ensure you have your hard copy Student Notes for the applicable Chapter.

Step 3: Work through the Chapter and when you have completed the lesson and exercises, come back to this page.

Step 4: Access the Test for the applicable Chapter via the link below (Eg. ODA03T01) and save the Test to your personal computer.

Chapter Title	Test Banks
Chapter 1 - Access 2003 Orientation	ODA03T01
Chapter 2 - Designing a Lookup Database	ODA03T02
Chapter 3 - Creating a Lookup Database	ODA03T03
Chapter 4 - Adding Records to a Table	ODA03T04
Chapter 5 - Adding Transactional Records	ODA03T05
Chapter 6 - Working With Records	ODA03T06
Chapter 7 - Sorting and Filtering	ODA03T07
Chapter 8 - Creating Queries	ODA03T08
Chapter 9 - Query Techniques	ODA03T09
Chapter 10 - Multi-Table Queries	ODA03T10
Chapter 11 - Creating and Using Reports	ODA03T11
Chapter 12 - Modifying Reports	ODA03T12
Chapter 13 - Multi-Table Reports	ODA03T13
Chapter 14 - Creating and Using Forms	ODA03T14
Chapter 15 - Modifying Forms	ODA03T15
Chapter 16 - Multi-Table Forms	ODA03T16

Step 5: Open the Test on your personal computer and enter your name in the box provided. Complete your answers and save the document.

Step 6: Click on this email link mvcc@mvcc.org.au to forward your Test Answer Sheet as an attachment - don't forget to attach your saved file! Please ensure that you enter a subject heading in the email (Eg. Operate a Database Application - Access 2003 - Test 01). We will provide you with feedback upon receipt of each Test and will mail the Student Notes for the next Chapter to you.

On completion: We constantly strive to ensure that our training is of the highest possible standard. As such, we need your help. Please complete our online Student Evaluation, which will take approximately 3 minutes. Thank you. Your feedback is greatly appreciated.