Access 2010 Advanced
Welcome to the Access 2010 Advanced course. You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL and publish a Web database—among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.
By the time this course is finished, students should have learned how to:
- Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
- Add, move, remove and format both regular and calculated controls
- Set the Primary Key
- Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
- Group and sort data
- Understand, view and edit relationships
- Understand and establish referential integrity
- Sort and filter a query
- Add calculated fields
- Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
- Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
- Use the Database Documenter, analyze table and database performance and repair and compact a database
Categories
Microsoft Access