Course overview
• Understand the concepts behind databases with Database Design Fundamentals
• Store your data by creating tables
• Create unique identifying fields to link tables using primary keys
• Share data between tables
• Create simple and complex forms
• Select data from drop-down lists by adding Combo Boxes
• Create forms within forms by using sub-forms and nesting forms
• Create a form to automatically look up data
• Add complex controls and buttons to your forms to automate actions
• Create dynamic lists of data by applying filters and select queries
• Use queries for rapid and accurate design changes
• Create multiple table queries and lookups
• Create a query from unrelated data with SQL and Union Queries
• Create professional printed documents
• Sort / group information, change report design, add / remove data and add graphics
• Create mail shot from MS Word data
• Import, export and link data from spreadsheets
• Activate macros with toolbar and Autokeys
• Create an AutoExec macro

Options
Microsoft Office 2000, XP, 2003 and 2007
and tailored Workshops