Access Training Requirements
1. Introduction to database jargon: What is a table, record, and field? 2. Open an existing Database 3. Entering and Editing Data 4. Moving between records 5. Adjusting Columns 6. Copy & Paste Fields 7. Adding Records 8. Selecting and Deleting Records 9. Copying Records 10. Sorting Records 11. Finding Records 12. Page Orientation 13. Print Preview 14. Printing a Table Invalid Input
15. What is a Table, Query, Form and Report? 16. Create your own Table (wizard) 17. Design your own Table (manual) 18. Create your own Query (wizards) 19. Changing the design of a Query 20. Printing a Query 21. Create your own Form (wizards) 22. Changing the design of a Form 23. Create Mailing Labels (Report Wizard) 24. Changing the layout of a Report 25. Print preview of Reports 26. Printing Reports Invalid Input
27. More advanced criteria expressions for Queries 28. Parameter Queries 29. SQL Queries in Forms 30. Changing the Format of how fields are displayed in Forms 31. Limiting how data is entered into a form to prevent mistakes 32. Formulae to display more than one field in a field in Forms/Reports 33. Creating Table Relationships 34. Forms and Sub-Forms 35. Reports and Sub-Reports 36. Create a Combo Box and List Box on a Form 37. Using the Function Wizard to create Formulae 38. Check boxes and Option Buttons Invalid Input
39. Creating a Switchboard to navigate around the database 40. Creating Command Buttons to carry out common actions 41. Option Groups 42. Adding Graphics into records 43. Adding Macros to events on a Form 44. Action Queries to Delete Records or Find Duplicates 45. Sorting and Grouping Records in a Report 46. Importing Data from Text or Excel Files 47. Exporting Data to Excel and Word Files 48. Creating a Mail Merge from Access in Word 49. Calculations in Queries, Forms and Reports 50. An introduction to networking Access Invalid Input
Please indicate when you might like the training
Please provide PostCode
Please tell us you First Name
Please tell us your Last Name
Invalid Input
Please tell us your Phone Number
Please check your email address