Access Foundation
This course will enable delegates to use and create a database using Access 2007, to an intermediate level.
Click on a location to see available dates, read more details and to register your interest:
Course outline
Day One
User Interface
Use the Office Button, Ribbons, Command Tabs and Sets and Contextual Tabs; Customise the Quick Access Toolbar.
Getting to Know Access 2007
Open an existing database; Open tables in different views; Open and run queries; Open a form in different views; Open a report in different views.
Creating a New Database
Create a new database structure using a wizard; Check the work of the wizard; Create an empty database, and add tables using a wizard; Refine the way your data is displayed; Manipulate columns and rows in tables.
Getting Information into and out of a Database
Import information from various programs and from other Access databases; Export information to other programs; Link database content to other databases.
Simplifying Data Entry with Forms
Create a form using a wizard; Refine the properties and layout of a form; Create a form using AutoForm; Create a form based on more than one table.
Smart Tags
Context sensitive buttons to choose different options.
Day Two
Locating Specific Information
Sort information on one or more fields; Filter information in various ways; Create queries that find information in one or more tables; Create a query to perform calculations.
Keeping your Information Accurate
Restrict the information entered in a database using the data type; Restrict the information entered in a database using various filed properties; Update information in a table; Delete information from a table.
Working with Reports
Create a report using a wizard; Modify a report; Create a report from scratch; Add a subreport to a report; Preview and print a report.