Microsoft Office Training: Access 2007 & 2010

Fast and easy to both learn and use, Microsoft Office Access 2007& 2010 helps you track and report information with ease. Access is a simple, logical databse system for people who are new to databases. Get started quickly with prebuilt templates that you can alter to match your business requirements. Collect information through forms in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making.

Product Duration: 12 Months Unlimited Access Price  Add to Cart   Microsoft Access 2007 Training: This course is for anyone who wants to learn more about Access 2007. Microsoft Access 2007 Advanced Training This series is for anyone who wants to move beyond the basic concepts of Microsoft Access. Microsoft Access 2010 Upgrade Training This series is for anyone who uses Access 2003 or newer and wants to understand Access 2010. £99.99 £99.99 £99.99

Microsoft Access 2003 to 2010 Upgrade Course Lessons:

Access 2003 to 2010 Upgrade: Navigating the Updated Office Interface This course provides information about the new user interface designed for the Microsoft Office 2007 applications. List and describe the features of the new Office 2007 user interface Change application settings in Office 2007 products Use the Live Preview feature 2.0 hour(s) Access 2003 to 2010 Upgrade: Common Features in Office 2010 This course explores the new features that the major Office 2010 applications have in common. Modify and minimize the Ribbon Use Backstage view Capture windows and clippings Add artistic and color effects to images Save documents to the Web Work with Office Web Apps 3.0 hour(s) Access 2003 to 2010 Upgrade: What's New in Access 2007 This course provides an overview of the new features in Microsoft Office Access 2007. Navigate Access using the Ribbon, the Office Menu, and the Navigation Pane Create a database Create new forms Filter the data in a table Generate reports from a table Migrate database objects to SQL Server and Windows SharePoint Services 2.0 hour(s) Access 2003 to 2010 Upgrade: What's New in Access 2010 This course explores the new features in Microsoft Access 2010. Describe the new Ribbon features Visualize trends with data bars Create application parts and data type parts Use calculated fields Build data macros Insert Web content and create Web databases 3.0 hour(s)

Microsoft Access Course Lessons:

Microsoft Access Advanced Course Lessons:

This online training will teach you how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data. Subject Headings: Access 2007: Introduction to Access Use the Ribbon to access command buttons and groups. Use the Office menu to access commands dealing with the Whole application or database Use the Navigation Pane to view and open database objects. Start a new database by using templates provided by Microsoft Office Online 1.0 hour(s) Access 2007: Creating Tables Recognise data types and basic database terminology Add and delete fields from a table Set the primary key for a table Identify flat files and relational databases Create simple tables Add, modify, and delete records from a table 2.0 hour(s) Access 2007: Working with Tables This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships. 2.0 hour(s) Access 2007: Creating Forms This course provides information on creating forms in Access 2007, including simple forms, more complex multiple items forms, and split forms. It also shows how to create customized forms using the Form Wizard. 2.0 hour(s) Access 2007: Creating Reports Create a basic report Create a report using the Report Wizard Create a customised report 1.0 hour(s) Access 2007: Creating Queries and Filters This course provides information on how to use queries and filters to search and sort your database tables. It shows how to filter using the Sort and Filter feature and how to build queries using the Query Wizard. 1.0 hour(s)

Access 2007 offers many more powerful features than a beginning user first touches. This Advanced Microsoft Access training will explore some of the more powerful abilities of Access, including pivot tables and charts, graphs, forms, security, multitable and crosstab queries, macros, and more. SubJect Headings: Access 2007 Advanced: Expressions and Queries This course focuses on the use of VBA functions when creating queries, and examples of queries that use the four basic types of joins you can create in Microsoft Access 2007 Expressions, operators, literals, constants Working with functions Types of functions Creating expressions Using inner joins for multitable queries Using outer, self, and theta joins Creating crosstab queries 3.0 hour(s) Access 2007 Advanced: PivotTables, PivotCharts, and Graphs This course provides an introduction to working with PivotTables and PivotCharts. Describe the main features of PivotTables and PivotCharts Create a query for a PivotTable Create, optimise, and export PivotTables Create and modify PivotCharts Create and modify Graphs 3.0 hour(s) Access2007 Advanced: Macros and Data Imports/Exports This course focuses on the use of macros and the ability to import and export data between Microsoft Access 2007 and other programs. View macro events and actions Create embedded macros Import and link data from Excel Import text data Export Access data Import and export XML data 3.0 hour(s)

If you just have a question about our Microsoft Access Training or any other careers or training course just telephone us on 01279 814 876 (Hotline Available NOW 24 hours a day, 7 days a week!) or fill in the simple form below and an advisor will contact you shortly.

What do I get?

Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.

Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn

Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide

Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 9.30am-4.30pm to help you out if you get stuck

Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.

Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.