If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Informal testing of Access 97 Skills
Did you get the INTERMEDIATE and ADVANCED course descriptions the wrong way
around? The ADVANCED course descriptions you gave does not look like an ADVANCED course. If it is advanced, it just means they put the junk in there that hadn't fitted into the BEGINNER/INTERMEDIATE syllabus. It does not look like it has any perquisites. (david) "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#2
|
|||
|
|||
Informal testing of Access 97 Skills
Did you get the INTERMEDIATE and ADVANCED course descriptions the wrong way
around? The ADVANCED course descriptions you gave does not look like an ADVANCED course. If it is advanced, it just means they put the junk in there that hadn't fitted into the BEGINNER/INTERMEDIATE syllabus. It does not look like it has any perquisites. (david) "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#3
|
|||
|
|||
Informal testing of Access 97 Skills
David is right, there is nothing advanced about the so-called advanced
course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#4
|
|||
|
|||
Informal testing of Access 97 Skills
David is right, there is nothing advanced about the so-called advanced
course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#5
|
|||
|
|||
Informal testing of Access 97 Skills
Thanks Brendan and David. Well now I have a problem don't I? The employees who had requested the course and who had taken the intermmediate were satisfied with the course outline for the Advance. I wonder if it is because it's what they need for their jobs?
I think will talk to the college and the instructor and some expert users here where I work. We pay the college a lot to offer the courses. I don't know if I want a test run on this one. Thanks for your input. It does help a lot. Tierney Tierney "Brendan Reynolds" wrote: David is right, there is nothing advanced about the so-called advanced course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#6
|
|||
|
|||
Informal testing of Access 97 Skills
Thanks Brendan and David. Well now I have a problem don't I? The employees who had requested the course and who had taken the intermmediate were satisfied with the course outline for the Advance. I wonder if it is because it's what they need for their jobs?
I think will talk to the college and the instructor and some expert users here where I work. We pay the college a lot to offer the courses. I don't know if I want a test run on this one. Thanks for your input. It does help a lot. Tierney Tierney "Brendan Reynolds" wrote: David is right, there is nothing advanced about the so-called advanced course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#7
|
|||
|
|||
Informal testing of Access 97 Skills
Well, if the employees who have taken the 'intermediate' course are
satisfied, that's a good sign! Like I said, the course may be better than the outline. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Thanks Brendan and David. Well now I have a problem don't I? The employees who had requested the course and who had taken the intermmediate were satisfied with the course outline for the Advance. I wonder if it is because it's what they need for their jobs? I think will talk to the college and the instructor and some expert users here where I work. We pay the college a lot to offer the courses. I don't know if I want a test run on this one. Thanks for your input. It does help a lot. Tierney Tierney "Brendan Reynolds" wrote: David is right, there is nothing advanced about the so-called advanced course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
#8
|
|||
|
|||
Informal testing of Access 97 Skills
Well, if the employees who have taken the 'intermediate' course are
satisfied, that's a good sign! Like I said, the course may be better than the outline. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Thanks Brendan and David. Well now I have a problem don't I? The employees who had requested the course and who had taken the intermmediate were satisfied with the course outline for the Advance. I wonder if it is because it's what they need for their jobs? I think will talk to the college and the instructor and some expert users here where I work. We pay the college a lot to offer the courses. I don't know if I want a test run on this one. Thanks for your input. It does help a lot. Tierney Tierney "Brendan Reynolds" wrote: David is right, there is nothing advanced about the so-called advanced course, in fact the topics around database design and queries in the so-called intermediate course will probably be more challenging for many than anything in the so-called advanced course. I'd be somewhat suspicious of any course outline that listed 'Using Table Analyzer' as a topic, as there is really only one thing to be said about using table analyzer - don't, it's completely useless. On the other hand, as someone who used to teach IT courses myself, I know that the preparation of course outlines is often regarded as an unwelcome chore and done in a hurry. The course may turn out to be better than the outline. In your situation I'd let the employees decide which course they want to attend. I don't think there's anything to be gained from quizzing them that would justify the effort. Instead, I'd spend the time asking them what they thought of the course afterward, I suspect that might prove to be a more productive use of the time in the long run. BTW: This is not an Access 97 course. Data Access Pages and Pivot Tables/Charts were both new in Access 2000. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Tierney" wrote in message ... Hello, I need a way to test the skills of employees in Access 97. I am a corporate trainer and we offer MS course to all employees. The courses are taught by instructors from a local college. I have scheduled an Advanced Access couse. The prerequisite was Intermediate Access. However, I have employees telling me they are ready for the Advanced course. Well, employees often think they are more advanced than they actually are. I know there is "skill testing" available through various companies. However, I cannot get approval to buy the software. Can anyone suggest ways that I might informally test the employess knowledge? Some questions that I might ask perhaps. This is the outline for the INTERMEDIATE course: 1. RELATIONSHIPS ? How Relationships Work ? One-to-Many Relationship ? Many-to-Many Relationship ? One-to-One Relationship ? Defining Relationships ? Referential Integrity ? Cascade Update ? Cascade Delete 2. JOIN TYPES ? The Inner Join ? The Left Outer Join ? The Right Outer Join 3. QUERY TYPES ? Select Queries ? Calculated fields in Queries ? Sorting on more than one field ? Parameter Queries ? Crosstab Queries ? Action Queries ? Make-Table Queries ? Delete Queries ? Append Queries ? Update Queries 4. FORMS ? Combo Box (Functions in Forms and Table Lookup Fields) ? Domain Aggregates Functions ? Query by Form (QBF) ? Sub Forms ? Tab Stops ? Enhancing Forms with OLE fields, Hyperlinks, and SubForms ? Changing Label alignments ? Adding Form titles 5. REPORTS ? Report Sections ? Changing Properties ? Printing and Previewing Reports ? Moving and resizing controls ? Using Label and Textbox buttons to add Controls ? Add picture to Report Header area ? Changing size mode of a picture ? Inserting Date and Page Numbers to Reports ? Using Aggregate functions (Sum, Count, ) in Reports 6. Integrating Excel into Access ? Importing an Excel Worksheet to an Access Database ? Linking versus Embedding 7. Web Features ? Creating a Data Access Page ? Previewing the Data Access Page ? Limitations and Functionality In the Advanced course employees will learn the following: 1. OVERVIEW ? Report Design Considerations ? Creating and using Custom Forms ? Indexes ? Lookup and Input Mask Wizard ? Creating and using pivot table forms ? Creating a multi page form using tab control 2. MACROS ? The Macro Window ? Adding Actions and Saving a macro ? Running a macro ? Modifying a macro ? Macro arguments ? Macro group 3. EXPRESSION BUILDER ? IIF function ? Referencing open forms ? Expressions ? Customizing Reports ? Combining text fields ? Dlookup statement ? If . Then statement ? Referencing open forms ? Sum Function ? Text box Fields ? Yes/No fields 4. ADMINISTERING A DATABASE SYSTEM ? Compacting a Database ? Converting a database to an earlier version ? Using Table Analyzer ? Using the performance Analyzer ? Using the Documenter ? Discussing Startup Options ? Setting passwords ? Removing a password ? Encrypting a database ? Using Replication ? Creating a replica ? Synchronizing the Design Master and the Replica 5. USING ACCESS DATA IN OTHER APPLICATIONS ? Using the Export Command to Export data to Excel ? Using Drag and Drop to Export data to Word ? Using the Export Command to create a snap shot ? Mail Merge Both are 12 hour courses. Any and all suggestions would be appreciated. My knowledge of Access is basic so I cannot ask the appropriate questions. Thanks in advance, Tierney |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Recommendations needed for installation order of Access XP, Access XP runtime, ... | Mark Plantenberg | Setup, Installing & Configuration | 0 | June 11th, 2004 11:22 PM |
Looking for some direction on gaing Access Skills | Harold | General Discussion | 2 | June 11th, 2004 04:04 PM |
Data Access Page Problem | Doug Munich | General Discussion | 0 | June 5th, 2004 12:03 AM |