|
|
|
Module 1: Introduction to Microsoft Access 2000
- Getting started with Access
- Overview of the book store application
- Creating a database
Skills
- Introduce the major features of Access
- List the benefits of using Access 2000 to manage your data
- Describe the purpose of database elements
- Create a database by using the Database Wizard
- Create a database application using the Database Wizard
- Investigate the book store application case study
Top |
|
Module 2: Designing a Database
- Designing reports, queries, and forms
- Designing tables
Skills
- Identify the requirements for a database, given a specification
- Identify the objects that are required in the database
- Organize data into tables
- Identify fields in a table that uniquely define a row of data
- Identify the relationships between the tables in a database
- Identify the data validity requirements for each field
Top |
|
|
Module 3: Storing Data
- Creating a table
- Customizing a table
- Adding and editing data in a table
- Working with related tables
Skills
- Create a table in Access by using the Access Table Wizard
- Customize a table in Design view
- Set field properties for a table
- Edit and enter data into a table
- View the contents of a table in Datasheet view
- Import data from external sources
- Define a one-to-many relationship between two tables
Top |
|
Module 4: Getting Data
- Finding information in a table
- Filtering data
- Querying the database
- Customizing a query
Skills
- Use the Find command to search a table for data
- Filter data by using the appropriate filter feature (by selection, by form etc)
- Create a query by using the Simple Query Wizard
- Customize a query in Design view
- Use calculated fields in a query
- Use criteria in a query to selectively retrieve records
Top |
|
|
Module 5: Building Forms
- Creating a form
- Customizing a form
- Working with forms
Skills
- Create forms by using the Access Form Wizard and the AutoForm feature
- Customize the appearance of a form and its sections in Design view
- Set form properties
- Use simple controls on forms and create calculated fields
- Use built-in functions on forms
- Print a form
Top |
|
Module 6: Building Reports
- Creating a report
- Customizing a report
- Enhancing a report
Skills
- Create reports by using the Access Report Wizard and the AutoReport feature
- Customize the appearance of a report, and its sections, in Design View
- Preview and print a report
- Set report properties
- Enhance a report by sorting and grouping records
- Apply conditional formatting to fields on a report
- Use controls and built-in functions in a report
- Export an Access report for viewing in a browser or in other Microsoft Office products.
Top |
|
|
Module 7: Creating Data Access Pages
- Creating a data access page
- Customizing a data access page
- Working with a data access page
Skills
- Create a data access page by using the wizard
- Customize the appearance of a data access page in Design view
- Create a data access page that supports data entry
- Convert an HTM file into a data access page
- Group records on a data access page
- Sort records on a data access page
Top |
|
Module 8: Creating a Database Application
- Adding a switchboard to a database
- Defining startup options for a database application
- Maintaining a database
- Using a previous-version database in Access 2000
Skills
- Create a switchboard for your database, and tie the elements together
- Define startup settings for your database applications
- Back up and restore your database
- Compact and repair your database
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
790
(€1122)
|
£
449.00
(€638)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
