You will create and modify new databases and their various objects.
Course Objectives
The course will cover the following elements:
- Identify the elements of the Access interface
- Identify the components of a database
- Examine the relational database design process
- Create a new database
- Create a table using the design view
- Manage tables
- Establish table relationships
- Create a new database
- Create a table using the design view
- Manage tables
- Establish table relationships
- Modify table data
- Sort and filter records
- Work with sub-data sheets
- Create a query
- Add criteria to a query
- Add a calculated field to a query
- Perform calculations on a record grouping
- Create a form
- Modify the design of a form
- View and edit data suing an access form
- Create a report
- Add a control to a report
- Format the controls in a report
- Enhance the appearance of a report
- Prepare a report for print
Prerequisites
To be successful in this course, you should be familiar with using personal computers and you should have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of ABCO Technology’s introductory Windows courses, such as either of the following, or have equivalent skills and knowledge:
- Windows XP Professional: Level 1
- Windows XP: Introduction
Course Benefits
Upon successful completion of this course, students will be able to:
- Build database structure
- Mange data in a table
- Query a database
- Design forms
- Generate reports