Microsoft Office Training: Access 2007

Fast and easy to both learn and use, Microsoft Office Access 2007 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. £99.99   £99.99

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 0871 222 8790 or fill in the simple form below and an advisor will contact you shortly.

If you would like some advice on training or the special deals available then complete your details below. Name Email Work Tel Home Tel Mobile Query -select course- Networking Programming CompTIA CISCO Microsoft Hardware ECDL Office Skills Web Design ICDL Dreamweaver Photoshop Word Excel Comments

Telephone: 0871 222 8790 Alternate Number: 01279 814 876 Fax: 01279 816 093 E-Mail: info@e-careers.co.uk Address: 10 Riverside Business Park, Stony Common Road, Stansted Mountfitchet, Essex, CM24 8PL

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 8am-8pm 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%.