MS Office Access
Learn Microsoft Office Access to qualify for a better job! Microsoft Access 2007 is a powerful application that gives you the tools you need to create clear, meaningful, effective reports. This in-depth course offers practical tips and tricks to use Access effectively. Learn step by step how to use the features of this powerful database program. Well designed lessons break big topics into easy to learn chunks of information. Learn how to: - Navigate the new Access interface with Tabs, Ribbons and Groups
- Use a template to create a new database
- Start with a blank database to create a new one
- Understand data types such as Text, Memo, Date, etc.
- Enter and edit data
- OLE Objects
- Work with tables and fields
- Field properties, Input Masks, Smart Tags
- Sort, filter, create relationships
- Form View and Datasheet View
- Create simple and summary queries
- Validation Rules
- Create reports, Report Wizard
- Grouping in reports, Summary Wizard, Quick Reports
- New report design tools, Tab/Ribbon in Access 2007
- Link to Excel worksheets… and much more
Register for this course atSt. Patrick's Adult School 290 Nepean Street Ottawa, ON K1R 5G3 Phone: 613-594-5773Click here to learn more about St. Patrick's.
Go from the MS Office Access page to the Home page.
|