the new access 2010

MS Access learning apps If you're coming to this application from Access 2007 or from any other Office 2007 or 2010 application, you'll be happy to learn that Access 2010 is not different at all.

But if you've used an older version of the software, Access 2003 or before, you will need to familiarize yourself with the new interface.

Like the other members of Microsoft Office, Access 2010 makes full use of the easy-to-use Ribbon interface that Microsoft introduced in Office 2007.

The Ribbon is a region at the top of the screen that presents an easy-to-browse main set of commands for a particular program. It replaces the menus and toolbars that you were used to in Access 2003.





The main difference between the 2007 Ribbon and the 2010 version is that the Office button has been replaced by the File tab.

access gui

course pre-requisites

These tutorials won't go into the theory of relational database design or the use of the Access interface. We've covered that in previous courses.

If you need some background material before starting this project, take a look at some of the other courses offered through the Profsr.com website.

Database design was covered in these courses:
Access 2003 tutorials
Database design and SQL

And the Access interface was covered in:
Microsoft Access 2007 tutorials


Top




content of tutorials

  • Describing the project
    These tutorials will use a sample project called "Profsr Financial Services". We must first describe the project parameters.

  • Building the database
    The first step after the design is to create the tables and the relationships.

  • When things go wrong
    How to repair a corrupted database.

  • Writing queries
    You extract information from the database with a query.
    And we introduce a new application: Mike's Garage.

  • More on queries
    The use of special functions to refine the query. Specifically, the use of Date functions.

  • Action queries
    Action queries are used to add, delete or update data in tables. We create an Update query to change dates in the Financial database.

  • More complex queries
    Selection queries with Inner Joins are used to extract data from multiple tables. With a Left Join query we can extract information from transactions we don't have.

  • Using functions in queries
    Selection queries with calculations. Creating an Age() function. Using the IIF() function for summaries.

  • Creating forms for data entry
    Forms are used to capture data and to edit data. Create a simple form from one table or a more complex one using a query.

  • Building a transaction form
    The transaction form is used to capture commercial activity. In the Garage app it's the invoice that will be used to bill the customer for all the work done.

  • More on transaction forms
    In the Financial app the transaction form is used to capture sales data in order to calculate sales reps' commissions.

  • Creating the report object
    Building a simple report for printing.

  • Creating a detailed report
    How to build a sales report with sub-total and totals.

  • Creating a specialized report
    Printing an invoice from the invoice form, with record selection using the expression builder and command button execution.



  • Download sample databases
    Samples to use in the lessons. Link to the Microsoft Northwind database.

  • Useful references
    Links to forums and vendors with all kinds of useful hints for Access 2010 development of your databases.



Learn MS Access easily! These free tutorials are for you!