Courses / Access 2002/2003 Level 2

Access 2002/2003 Level 2

Provider: WWP Training Ltd
Course ID: ACCO32
Summary: This course will provide existing Access users with additional skills in the use of forms, queries and reports.

Generic logo

About the Course

Target: Regular users of databases
Entry requirements: A basic knowledge of using a personal computer in the Microsoft Windows environment is an essential for this course. Some experience in working with Access is also required, in particular you should be able to create new databases and tables, enter and edit records in both datasheet view and form view, use the autoreport wizard and report wizard to create a report.
Outcome: By the end of this course participants will be able to create data access pages; modify a table design; customise forms and reports; create more complex queries; create macros to automate tasks; and create a switchboard form.
Content: Additional query techniques * Creating a query to extract information from multiple tables * Finding unmatched records in a table Additional report techniques * Creating a report of information in multiple tables * Adding a calculated control to a report * Adding a cover sheet to a report Working with a data access page * What is a data a access page ? * Creating a data access page * Adding a grouping level to a data access page * Adding a hyperlink to a data access page Additional Access features * Using a database wizard * Adding a lookup field to a table * Defining an input mask for a field * Exporting an Access datasheet to Microsoft Excel Advanced table design techniques * Validating field entries, creating a lookup field * Creating a custom input mask Advanced form techniques * Creating a master-detail form, adding a picture to a form * Displaying the current date on a form, modifiying form properties. Advanced filter and query techniques * Creating an advanced filter * Including multiple conditions in a query * Creating a parameter query * Creating a query to generate summary information * Creating an action query Advanced report techniques * Creating a master-detail report, completing the report. * Modifying report properties Working with macros and modules * What is a macro? Creating a macro * Running a macro * Creating a command button * Writing an event procedure Using tools menu options * Setting database startup options * Setting a database password * Encrypting and decrypting a database * Compacting and reparing a database * Using the database splitter wizard and the linked table manager * Creating a replica of a database Creating pivottables and pivotcharts * Adding a pivottable to a data access page * Adding a pivotchart to a data access page Additional advanced Access features * Creating a many-to-many relationship between tables * Creating a switchboard * Exporting Access data to an XML document/importing an XML document into Access * Saving an Access database in an MDE file * Creating an Access workgroup
Cost: Following course delivery, we ensure that you continue to receive the full benefit of our training programmes (excluding Technical programmes) by offering 12 months free telephone support during normal office hours - boosting confidence and providing expert advice when you need help to solve a problem quickly.
Enrolment: For further information contact the course provider for details