Microsoft Office Access 2007

After completing this course, you will be able to:

• identify parts of the Access screen
• define fields, data types and tables
• create a database using templates, create a blank database, open, save and close databases
• create a table using Datasheet View or Design View
• insert, delete and modify data in a table
• add, modify and remove primary key fields
• insert, modify and delete a field
• add a total row to a table
• format, rename and delete tables
• save database items in a variety of file formats
• import or export data from or to other applications
• find and replace data using exact or partial matches, case sensitive and wildcard searches
• sort and filter data
• create, save, close, or run a query using the wizard or in Design View
• create query criteria using comparison, wildcard, AND, OR operators, or calculated fields
• change queries field properties and apply aliases
• create one-to-one, one-to-many and many-to-many relationships
• use the table analyzer
• perform maintenance on databases
• identify object dependencies
• open a database exclusively or with shared access
• use the Database Documenter
• create a form using the Form tool or the Form wizard
• create a form in design or layout view
• add, move, resize, delete, formatting, space, anchor or group controls
• creating datasheet forms, multiple item forms, split forms, and PivotTable forms
• create a report using the Report Tool and Report Wizard
• modify a report in design or layout view
• print and preview forms and reports
• create mailing labels
• use input masks, validation rules, or indexed fields
• use the lookup wizard or create lookup fields manually
• work with query joins
• create parameter, unique, unmatched and duplicate select queries
• create summary, action, and sub queries
• use embedded macros in forms or reports
• create and modify charts
• create a subform or subreport using the wizard or the subform/subreport too

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.

Register for the  2 Day Microsoft Access 2007. Simply fill the Course Registration form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at (65) 6296-2995.

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Call Kamini at (65) 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class. We have regular public classes each month, and Custom Corporate Trainingscan be arranged at your office  too.