Microsoft Access 2007 Foundation

Getting started
-Launching the Access application
-Working with the Access toolbars
-Customising the Access environment
-Understanding Access terminology
-Examining Access objects
-Displaying Access help
-Exiting from Access
Designing a relational database
-Differences between a flat file and a relational database
-Define the database goal
-Determine the tables and fields
-Normalise the data
-Identify the primary keys
-Determine the table relationships
Creating a new database
-Create a new blank database
-Create a table in design view
-Setting a primary key for a table
-Using input masks and validating fields
-Specifying a required field; defining a default field value
-Saving a table
Working in datasheet view
-Entering records in datasheet view
-Navigating through records in datasheet view
-Formatting the table
-Using table filters
-Hiding columns
-Printing
-Closing a table
Working with multiple tables
-Displaying multiple tables on the Access desktop
-Resizing and repositioning the table window Relating tables
-Creating a relationship between two tables in a database
-Displaying and using a sub datasheet
Working with Access query
-Creating a query in design view
-Selecting query fields
-Using the query criteria
-Including a numeric condition and a calculated field in a query
Creating a report
-Creating a simple and grouped tabular report, modifying a report
-Formatting a report
-Creating a mailing label report
Creating a form
-Creating a form using form wizard
-Navigating through records in form view
-Switching between form views
-Entering records in form view
-Editing records in datasheet view and in form view
-Deleting records in datasheet view and in form view
Additional Access features
-Using the spelling checker
-Copying, renaming and deleting database objects
-Importing an Excel spreadsheet data into an Access table
Working with a custom form
-Designing a custom form
-Adding a header or footer to a form
-Adding a calculated control to a form
Review of Programme
Other Recommended Programmes
-Microsoft Access 2007 Level 2
-Microsoft Access Queries and Reports