Mobile MOUSe online

     
 
Excel Training | Word Training | Access Training | Outlook Training | PowerPoint Training | Visio Training | Project Training | Publisher
 
 

Access Training Assessment



THIS IS NOT A TEST. Please note that this is for your own benefit, used to determine your approximate skill set with Access. Please read the questions very carefully and by answering the questions honestly, these questions will help you determine whether this Access course is the right one for you. Please answer all questions.
Your Name (REQUIRED):
Company:
Contact Number:
Your Email Address (REQUIRED):
QUESTION
ANSWER
Q1. Have you used a Database before?
Q2. Have you created a Database before?
Q3. Are you going to be creating a new or modifying an existing Database?
Q4. Do you know how to create fields for a Database?
Q5. Are you able to define the term... Database Record?
Q6. Do you know how to Delete, Insert and Rearrange fields within a database?
Q7. Do you know how to move between Records?
Q8. Do you know how to Enter and Edit Records?
Q9. Have you used Filter by Form and Filter by Selection to view specific records?
Q10. Do you know how to Print specific records in a Database?
Q11. Do you know what the Caption, Default Value, Length and Validation rule properties are used for?
Q12. Do you know how to create drop down lists within a table?
Q13. Do you know how to create input masks?
Q14. Do you know what all of the following data types are used for? Autonumber, Memo and Lookup Wizard?
Q15. Do know what a Query is and how to create one?
Q16. Do you know how to Sort your records within a Query?
Q17. In a Query, do you know the difference between Like, Between, Or, And, Is Null and Is Not Null?
Q18. Do you know how to create prompt boxes in a Query?
Q19. Do you know how to create calculations within Queries?
Q20. Do you know what Cross-tab Queries are used for?
Q21. Do you know how to create and modify a Form?
Q22. Do you know how to create buttons and combo boxes on forms?
Q23. Do you know how to design and generate Reports?
Q24. Do you know ho to Import data into your Database?
Q25. Do you know what a Relational Database is?
Q26. Do you know what a primary key is?
Q27. Do you know what a foreign key is?
Q28. Do you understand the purpose of creating a linking table?
Q29. Do you know the difference between a One to One, One to Many and a Many to Many relationship?
Q30. Do you know how to link two tables of data together as One to Many relationship?

If you have any questions, queries or comments, please do not hesitate to contact us.

home

 
   
 
 
 

Microsoft Word Training Perth
Excel Training Perth
Access Training Perth
PowerPoint Training Perth
Outlook Training Perth
Project Training Perth
Visio Training Perth
Publisher Training Perth

 
 
 

Onsite training at our clients premises. We come to you !! Our venue is also available.

At your premises, we provide laptops for the course. No strain on your IT resources.

All courses come with a quality manual and downloadable practice files.

Cost-effective price structure. The more students you enrol, the cheaper the course.

Structured (but flexible) nationally accredited curriculum.

Courses are also designed around Microsoft Office User Specialist certification.

Small personalised groups and one-on-one training.

6 months of free post-course support.

We can also design and provide custom, tailor made courses.

Certified, qualified and experienced trainers.

Training some of the biggest companies in Western Australia.