Introductory
Microsoft Access 2003/2007/2010
Introductory Level
This course is designed for delegates wishing to introduce a relational database system, or for those users who wish to enhance their knowledge of a Windows based database system. By the end of this course, delegates will be able to build a simple relational database.
Pre-Requisite: Delegates attending this course should be already working with an Access database and wish to expand their knowledge, or should be about to commence the development of a database. This course is unsuitable for those delegates who will only be performing data entry into a database.
Duration: 1 Day
Topics Covered:
Database design and table creation
- Design and document your database
- Basic design rules
- Determine relationships
- Creating a database
- Creating a table without a wizard
- Adding fields to a new table
- Field properties
- The input mask property
- Setting a primary key
- Saving a table
- Adding records to a table datasheet
?
Formatting a table
- Editing records
- Selecting records with the mouse
- Selecting records using the keyboard
- Selecting fields with the mouse
- Selecting columns using the mouse
- Selecting fields and columns using the keyboard
- Deleting records and fields
- Viewing or setting datasheet default values
- Re-ordering columns within a table
- Re-ordering fields in the table
- Changing column width and row height
- Hiding and un-hiding columns
- Freezing columns
- Formatting datasheet cells
- Changing datasheet fonts
- Copying and moving fields and records
- Another look at the database window
?
Relationships
- Defining relationships
- Opening the relationships window
- Adding tables to the relationships window
- Making relationships
- Referential integrity
- Editing relationships
?
Locating and replacing information
- A simple search
- Wildcards
- Finding specific values
- Find and replace
- Sorting records on more than one field
- What is a filter?
- Filtering records by selection
- Filtering records by form
?
Creating simple queries
- Creating queries, using the simple query wizard
- Creating queries without the wizard
- The query grid
- Logical operators in criteria
- Text in criteria – wildcards
- Multiple criteria and alternative criteria
- Calculated fields
?
Creating calculated fields
- Creating calculated fields
- Using the expression builder
?
Introducing forms
- Basic form layout types
- Creating a form
- Different ways of viewing forms
?
More about creating forms
- Creating forms without using the form wizard
- The form design view window
- Manipulating form design
- Types of control
- The toolbox
- Creating a combo box control
- Changing form properties
?
Reports
- Creating a report using autoreports
- Creating reports using the report wizard
- Grouping levels in reports
- Creating a report without a wizard
- Creating controls
- Setting properties
|
|
