|
|
| One Day | |
| One Day |
Constructing a Database using Microsoft Access
| Aim | To enable the participant to construct a database using tables and forms, create simple queries to extract data and displaying this information utilising reports. |
| Participants | No prior knowledge of Microsoft Access but a working knowledge of Windows. |
| Content | Creating a form Creating a report Creating a table: data type field properties setting the primary key Database Wizard Designing a database Entering data Modifying the data Printing Relationships Saving, closing and retrieving a database Searches: sorting filtering find and replace Simple queries Viewing the data |
Developing a Microsoft Access Database
| Aim | To enable the participant to generate more complex queries, forms and reports from an existing database. |
| Participants | Good working knowledge of Windows and Microsoft Access. |
| Content | Creating a chart
from a query Forms: properties combo box list box option group headers and footers Mailing labels Multiple searches Passwords Queries: comparison operators calculations functions parameters Relationships Reports: properties calculations page breaks headers and footers Tables: Hyperlink column Lookup column OLE Object |
