All of this setup takes effort and a good understanding of how databases work. And even after you’ve defined that structure, you’ll probably want to spend more time creating other useful tools, like handy search routines and friendly forms that you can use to simplify data lookup and data entry. Before you can enter a stitch of information into an Access database, you need to create that database’s structure.

Or you can start Excel, and launch right into a financial report. For example, you can fire up Word, and start typing a letter straight away.

Quite simply, databases need strict rules. They’re probably right.Īccess seems more daunting than any other Office program because of the way that databases work. Even though Microsoft has spent millions of dollars making Access easier to use, most people still see it as the most complicated Office program on the block. Working files are included, allowing you to follow along with the author throughout the lessons.Although Microsoft won’t admit it, Access can be intimidating-intimidating enough to trigger a cold sweat in the most confident office worker. Finally, he will take you through the process of creating your own custom web app with Access 2013.īy the completion of this training course, you will be capable of creating databases as well as reports and forms in Microsoft Access 2013, and you will have in-depth knowledge of the tools and functions available to you in this software. As you move through the video tutorial, the course covers other topics such as how to create advanced forms, customizing your reports, and building action queries. Starting with a tour of the interface, this computer based training video will show you how to design and create a table, build queries, and comprehensively demonstrates the creation, and functions, of forms and reports. This course is designed for the absolute beginner no prior database design or Microsoft Access experience is necessary in order to get the most out of this video tutorial. This Microsoft Access 2013 training course from Infinite Skills teaches you how to use Access to create a database and build an interface to retrieve and report on your data. Master Microsoft Access 2013 quickly with this practical hands-on 10 hour course - A comprehensive resource for users of all levels

Microsoft access 2013 tutorial pdf