• LOGIN
  • No products in the cart.

This [course_title] builds on the skills and concepts taught in Access 2010: Intermediate. You will learn about querying with SQL, Advanced Queries, Macros, Advanced Macros, Importing, Exporting, And Linking, Database Management, Access, OneNote, PowerPoint, Windows, Excel, Outlook, Publisher, Word, and much more. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data. This course will empower you with the knowledge and skills necessary to be a proficient user. If you already have a good grounding in Microsoft Word, this course will provide you with the knowledge and skills to use Microsoft Access 2010 at an expert level.

Assessment

This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.

Certification

Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

 

Course Credit: Edukite

Course Curriculum

Querying with SQL
SQL and Access 123 00:06:00
Writing SQL Statements 00:18:00
Attaching SQL Queries to Controls 00:06:00
Advanced Queries
Creating Crosstab Queries 00:05:00
Creating Parameter Queries 00:11:00
Using Action Queries 00:17:00
Macros
Creating, Running, and Modifying Macros 00:08:00
Attaching Macros to the Events of Database Objects 00:05:00
Advanced Macros
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
Importing Objects 00:14:00
Exporting Objects 00:06:00
Working with XML Documents 00:13:00
Linking Access Objects 00:13:00
Using Hyperlink Fields 00:06:00
Database Management
Optimizing Resources 00:16:00
Protecting Databases 00:05:00
Setting Options and Properties 00:06:00
Assessment
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews

4.9

4.9
10 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

530 STUDENTS ENROLLED
©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841