Product Name: ACCESS 2007 INTRODUCTION
Version: Access 2007  
Training Type: Instructor Led  
Components: Participant Manual  
Duration: 1 day  
Details    
Introduction
Getting started
· what is Access? starting Access, the Access application window
· using the access menu system, using the Microsoft Office button
· using the quick access toolbar, basic Access terminology
· examining Access objects
· resetting the database folder, displaying help information
· exiting from Access
Setting up a new database
· designing a new database, creating a new database
· creating a new table, entering records in datasheet view
· printing the datasheet of a table
· navigating through records in datasheet view
· closing a table/closing a database file
Creating a form/modifying and manipulating data
· reopening a database file/reopening a table
· creating a form
· navigating through records in form window/closing a form
· reopening a form
· switching between form view and datasheet view
· entering records
· editing records in datasheet view and form view/using the
find feature
· deleting records in datasheet view and in form view
· modifying the datasheet view of a table
· sorting the records in a table
Displaying selected data
· filtering the records in a table
· creating a simple query
· creating a query in design view
· modifying a query
· including a numeric condition in a query
· including a calculated field in a query
Creating a report
· creating a simple tabular report
· creating a grouped tabular report, modifying a report
Additional Access features
· copying, renaming and deleting database objects
· compacting and repairing a database, backing up a database
· importing spreadsheet data into an Access table
· importing text into an Access table
Final case study
 
Contact SVI | Order Information | Home

Any company name, product name, brand name or logo mentioned or illustrated on this website may be a registered trademark or trademark of its respective owner