课程详情

In today's workplace, data management skills are absolutely crucial, and Microsoft Access is the most widely available software for the job. Whether you need to use Access 2010 or 2013, our Ultimate Microsoft Access Training Bundle has got you covered. Starting with the absolute basics, these courses will take you to the level of total data mastery in both editions of the program, as you work through both beginners and advanced courses. If you need to manage data at all in your job, or are looking for a promotion to a role where you do, then you can't afford to give this a miss. This bundle includes: 35 hours of video tutorials Over 150 individual video lectures 4 quizzes with 170 test questions Certificate of completionPrintable course transcriptions to follow along and take notes Courses included with this bundle: Learn Microsoft Access 2013 Starting with the basics, our certified instructor will teach you to add and delete records to your database. Then, learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training. Includes exercise files. Learn Microsoft Access 2013 - Advanced Your professional trainer will show you how to use macros, tables, forms, queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend. With this informative course, you'll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job better. Includes exercise files. Learn Microsoft Access 2010 Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier. Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting-as your instructor gives you easy to understand methods for working with reports. Learn Microsoft Access 2010 - Advanced Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine-in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases. Where else can you find so many extra tools to help you master Access? What people are saying: "Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials." - TopTenReviews "Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!" - Lisa R., France. Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on. ** Updated June 2017. Course transcripts now available.

课程标签

0人关注该课程

主题相关的课程