Contact Us
Feed Back Form
E-Mail
Us
Tel:
024 7637 2073
Contact Us |
Tel: |
|
To view course details please Click on the Course Title
in the table below |
Title |
Brief Description |
| Part 1 | More than just a beginners course! Creating a Database / Designing Tables / Specifying Field Properties:- Primary Key, Default Value , Input Masks , Validation Rules , Formats / Criteria Expressions / Filters and Queries / Forms / Reports. |
| Part 2 | Create a small application using multiple tables and simple relationships / reminder on field properties / Lookup Wizard / Forms / Command Buttons / Append and Delete Queries / Macros / Archiving Data / Calculated Controls / Combo Boxes plus many useful tips and tricks.. |
| Part 3 | Introduces VBA (Visual Basic for Applications). Contains many examples of inserting VBA code behind forms and their controls to get Microsoft Access to do those things that seem impossible. More on understanding Form Properties. Relating tables (Header , Detail) and getting to grips with Referential Integrity. Main / Sub forms / Totaling sub form detail, plus Controls on forms. |
| VBA behind Access |
This 2 day course expands on the knowledge gained in Part 3. No previous programming knowledge is required as all is explained. Enhance your Microsoft Access databases with the functions and procedures you will learn on this course. |
| Designing
Forms and Reports
|
This 2 day course begins with simple form design techniques covering topics such as 'What is a form control'? to more advanced features on how to trigger event handling and using snippets of VBA code. The 2nd day leads into the similarities in report design to form design and then explains how to Group / Sort and Total data within a report. By the end of the course a candidate should feel more confident in the design of both Forms and Reports enabling them to give that 'professional' touch to an Access database. |
| Queries and Reports | Select Queries, Update Queries, Delete Queries, Append Queries, Cross tab Queries, Make Table Queries plus Grouping, Sorting and Totaling data in Reports. |
To contact A.K.Solutions:- enquiries@aksolutions.co.uk |
|
Contact Us |
Tel: |
|
Copyright © 1994 - 2006 A.K.Solutions. All rights reserved. Revised: January 17, 2006. |
