Instructor Led Access Training in Derbyshire, uk

Advanced SQL If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This three day course assumes that you know how to use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and  more...

Advanced VBA for Applications If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean! For a full list of course topics, see our website  more...

Basic Querying in Access 2007 Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered. For a full list of course topics, see our  more...

Access VBA Macros If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn Access programming. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun! For a full list of course topics, see our website  more...

Microsoft Access 2010 Basic Querying Have you got a corporate database from which you want to extract information? It might be Access, or it might be Sage or in SQL Server. This one-day course will not show you how to build new databases, but it will show you how to get information out of existing ones. The course explains how databases are constructed, then shows the ins and outs of creating queries and reports. Note that this  more...

Access 2010 Introduction for Developers ...Access database, or make changes to an existing one? This is the course for you! Beginning with the oh-so-important principles of database design, the course explains step by step how to create a database, create queries, design forms and reports and write the Visual Basic code that you need to link all of this together. Note that it takes a long time to learn Access, so this course should be  more...

Basic Querying in Access 2003 Does your computer system generate large amounts of data, which you find is just too cumbersome to analyse? This course assumes no knowledge of Access, and shows how to use Access queries to manipulate data (whether this is held in Access, Excel or some other format). Database design, tables, forms and reports are also normally briefly covered. For a full list of course topics, see our  more...

SSRS 2005 In the current business environment organisations need to be able to transform data into clear, concise, user-friendly formats. This two-day SQL Server Reporting Services (SSRS) course shows you how to create, execute and manage reports. Using SQL Server 2005 Business Intelligence Studio you will create interactive reports and learn how to deploy and export them in various formats. You will  more...

Writing SQL You may have a fantastic database, but unless you can extract useful information from it, it may as well not exist! This two-day course shows you how to mine your database, from getting a mailing list of people meeting certain criteria through to compiling summary information for the board. Note that the SQL language varies slightly between different database providers; this course teaches the  more...

Access 2007 Introduction for Developers ... task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does not cover in much  more...

Access 2003 Introduction for Developers ... task of designing and developing a database in Microsoft Access? Finding it difficult to know where to start? This three-day course assumes no prior knowledge of Access, and covers all the basics of Access, including how to design your database, creating tables, creating Access queries, and using Access forms, reports and macros. In fact the only thing this course does not cover is Visual  more...

Advanced Visual Basic for Applications If you already know how to program in Access, Excel or Word VBA, maybe it is time to learn about some of the more advanced features of the language. Ever wondered what a class module is? Curious about FileSystemObjects? Now is the time to find out what these things mean! For a full list of course topics, see our website  more...

Advanced Visual Basic 2005 If you have the basics of Visual Basic 2005, now is the time to do some serious development! Learn how to create your own classes, build a 3-tier application and much more. For a full list of course topics, see our website  more...

Visual Basic 2005 Windows Forms Been dabbling with VBA in Access, writing macros in Excel or building systems using Visual Basic 6? This is the ideal course for you! Learn how to create forms and code in Visual Basic 2005, using Visual Studio 2005 as the development environment. For a full list of course topics, see our website  more...