Students will learn basic worksheets skills and how to work with data in worksheets.
Course Objectives
You will be introduced to the features of the Access 2003 application.
Prerequisites
To ensure your success with this course, we recommend that you first take the following Element K Content courses or have equivalent knowledge:
- Windows 2000: Introduction
- Windows XP: Introduction
- Windows XP Professional: Level 1
- Windows XP Professional: Level 2
Performance-Based Objectives
The primary objective is to teach the basic skills necessary to use the Access 2003 program.
- Understand database concepts and terminology in Access 2003.
- Design and create tables.
- Enter and manipulate data in tables.
- Use Access queries to select and analyze information in a table.
- Create data forms for viewing and inputting data.
- Create reports that summarize and group data.
- Perform database maintenance procedures.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware/software required to run this course
- A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.
- A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
- 128 MB of RAM.
- A 6 GB hard disk.
- Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 4.
- Microsoft Office Professional Edition 2003.
- Installed printer drivers so that Print Preview can be used; printers are not required, however.
- An 800 x 600 resolution monitor.
- A two-button mouse or IntelliMouse.
- A CD-ROM drive.
- Network cards and cabling for local network access.
- Internet access (see your local network administrator).
- A printer (optional).
- A projection system to display the instructor's computer screen.
Course duration
1 Day(s)
Course outline
Lesson 1: Overview of Access 2003
- Introduction to database concepts and terminology
- An introduction to Access 2003
- Database planning and design
Lesson 2: Creating tables
- Examining a table
- Creating a table with the Table Wizard
- Creating a table in Design View
- Types of primary keys
Lesson 3: Working with tables
- Adding records
- Modifying the table design
- Finding and editing records
- Deleting, adding, and copying records and values
- Filtering and sorting records
Lesson 4: Using select queries
- Selecting fields and sorting records
- Refining the results of a query
- Using queries to perform calculations
- Joining tables in a query
Lesson 5: Creating and using forms
- Creating a form
- Modifying the form design
- Using a form to locate and organize information
- Multiple-table forms
Lesson 6: Creating and using reports
- Creating a report
- Creating a report that contains totals
Lesson 7: Creating and maintaining a database
- Creating a database
- Managing a database and its objects
- Database maintenance
Appendix A: Data Access Pages
Appendix B: Improve Efficiency in a Database
- Improve Efficiency in a Database
Appendix C: Back Up a Database
- How to Back Up a Database
