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
No Reviews found for this course.