Practical Access 2007 Syllabus - Module 1, Using Access Databases

1.	About this course	Welcome Introduction and objectives Getting help with the course How the course is structured About the model database About the exercises Summary	2.	Introducing Microsoft Access	Objectives Overview Understanding databases Starting Access Opening a database Understanding the Access window Introducing the parts of a database Using the Navigation Pane Using the Ribbon Using the Microsoft Office Button Using the Quick Access Toolbar Closing an Access database Getting help on Access Exiting Microsoft Access Exercise Review questions Summary
3.	Using Tables	Objectives Overview Introducing Access tables Opening a table Viewing tables Navigating around tables Navigating with the keyboard Adding new records Editing records Deleting records Copying and pasting data Using the Zoom box Checking your spelling Printing tables Finding and replacing information Sorting records Filtering records Filtering by Form Exercise Review questions Summary	4.	Formatting Tables	Objectives Overview Resizing columns and rows Moving columns Hiding and showing columns Freezing and unfreezing columns Changing the font Changing cell effects Exercise Review questions Summary
5.	Using Queries	Objectives Overview Introducing Access queries Running a query Viewing queries Formatting queries Printing query results Exercise Review questions Summary	6.	Using Forms	Objectives Overview Introducing Access forms Opening a form Viewing forms Navigating records Adding new records Modifying records Deleting records Printing records Exercise Review questions Summary
7.	Using reports	Objectives Overview Introducing Access Reports Opening a report Viewing reports Printing reports Exercise Review questions Summary	8.	Module Summary	Congratulations Your quiz score Good luck

Practical Access 2007 Syllabus - Module 2, Creating Access Databases

1.	Creating Databases	Objectives Overview Planning a database Designing a database Creating a database using templates Creating a blank database Exercise Review questions Summary	2.	Creating Tables	Objectives Overview Creating tables from templates Creating a table in Datasheet View Creating a table in Design View Saving and naming the table Understanding data types Changing a field's Data Type Indexing fields in a table Adding a primary key to a table Changing the table design Exercise Review questions Summary
3.	Working with Fields	Objectives Overview Understanding field properties Setting field descriptions Adding field captions Changing field sizes Formatting text and memo fields Formatting number and currency fields Formatting date and time fields Formatting Yes/No fields Setting a default value Making a field required Automating data validation Setting an input mask Allowing zero length data entry Handling data integrity violations Exercise Review questions Summary	4.	Creating Lookup Fields	Objectives Overview Introducing Lookup Fields Creating a value list Creating a lookup list Modifying lookup fields Using key-less tables Exercise Review questions Summary
5.	Creating Queries	Objectives Overview Using the Simple Query Wizard Creating a simple query Running a query Saving and closing a query Modifying a query Adding criteria to a query Using numbers, dates and wildcards Adding multiple criteria Sorting queries Hiding and showing fields Exercise Review questions Summary	6.	Creating Forms	Objectives Overview Creating forms with the Form tool Creating forms with the Split Form tool Creating forms with the Multiple Items tool Creating forms by using the Form Wizard Creating forms with the Blank Form tool Creating Blank Forms in Design View Understanding Layout View and Design View Resizing forms Understanding controls Understanding control layouts Selecting controls Adding and deleting fields Moving controls Resizing controls Aligning controls Spacing controls Using the grid Adding a form title Adding a logo Adding the date and time Adding page numbers Changing the field tab order Exercise Review questions Summary
7.	Creating Reports	Objectives Overview Creating reports with the Report tool Creating reports using the Report Wizard Creating reports with the Blank Report tool Creating blank reports in Design View Understanding Layout View and Design View Resizing reports Understanding controls Selecting controls Adding and deleting fields Moving controls Resizing controls Aligning controls Spacing controls Using the grid Adjusting page layout Adding a report title Adding a logo Adding page numbers Adding the date and time Creating mailing labels Exercise Review questions Summary	8.	Formatting Forms and Reports	Objectives Overview Applying an AutoFormat Formatting with fonts Formatting with colour Changing text alignment Colouring alternate rows Applying conditional formatting Drawing lines Exercise Review questions Summary
9.	Module Summary	Congratulations Your quiz score Good luck