Access Form controls


The follow video is about Microsoft Access Form Controls and related tables used in Forms.

Microsoft Access courses are delivered in two formats, classroom based and online based.  If you wish to complete an online course check out http://www.itseasytraining.co.uk . Classroom based course details can be found here.

You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to info@itseasy.co.uk You can book courses via email or by calling 01670 732139.

Prices and location can be found here General information about IT’s Easy Training and delivery methods can be found here

Access Tab Controls

The Access tab control feature is a great resource and helps users populate forms in a tidy easy to use format. This video demonstrates how to add the tab control and edit the labels and embed tables amongst other things.

Option groups

The video explains how to use the Forms option group control to add numerical data to an underlying table. The tutor explains a quick way to add additional option group control and change the properties.

Related tables in Forms

The video explains how to use the wizard to create a form with related tables. The database used has related tables, which when the form wizard is used, the form displays both related tables. The tutor shows this as well as how to create a manual form with two related tables.

Search Box

The video shows how to add a combo box and set it to search field information. This box can be used as a lookup field which I would normally do at table design level but there is an option to add it to a form if it has not been done at the table level. This example however uses the combo box as a find feature.






Leave a Reply

You must be logged in to post a comment.

Testimonials


“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA




“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group




“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services




“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd