ECDL Syllabus 5.0 Module 5 Using Databases Using Access 2007

Understanding Database Principles Using the Ribbon and Quick Access Toolbar Help Opening a Database Closing Tables and Databases Moving Around a Table Planning and Creating a Database and Table Defining Filed Properties, Primary Keys and Indexes Creating Validation Rules Previewing and Printing from Tables, Forms and Reports Editing Data Adding and Deleting Records Sorting and Filtering Records Applying Relationships Creating, Editing and Deleting Queries Saving and Printing Queries Creating Forms Sorting and Editing Form Data Creating Reports Calculated Fields in Reports Database Administration