Access 2010 Expert
Welcome to the Access2010 Expert course. This course covers everything from customizing Access so that it works exactly how you need it to, to expert-level table, query, form, and report tasks. By the time you finish this course, you will be able to make the most out of Access 2010.
Course Objectives
Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. With that in mind, let’s review our goals for today.
At the end of this course, participants should be able to:
- Work with Database Properties
- Encrypt a database with a password
- Save an object
- Set general, current database, datasheet, object designers, proofing, and language options
- Customize the Ribbon and the Quick Access toolbar
- Hide/unhide and freeze/unfreeze fields in a table
- Modify field descriptions and properties
- Append records to an existing table
- Import data as a linked table
- Understand linked table errors
- Create a select query
- Create a make table query
- Create an append query
- Create a cross tab query
- Show or remove tables on the query designer window
- Create an update query
- Create a parameter query
- Compare two tables using a join
- Create a blank form
- Use form controls
- Create headers and footers on forms or reports
- Use Form Design, Report Design, and Macro Design tools
- Use background images
- Use themes
- Use conditional formatting
- Create a navigation form
- Create a blank report
- Use the Property Sheet
- Create a user-interface or a data macro
- Understand the Action catalog
- Understand the use of Visual Basic for Applications to extend Access functionality
Categories
Microsoft Access