Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Access 2007 Training Courses From Activia
Access 2007 Training Courses From Activia
Search

ACCESS 2007 NEW FEATURES

A look at the major upgrade brought about with Access 2007

Background information and resources for access 2007 training courses that we hope you find useful

Along with the rest of the Microsoft Office suite, Access saw a fundamental change in the user interface, which tended to overshadow other improvements in the application.

GOODBYE TOOLBAR, HELLO RIBBON

There was a huge shift with Office 2007 in the way the menus operated. We have been so used to the old school menus of 20 years plus, it was time for an overhaul of how they operated, so although the older menus in Office 2003 were fairly intuitive they did make you click many times to get to your favourite commands in the menus.

The idea behind the 'Ribbon' system was to take away some of those mouse clicks for you. Less clicking more doing! So whereas in the older Access 2003 menu, it would take three clicks to get to the command to (say) back up the database, with the newer 2007 Tabbed based menu system, it takes just two.

A circular 'Office' Button replaced the File menu of the 2003 version.

ALT key Shortcuts are extremely useful because they allow the user to quickly run commands on the menus by pressing a new set of shortcuts. Microsoft's aim here was to have a shortcut for every command in Access (and the other applications too). By pressing the ALT key it helpfully reveals what you need to press next to run that particular command. So for example, to create a table it would be TN, a form FN or Report is RN. The beauty is, you don't need to remember them: just press ALT and away you go.

Goodbye Toolbar, Hello Ribbon

ATTACHMENTS

One of the great new features in Access 2007 was the ability to add attachments. The attachment Data Type is now available as an option during design of your tables. You can therefore store files within your database such as spreadsheets, pictures and Word documents.

EASY TO DESIGN FORMS AND REPORTS

Creating an attractive user form or printed report became so much easier in Access 2007. 2003 was known for not being very user friendly once you were in the form or report designer screen. 2007 is clear and intuitive: the new Layout View allows the user to clearly see the formatting and layout straight away prior to printing and you can adjust the position and size of fields and boxes easily.

Easy to Design Forms and Reports

SHAREPOINT INTEGRATION

With Access 2007 the system encompassed SharePoint integration. SharePoint is a Document Library Management service allowing users to view, edit and interact with files stored on a special server. Access can talk to the server and your databases can store records into the SharePoint environment.

SharePoint Lists available on the server can be used and this opens up a great way of sharing and storing data with other users. Here we see some of the options in the External Data tab of Access 2007:

SharePoint Integration

OUR VERDICT

Although the introduction of the ribbon was not welcomed by everyone, and condemned by some, Access 2007 helped people to save time by providing them with an interface that was easy to use -- which in turn meant they could focus their full attention on their work. Further enhancements made this a significant improvement on previous versions.

It was a worthwhile upgrade that paid the foundation for a new generation of Access software.

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Version history of MS Access

Version history of MS Access

Changes introduced in the different versions of Microsoft Access

      Click to read more

 

Access 2010 new features

Access 2010 new features

Access 2010: building on the new interface from 2007

      Click to read more

Access 2013 new features

Access 2013 new features

Access 2013: improvements in usability and collaboration

      Click to read more

 

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

NEW FEATURES IN ACCESS 2007

We can enhance your skills with Microsoft Access 2007 software training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our access 2007 courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft access 2007 training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training in Access 2007 to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Access 2007 Training Courses From Activia.

Why not contact us today to see how we can help with providing your courses for Microsoft Access 2007 ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top