Access Foundation
THIS COURSE CAN BE RUN AS A CLOSED COURSE FOR YOUR COMPANY OR AS A 1 TO 1 COURSE FOR INDIVIDUALS. PLEASE CALL FOR INFORMATION AND DATES
This course will enable delegates to use and create a database using Access 2007.
Sorry, there are currently no dates scheduled for this course.
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.