About this Course
Microsoft® Office Access 2007 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.
Course Length :
The Microsoft Business Certification Series can adapt to meet various course length requirements. There are two typesof exercises in this book: Learn the Skill and Practice the Skill (refer to the Conventions and Graphics section to identifythe different icons used for each type).For the shortest course lengths, students can perform just the Learn the Skill exercises.For longer course lengths, students can complete both the Learn the Skill and Practice the Skill exercises.Instructors should refer to the Instructor Resources for this book to learn more about how the material can be adapted.
Course Prerequisites
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent MicrosoftWindows knowledge and experience.Students who wish to become proficient using the features of Microsoft Office Access 2007 will benefit from taking thiscourse.
Course Objectives :
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 tool
Course Duration : 3days / 22hours
Entry Requirement : Basic Computer Knowledge
Course Rating
- /5 from users
Course Enquiry
Course Info
- Course Provider G-TEC COMPUTER EDUCATION CENTRE (PTE. LTD.)
- Course Category Technology
- Course Price $590
Comments