MS Access 2010/2007 Layout View - Access Training

While MS Access has had a Design view for many years it is only in MS Access 2007 & MS Access 2010 we have the new Layout view. The MS Access layout view is really a great help as it allows you to change the layout without the complexity of the Design view - just resize the fields as needed.
MS Access 2010, Layout View Training Toronto, Mississauga, Ontario Canada

Bert Twomey
MS Office & Access 2010/2007/2003 Trainer
Toronto, Mississauga, Ontario, Canada

MS Access Training Conditional Formatting Toronto Mississauga

In MS Access 2010 it is possible to apply Conditional formatting to lists and forms so if you want values over a certain amount to stand out just apply a Conditional Format to them. to see more topics: MS Access Training Conditional Formatting Toronto Mississauga

Bert Twomey
MS Access Trainer

MS Access Training courses Toronto Ontario

One problem that many users encounter is the fact you can base a query on a query (and on more queries) in MS Access 2010 but also MS Access 2007/2003. So keep a good record otherwise if you change the base query you will effect the others.
see MS Access Training courses Toronto Ontario
for more training
Bert Twomey
MS Access Trainer
Toronto, Mississauga

MS Access 2007/2010 Training Toronto Mississauga Database Objects

One feature that is very useful in MS Access 2007/2010 is the ability to see which objects depend on which other objects (14 forms may depend on a query so better not delete it. select an object & use the tab Access Database Tools & click on Object Dependencies and a pane will open showing: objects that depend on the object or objects it depends on. Click on MS Access 2007/2010 Training Toronto Mississauga Database Objects to see more MS Access training

Bert Twomey
MS Access & MS Office Trainer

MS Access 2010 Training Toronto, Mississauga

In MS Access 2010 it is possible to save objects as PDFs or XPS which means you can safely send them to other people. Less space than a database and also more secure as only the visible information shows. Take a look at
MS Access 2010 Training Toronto, Mississauga for more MS Access training

Bert Twomey
MS Access & MS Office trainer

MS Access 2010 Training Toronto Ontario Create Tabs

One of the great new features in MS Access 2010 for training or real life purposes is the ability to create new tabs. As it is the Ribbon is great to show all the tools but suppose you only want to see some, well MS Access 2010 allows you to create a tab:
Just right click on the MS Access ribbon and choose Customize, this gives you the option to create a new tab and add only the commands you need
Take a look at MS Access 2010 Training Toronto Ontario
to see all training topics

Bert Twomey
MS Access 2010 & MS Office trainer