the new access 2010If 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.
course pre-requisitesThese 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
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.
- Are you an amateur artist or art collector?
This is for you!
- 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.