CPSC 203 Introduction to Computers

1. CPSC 203Introduction to Computers T59 & T64 By Jie (Jeff) Gao

2. Forms in Access • A form in Access is used to provide a friendly interface to the user • With labels and input boxes to input and/or view data • The user can input data into a table through a form created on that table • The user can also navigate data by using the form CPSC 203 Tutorial by Jie Gao

3. Create a Form • Two methods: Wizard or Design View • Form Wizard is easy to use. You can create a form for a table with simple steps • Design View can provide you more power. You can implement advanced features! CPSC 203 Tutorial by Jie Gao

4. Form Wizard • Select • Which fields will appear in the formYou can select fields from multiple tables • Form type (layout) • Style • Name • You can click “Finish” when you accept the defaults for the following steps. CPSC 203 Tutorial by Jie Gao

5. Form Design View • You can • Add controls to the form • Drag fields into the form • Adjust the form layout • Add header or footer • Even do something like programming CPSC 203 Tutorial by Jie Gao

6. Queries in Access • A query in Access is used to filter records and fields • Only the fields and records which match the query are returned • The data in a query’s view is from some table CPSC 203 Tutorial by Jie Gao

7. Create a Query (Simple) • Two ways: Wizard or Design View • Query Wizard can only create simple queries such as select part of the fields to display • Query Design View provides you the powerful interface to create various queries • Simple examples CPSC 203 Tutorial by Jie Gao

8. Assignment 3 • Start with a blank database • Create a table • Create a form on that table • Input data • Create reports • Create queries when necessary • Refer to the information on my web site CPSC 203 Tutorial by Jie Gao