Learn to Use Access 2003 Learn to USE Range - The 'Learn to Use' series of IT training discs have been developed specifically for helping PC users to become more proficient with key applications without needing to wade through complex books. The approach is a show and do method, which has proven to deliver outstanding retention of skills, required to become a competent computer user. Here the task list provides you with a good, all round understanding of databases. You will soon be producing well structured Access databases.

 

Understanding tables part Two Define a primary key Index a field with or without duplicates Change field format attributes Understand effects of changing field sizes Create simple validation rules Change the width of columns in a table Move a column in a table Create relationships between tables Delete relationships between tables Apply rules to relationships Use of forms Open a form Create and save a form Use a form to modify records Navigate between records Add and modify footers and headers Delete a form Save and close a form Retrieving information Use the search command Apply a filter to a table or form Remove a filter from a table or form Create and save simple queries Add criteria to a query Edit a query by adding or removing data Edit a query by changing field attributes Run a query Delete a query Save and close a query Sort data in table, form or query output Reporting Create and save a report Re-arrange a report layout Group data under a specific heading Use group functions within a report Add or modify headers and footers Delete a report Save and close a report Prepare outputs Preview a table, form or report Change report orientation Print a page, selected record(s) or all records from a table Print all records from using form layout Print the result of a query Print all or some pages in a report

Using the application part One Understand what a database is Understand how a database is organised Understand what a primary key is Understand what and index is Understand the purpose of relating tables Setting rules to ensure relaionships are valid Open and close a database Open and log on to a database Using the Application part Two Create a new database Save a database to a location on a drive Using the help functions Close a database Change view modes in tables, forms and reports Modify toolbar display Understanding tables part One Create and save a table Add and delete records in a table Add a field to an existing table Add or modify data in a record Delete data in a record Use the undo command Navigate within a table between records Delete a table Save and close a table