Access 2003 Advanced - Free Quizzes
We have loads of free quizzes in all the main Microsoft Office packages. Test your skills, or use them to help you revise for qualifications like ECDL, ITQ and MOS.
Feel free to pass the links on; anyone can have a go!
If you like these quizzes, there are plenty more where they came from! You can see the full list of subjects here.
You can browse this site for information about Online courses, or can learn more about our Classroom courses at Happy Computers.
Creating and editing tables
Relational databases: one to many
- Creating a one to many relationship
- Creating main and subforms for a one to many relationship
- Editing relationships
Relational databases: one to one
Relational databases: many to many
- Creating a many to many relationship
- Creating main and subforms for a many to many relationship
- Editing a subform
Advanced queries
- Using not and null in a query
- Creating calculations in a query
- Using functions in a query
- Creating queries on more than one table
- Crosstab queries
- Showing unmatched values between tables
- Showing highest and lowest value in a query
Action queries
Advanced forms
- Adding a bound object frame
- Using unbound controls to format your form
- Command buttons
- Unbound object frames
- Tab controls
- Controls which give the user a choice
- Creating calculations on a form
- Setting the tab order
- Form headers and footers
Advanced reports
- Creating summaries on a report
- Creating calculations on a report
- Using functions on a report
- Headers and footers on a report
Macros
Importing and exporting data
© Happy 2010 - Happy, Cityside House, 40 Adler Street, London E1 1EE 0207 375 7300
How we provide customised e-learning...
Effective e-learning in place within a matter of weeks...
Encouraging independent learning...
Try our materials for free...