A 1 day Introduction Course, aimed at the new user, this course aims to give users the confidence and knowledge to create and use Access databases. By the end of the course, users will be able to create and amend database structures, manipulate data and produce forms and reports. Flat and Relational Databases Gain an understanding of the differences between the two different types of database structures. Getting started with Access Databases Introduces you to the key features of Access before creating an amending your own databases. • Understanding Database terminology • The specification • The Access screen tour • The Access objects • Creating a database • Amending an existing database Tables Shows you how to add/edit the Tables that are used to hold all the data used within the database. • Field properties • Data entry • Design mode and working mode • Primary and foreign keys • Naming conventions • Modifying an Access table • Saving a table • Filtering information • Sorting information Queries Manipulate the data and find specific records. • Running queries • Creating queries • Amending existing queries • Working with different views • Finding information Forms Create and edit user friendly forms for you users to complete. • Creating forms using Wizards • Creating forms using Design View • Edit existing form properties Reports Presentable ways of printing your data. • Reporting wizards • Printing Report Labels • Creating custom reports Problem solving Throughout the two days you will be shown a variety of common errors and solutions to these problems.
A 2 Day Intermediate Course, aimed at users that have been on the previous stages or an experienced user. This course aims to give users further knowledge and tools to create Access databases. By the end of the 2 days, users will be able use the Access Action queries, produce enhanced forms and reports and create relationships. Refresh on Previous Stages Quick refresh over key features of Access. • Flat File Databases • Database specifications Designing Tables Creating and modifying the Tables with more advanced properties. • Naming Conventions • Data Types • Data Validation • Combo Boxes • Linking Tables • Primary and Foreign Keys Creating and Modifying Forms Create/ Edit User friendly input forms. • Modifying Form Properties • Sub Forms • Tab Controllers • Search Forms • Relational Forms • Welcome Forms • Query Based Forms Queries Manipulate the data and find specific records. • Select Queries • Parameter Queries Quick refresh over key features of Access. • Flat File Databases • Database specifications • Temporary Fields • Cross Tab Quires • Update Queries • Delete Queries Reports Presentable way of printing your data. • Printing Custom Reports • Creating Query Based Reports • Custom Report Creators • Sub Reports Macros A brief introduction to macros.
A 2 Day Database Programming Course, aimed at users that have been on the previous stages; this course aims to give users further knowledge and tools to create and manipulate Access databases. By the end of the two days, users will be able to create user-friendly forms using macros and code. The databases created, will be easy enough for someone to use with no Access experience, however, the developer will have a difficult task creating these user-friendly databases. Quick Refresh on previous stages Macros: • Refresh • Requery • Max • Min • Setvalue • Open • Runcommand Macro names Macro group files SQL Programming Referring to a macro in a group file Conditional macros – If Statements Event Driven Programming – making forms come to life Understanding common control events and triggers Understanding form events Creating common form events A workshop – problem solving Differences between a macro and Visual Basic code ( VBA ) Advanced queries and reports Saving MDE format Search forms Security AJ Training Access Developers advanced tips and tricks
A 2 day VBA Programming Course aimed at advanced Access Users. This course aims to give users an introduction to Visual Basic Programming within the Access Application and the Microsoft Office Suite. Also the Users will have a greater understanding to Visual Basic, unlocking the door to the most popular used programming language in the world. Visual Basic environment introduction Visual Basic controls – events, properties, text, methods, forms, focus Visual Basic definitions – general, event, function, sub procedures and modules The Basic language – syntax, instructions, conditions and loops Using variables Text handling – property, functions, strings and variants Choices – option buttons, scroll bars, check boxes, list boxes, combo boxes Displaying and printing - message boxes Dialog boxes – creating a dialog box, using a dialog box and dialog control Differences with macros and VB Update and edit records by using VB code Word Links • Automatically linking data to Word • Controlling Word through Access • Generate Word documents automatically through Access Excel Links • Automatically linking data to Excel • Update spreadsheets through Access • Generate Excel documents automatically through Access Outlook Links • Automatically linking data to Outlook • Emails automatically from Access Error handling Debugging
Thanks , your score has been emailed to you. If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.
Based on your answers, the most appropriate course for you would be:-
Enquire Now
Price Estimate
Book Now
AJ Training standard rate is £575.00 + VAT. *
* Rate excludes travel expenses, for an approximate on site price please add your details below.
All bookings will be invoiced and payment is due 10 Days before the course date. Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates.
All bookings will be invoiced and payment is due 10 Days before the course date. Following your booking you will receive an email confirming the details including course start times and location, we will attach a course overview, pre course questionaire, directions and an invoice. Should you require assistance or wish to book multiple courses please call 01709 352307 or email info@ajtraining.net and we will be happy to help. All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.
There are currently no scheduled courses. Please fill out the details below and we would be happy to scheduled a course around your availability. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates. The prices shown are per delegate, per day and exclude VAT.
Please complete the form below to enquire about one company / bespoke courses. All bookings will be charged at the advertised rates. The prices shown are per day and exclude VAT.
Our experienced training team have designed each package from the ground up, to ensure it delivers on content and is simple to follow. We always include both video and exercises to help you along the way.
Each of our paid courses comes with our full support, if you get stuck, want to check your understanding or require any additional information, this is all part of the service and our team are here to help!
eLearning package per user @ £39.99 Plus VAT 12 months online access
Although eLearning packages offer a great stand alone product we also offer anyone who attends a standard course the option of adding the complementing eLearning package for only £25.00. For more information or multiuser access please : Call : 01709 352307 Visit : Contact us page Email : info@ajtraining.net
AJ Respond to all online bookings within 3 working hours, we will email you back to confirm prices, availability and content of the requested course. Once confirmed we will forward joining instructions along with an invoice payable 10 days before the course date.
Please complete the form below. If you have a date in mind please let us know by completing the "request date". We will be in touch shortly to discuss your training needs and proposed date for the scheduled course. Should you require assistance or wish to book multiple courses, please call 01709 352307 or email info@ajtraining.net, we will be happy to help. All bookings will be charged at the advertised rates. Prices quoted are per deletgate, per day.
Thank you for your . If there is anything we can help with in the meantime, please call 01709 352307 or email: info@ajtraining.net.
Gave a good overview of behind the scenes in access
really informative. Great trainer
Incredibly insightful and useful for my daily tasks.
A helpful Introduction to access
Great to finally understand the basics on how to create tables, forms and reports.
First time I've used Access and really enjoyed the course.
Really interesting and informative
Really enjoyable. Access is something I had not used before and was impressed with it.
Very informative and helpfull
Very interesting, gained a lot of new knowledge