
Examine table and field properties in Access 2010, including text and date/time data types, field size, caption, validation rules, indexing, input masks, date picker, and the lookup wizard.
Explore creating Access forms with the form, blank form, datasheet form, multiple items form, split form, and wizard subforms, then design, save, and link them to tables for data entry.
Master sorting, filtering, and find and replace in Access 2010 forms using the Northwind database; learn form view capabilities, property sheets, and multi-criteria filters.
Create and refine Access reports using the wizard, design and layout views, and print preview to ensure correct paging, with emphasis on tables, fields, sorting, and page numbers.
Create a student tasks report with the report wizard, selecting student and task fields, sorting by due date and priority, and refining the layout in design view.
Enhance access reports by adding existing fields, aligning and formatting borders, and using group and sort to organize data; explore print, export, email options, and adding totals for summaries.
Learn Microsoft Access 2010 by Simon Sez IT is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Your professional trainer will introduce you to Microsoft’s “Ribbon” interface, showing you tips and techniques to leverage its features for more efficient database management.
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.
Before the “Microsoft Access Training: Microsoft Access Tutorial” course is over, we’ll cover all key areas of the program: custom queries using defined criteria, select queries, updating queries, appending queries, deleting queries, inner joins, outer joins, table queries, and mail merges.
Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 40 online course videos:
Where else can you find so many extra tools to help you master Access 2010?!?!
So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise!
All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.
What our customers are saying:
"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.
So take this Microsoft Access training and learn from Microsoft Access tutorial.