This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general.
Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course.
Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts.
The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on.
- At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
- Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
- After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
- Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
Level 3 Diploma in Microsoft Access 2010 is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.
As there is no experience and qualification required for this course, it is available for all students from any academic background.
Our Level 3 Diploma in Microsoft Access 2010 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
|Module 01: Beginner|
|Exploring the Access Environment||00:11:00|
|Databases and Tables|
|Planning and Designing Databases||00:12:00|
|Fields and Records|
|Changing the Design of a Table||00:15:00|
|Finding and Editing Records||00:06:00|
|Data Entry Rules|
|Setting Field Properties||00:14:00|
|Working with Input Masks||00:07:00|
|Setting Validation Rules||00:06:00|
|Creating and Using Queries||00:13:00|
|Modifying Query Results and Queries||00:05:00|
|Performing Operations in Queries||00:17:00|
|Using Design View||00:14:00|
|Sorting and Filtering Records||00:04:00|
|Working with Reports|
|Modifying and Printing Reports||00:16:00|
|Module 02: Intermediate|
|Creating Lookup Fields||00:11:00|
|Modifying Lookup Fields||00:06:00|
|Joining Tables in Queries||00:26:00|
|Using Calculated Fields||00:09:00|
|Summarizing and Grouping Values||00:08:00|
|Advanced Form Design|
|Adding Unbound Controls||00:08:00|
|Adding Calculated Values||00:06:00|
|Adding Combo Boxes||00:04:00|
|Advanced Form Types||00:10:00|
|Reports and Printing|
|Customized Headers and Footers||00:17:00|
|Charts in Forms||00:08:00|
|Charts in Reports||00:06:00|
|PivotTables and PivotCharts|
|Module 03: Advanced|
|Querying with SQL|
|SQL and Access 123||00:06:00|
|Writing SQL Statements||00:18:00|
|Attaching SQL Queries to Controls||00:06:00|
|Creating Crosstab Queries||00:05:00|
|Creating Parameter Queries||00:11:00|
|Using Action Queries||00:17:00|
|Creating, Running, and Modifying Macros||00:08:00|
|Attaching Macros to the Events of Database Objects||00:05:00|
|Creating Macros to Provide User Interaction||00:20:00|
|Creating Macros that Require User Input||00:04:00|
|Creating AutoKeys and AutoExec Macros||00:07:00|
|Creating Macros for Data Transfer||00:07:00|
|Importing, Exporting, and Linking|
|Working with XML Documents||00:13:00|
|Linking Access Objects||00:13:00|
|Using Hyperlink Fields||00:06:00|
|Setting Options and Properties||00:06:00|
|Mock Exam- Level 3 Diploma in Microsoft Access 2010||00:30:00|
|Final Exam- Level 3 Diploma in Microsoft Access 2010||00:30:00|
No Reviews found for this course.