Microsoft Access is the perfect program to organize large amounts of data from household inventory to customer data bases. Learn how to work with Tables, change Field Properties, create Input Masks, and Default Values. Create Forms to speed up data entry, Queries using multiple criteria and wildcards to expedite searches, & create professional looking Reports using Wizards.
Did you know that you can use data from other files (including Excel) by Importing or linking it into Access? And further enhance the functionality of your database by creating Relationships between multiple tables. Participants will create new calculation fields in both Queries and Forms. Forms will be modified in the Design View by adding unbound controls, combo/list boxes, or toggle buttons and Option groups. Reports will be produced using Grouping Levels, new controls for Calculations and Headers & Footers. Printing and Pagination will be covered as well.
Microsoft Access - Level III (Dates and Times)
After mastering the basics of the Access program participants will create Advanced Queries including: Make-Table, Update, Append, Delete, Crosstab; using Inner, Outer or Self joins. A brief introduction to using SQL to change queries; practice creating Multi-table Forms and Creating Hyperlinks to other files will also be covered. This course will also give you an introduction to programming by using the Immediate IF Function to perform a calculation. Macros and Switchboards will be created to make your database more user-friendly.
Microsoft Access - Level IV (Dates and Times)
Learn how to use Access to create a Directory of a Catalogue by utilizing Memo and OLE fields. Modify existing fields to display data in a format that works for your reports. Then learn how to create a report from 2 data sources, set up proper page formats including margins, orientation, headers/footers, and use the grouping function to keep data from splitting over pages/columns.
HR Manager Level I (Dates and Times)
Supervise employee progress by tracking skills, qualifications, training and development. Monitor absences such as vacations and leave, and track patterns for employee sickness, absences, as well as attrition. Maintain records of disciplinary issues along with evidence in case of disputes. Make sure sensitive information stays secure with role-based security options so only staff with the right level of access can retrieve sensitive information.
HR Manager Level II (Dates and Times)
Increase the usefulness of HR Manager by tying employee records to external documents. Speed up entries by making batch entries and global changes. Create your own screen views to have the most frequently used features all in one place. Export data to reduce errors when rekeying information. Link to Excel and Outlook and create mail merge documents.