Summary

This series covers how to use Access 2007 to create, modify, and access databases. It shows the learner how to use the Ribbon-based Access 2007 interface, as well as how to build tables, forms, and reports. Learners will also be able to use queries and filters to sort through data.      

Audience

This course is for anyone who wants to learn more about Access 2007.  

Access 2007 Introduction to Access   - 1 Hr

This course provides information on the Access 2007 interface, creating a database using templates, and the available database views.        

• Use the Ribbon to access command buttons and groups
• Use the Office menu to access commands dealing with the whole application or database
• Use the Navigation Pane to view and open database objects
• Start a new database by using templates provided by Microsoft Office Online

Access 2007 Creating Reports   - 1 hrs      

This course provides information on creating reports using Access 2007.  

• Create a basic report
• Create a report using the Report Wizard
• Create a customized report

Access 2007 Creating Tables   - 2 hrs      

This course provides details about creating tables in Access 2007, as well as how to add and delete records and tables from a database. It also covers basic database terminology, data types, primary keys, flat files, and relational databases.          

• Recognize data types and basic database terminology
• Add and delete fields from a table
• Set the primary key for a table
• Identify flat files and relational databases
• Create simple tables
• Add
• modify
• and delete records from a table

Access 2007 Creating Forms   - 2 hrs      

This course provides information on creating forms in Access 2007, including simple forms, more complex multiple items forms, and split forms. It also shows how to create customized forms using the Form Wizard.          

• Create simple forms using the Form button
• Create split and multiple items forms
• Use the Form Wizard to create customized forms
• Edit and customize a form using Form Design view

Access 2007 Creating Queries and Filters   - 1 hrs      

This course provides information on how to use queries and filters to search and sort your database tables. It shows how to filter using the Sort and Filter feature and how to build queries using the Query Wizard.          

• Explain the difference between a query and a filter
• Apply sorts and filters to your tables
• Build a query using the Query Wizard
• Add query criteria to narrow the focus of your queries

Access 2007 Working with Tables   - 2 hrs      

This course provides information on creating tables in Access 2007, including advanced features such as input masks, validation rules, and table relationships.          

• Apply basic formatting to a database table
• Create input masks for table fields
• Create validation rules for table fields
• View and modify the relationships between tables

Purchase this course from our e commerce site at www.AuditExcel.com

• Access 2003 Training Series
• Access 2007 Advanced Series
• Access 2007 Series
• Converting to Office 2007 Series
• Excel 2003 Training Series
  
• Excel 2007 Advanced Series
• Excel 2007 Series
• ICDL
• Outlook 2007 Series
• Office 2007 Series
• PowerPoint 2007 Series
  
• Sharepoint 2007 Series
• Word 2003
• Word 2007 Series

Downloads and Free Trial

See how it works with our free Excel 2003 beginner course.

OR

Convince you manager to pay for your education

OR

More about the training material and how it works

Looking for something else? Search the site