Microsoft Office Access 2007

  

About this Course

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

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers