Practical Access 97 Syllabus - Module 1, Using Access Databases

1.	About this course	Welcome Introduction and objectives Getting help with the course How the course is structured About the case study database About the exercises	2.	Introducing Microsoft Access	Objectives Overview Understanding databases Starting Access Opening a database Understanding the Access window The parts of a database Saving and closing a database Getting help on Access Exiting Microsoft Access Exercise Review questions Summary
3.	Using Tables	Objectives Overview Introducing Access Tables Opening a table Viewing tables Navigating around tables Navigating with the keyboard Adding new records Editing records Deleting records Copying and pasting data Using the Zoom box Checking your spelling Printing tables Finding and replacing information Sorting records Filtering records Filtering by Form Exercise Review questions Summary	4.	Formatting Tables	Objectives Overview Resizing columns and rows Moving columns Hiding and showing columns Freezing and unfreezing columns Changing the font Changing cell effects Exercise Review questions Summary
5.	Using Queries	Objectives Overview Introducing Access Queries Running a query Viewing queries Formatting queries Printing query results Exercise Review questions Summary	6.	Using Forms	Objectives Overview Introducing Access Forms Opening a form Viewing forms Navigating records Adding records Modifying records Deleting records Printing records Exercise Review questions Summary
7.	Using Reports	Objectives Overview Introducing Access Reports Opening a report Viewing reports Printing reports Exercise Review questions Summary	8.	Using Switchboards	Objectives Overview Introducing Access Switchboards Using switchboards Exercise Review questions Summary
9.	Module Summary	Congratulations Your quiz score Good luck

Practical Access 97 Syllabus - Module 2, Creating Access Databases

1.	Creating Databases	Objectives Overview Planning a database Designing a database Using the Database Wizard Creating a blank database Using the Table Wizard Working in Design View Understanding Data Types Changing a field's Data Type Exercise Review questions Summary	2.	Creating Tables	Objectives Overview Adding new tables from scratch Indexing fields in a table Adding a primary key to a table Saving the table design Changing the table design Exercise Review questions Summary
3.	Working with Fields	Objectives Overview Understanding field properties Setting field descriptions Adding field captions Changing field sizes Formatting text and memo fields Formatting number/currency fields Formatting date/time fields Formatting Yes/No fields Setting a default value Making a field required Automating data validation Setting an input mask Allowing zero length data entry Handling data integrity violations Exercise Review questions Summary	4.	Creating Lookup Fields	Objectives Overview Introducing Lookup Fields Creating a value list Creating a lookup list Modifying lookup fields Using key-less tables Exercise Review questions Summary
5.	Creating Queries	Objectives Overview Using the Simple Query Wizard Creating a simple query Running a query Modifying a query Saving and closing a query Adding criteria to a query Using numbers, dates and wildcards Adding multiple criteria Sorting queries Hiding and showing fields Exercise Review questions Summary	6.	Creating Forms	Objectives Overview Creating forms with AutoForm Using the Form Wizard Modifying form design Selecting controls and labels Adding and deleting fields Moving labels and controls Resizing labels and controls Aligning labels and controls Spacing labels and controls Using the grid Changing the field tab order Exercise Review questions Summary
7.	Creating Reports	Objectives Overview Creating reports with AutoReport Using the Report Wizard Modifying report design Selecting controls and labels Adding and deleting fields Moving labels and controls Resizing labels and controls Aligning labels and controls Spacing labels and controls Using the grid Adjusting page layout Adding page numbers Adding the date and time Creating mailing labels Exercise Review questions Summary	8.	Formatting Forms and Reports	Objectives Overview Applying an AutoFormat Formatting with fonts Formatting with colour Changing text alignment Applying special effects Adding pictures Drawing lines Exercise Review questions Summary
9.	Creating Switchboards	Objectives Overview Creating a switchboard Invoking a switchboard Customising a switchboard Exercise Review questions Summary	10.	Module Summary	Congratulations Your quiz score Good luck