Home   >  ZandaX Blogs   >  Business Blog   >  Microsoft Software Articles   > 
Access 2007 New Features

Access 2007 New Features

 
Improving your Microsoft software skills
What's new in Access 2007? Click to read the ZandaX Training quick guide to the new features in Microsoft Access 2007.
 
Article author: Jordan James
      Written by Jordan James
       (2-minute read)
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.

The Ribbon in Access 2007

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 in Access 2007

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.

More Articles on Microsoft Software

Version History of Microsoft Word
Version History of Microsoft Word
Jordan James
Author: Jordan James
About the article
Summary
Read about the different versions of Microsoft Word, from Activia Training, providers of flexible, cost effective Word training courses.
[ close ]
10 Ways Excel Pivot Tables can help you.
10 Ways Excel Pivot Tables can help you.
Jordan James
Author: Jordan James
About the article
Summary
Pivot Tables are extremely useful in analysing data and seeing how its linked. This looks at 10 ways to use Pivot Tables properly.
[ close ]
How to Highlight Data in Different Colors in Microsoft Word
How to Highlight Data in Different Colors in Microsoft Word
Jordan James
Author: Jordan James
About the article
Summary
Learn how to highlight data in different colors in Word with this guide on the ZandaX website.
[ close ]
How to Add Special Characters in Word with Keyboard
How to Add Special Characters in Word with Keyboard
Jordan James
Author: Jordan James
About the article
Summary
Find out how to add special characters, such as the trademark and copyright symbols in Microsoft Word, using the keyboard.
[ close ]
Enhancing Legal Operations: The Power of Microsoft Integration
Enhancing Legal Operations: The Power of Microsoft Integration
Jordan James
Author: Jordan James
About the article
Summary
With greater efficiency needed by corporate legal operations, this article looks into the advantages and applications of Microsoft integration.
[ close ]
Simplify Microsoft Excel with the Right Training Course
Simplify Microsoft Excel with the Right Training Course
Jordan James
Author: Jordan James
About the article
Summary
You can play around with Microsoft Excel for hours, and still get nowhere! Here, we give you tips on how to find a training course to help
[ close ]
Our Course Of The Month  Microsoft Project
Our Course Of The Month Microsoft Project
Jordan James
Author: Jordan James
About the article
Summary
The course of the month this month is Microsoft Project. As a project manager, are you using the tools that are available to you?
[ close ]
What Is Microsoft Visio Used For?
What Is Microsoft Visio Used For?
Jordan James
Author: Jordan James
About the article
Summary
Microsoft Visio can be used for a lot more than people realise. Popular uses include creating organisation charts, floor plans and timelines
[ close ]
7 Reasons Why You Should Learn How to Use Excel
7 Reasons Why You Should Learn How to Use Excel
Jordan James
Author: Jordan James
About the article
Summary
The Article shows how to boost productivity with Excel, Improve Quality of Work, Versatility, You will become a God in the Office!
[ close ]
What are Macros used for in Excel?
What are Macros used for in Excel?
Jordan James
Author: Jordan James
About the article
Summary
Macros in Excel are incredibly powerful tools that can provide the user with large benefits. This article looks at what macros are for.
[ close ]
How to Use Format Painter in Excel for Multiple Cells
How to Use Format Painter in Excel for Multiple Cells
Jordan James
Author: Jordan James
About the article
Summary
Learn how to copy formats from one cell to another using the Format Painter tool in Excel, with this tutorial from Activia Training.
[ close ]
How To Use Animation Triggers In PowerPoint
How To Use Animation Triggers In PowerPoint
Jordan James
Author: Jordan James
About the article
Summary
Learn how to use animation triggers in Microsoft PowerPoint from this tutorial from Activia Training.
[ close ]
 

Write for us on the ZandaX blog

We're always looking for guest contributors to increase the variety and diversity of what we present.
Click to see how you can write for us:
 

The ZandaX Business Skills blog categories

Click a panel to visit the main category pages for the blog
Career Success
Career Success
Marketing
Marketing
Presentation Skills & Public Speaking
Presentation Skills & Public Speaking
Customer Service
Customer Service
Microsoft Software
Microsoft Software
[ This category ]

ZandaX Blog Contents

Want to see them all? Click to view a full list of articles in our blogs.

zandax online courses logo
"ZandaX courses are such great value, and with the help and support they give, there's no better option in the market"
ZandaX LinkedIn logo
ZandaX YouTube logo
ZandaX FaceBook logo
 
All content © ZandaX 2024