Access - Advanced Forms and Interfaces Course
|
Summary
|
|
|||||||||||||
Access - Advanced Forms and Interfaces Course
Access - Advanced Forms and Interfaces - 2 day course in Crawley
This 2 day training course is designed to teach delegates how to create a professional looking interface with Access that makes it easy for others to use their database application.
Delegates will also learn how to create Access forms and reports that provide a powerful interface that can be used to perform multiple tasks.
By the end of the course delegates will be able to:
- Create forms for interactive searching and display of search results
- Build simplified forms and use forms within forms
- Create interactive combo and list controls on forms
- Use macros and simple Visual Basic to make forms interactive
- Build a navigation system including custom menus and toolbars
If you want to find out more about Access - Advanced Forms and Interfaces Course, you can make an information request below and the school will contact you with further information.
Suitability and application
This Access - Advanced Forms and Interfaces is suitable for users who can design and build tables and queries for a relational database and who now wish to create a professional looking interface that makes it easy for others to use their database application.
Pre-requisites: You should be able to design and use Access databases and be able to build queries.
Enquire to see if this Access - Advanced Forms and Interfaces Course is suitable for you here.
Access Database Design - Advanced Course Content
This Access - Advanced Forms and Interfaces course is designed to cover the following areas:
Building search forms
- Creating an unbound form
- Using text boxes and combos
- Adding a command button
- Creating a form to display search results
- Changing form properties
Interactive text boxes and combos
- Changing control types
- Editing combo properties
- Creating inter-dependent controls
- Understanding control and form events
- Applying macro and Visual Basic commands to an event
- Hiding and showing a control
Using the Dlookup function
- Dlookup data from a table
- Dlookup data from a query
Forms within forms
- Using the form wizard
- Creating a subform using “drag and drop”
- Changing form and subform properties
- Creating a linked form
Simplifying form layouts
- Using a tab control
- Changing properties
- Inserting and deleting pages
- Page order
Database security (not available in 2007)
- User-level security overview
- Implementing user-level security
- Opening a secure database
- Creating a group
- Creating a user
- Setting permissions
Building front end navigation
- Using the switchboard manager
- Adding commands to a switchboard page
- Switchboard properties
- Customising the switchboard
Customising a database application
- Displaying the logged on user
- Displaying the switchboard page name
- Creating a custom menu and toolbar
- Startup settings
- Creating a splash screen
Access - Advanced Forms and Interfaces Course Content
This Access - Advanced Forms and Interfaces course is designed to cover the following areas:
Building search forms
- Creating an unbound form
- Using text boxes and combos
- Adding a command button
- Creating a form to display search results
- Changing form properties
Interactive text boxes and combos
- Changing control types
- Editing combo properties
- Creating inter-dependent controls
- Understanding control and form events
- Applying macro and Visual Basic commands to an event
- Hiding and showing a control
Using the Dlookup function
- Dlookup data from a table
- Dlookup data from a query
Forms within forms
- Using the form wizard
- Creating a subform using “drag and drop”
- Changing form and subform properties
- Creating a linked form
Simplifying form layouts
- Using a tab control
- Changing properties
- Inserting and deleting pages
- Page order
Database security (not available in 2007)
- User-level security overview
- Implementing user-level security
- Opening a secure database
- Creating a group
- Creating a user
- Setting permissions
Building front end navigation
- Using the switchboard manager
- Adding commands to a switchboard page
- Switchboard properties
- Customising the switchboard
Customising a database application
- Displaying the logged on user
- Displaying the switchboard page name
- Creating a custom menu and toolbar
- Startup settings
- Creating a splash screen
Expenses
The cost of this Access - Advanced Forms and Interfaces is £199.00 + VAT.
The following Versions are available: 2003, 2007, 2010
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
Reviews by course attendees
Show all reviews
To request information from Access - Advanced Forms and Interfaces Course, please fill out the following details:
| Average rating | Quantity | Rec. | ||
| 5.0 | 1 | 100 % |
