This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview:
Access 2000: Level 1 is a hands-on instruction book that will introduce you to the basics of Access 2000. You will learn how to create and use database objects, including tables, queries, forms, and reports.
Benefits:
Students will learn how to create and use database objects, including tables, queries, forms, and reports.
Prerequisites:
We designed Access 2000: Level 1 for the student who needs to learn the basics about Access 2000. Although no prior knowledge of databases or Access is assumed, you should be familiar with personal computers and comfortable working in a Windows environment. To ensure your success with this course, we recommend that you first take the following Content courses or have equivalent knowledge:
- Windows 95: Introduction
- Windows 98: Introduction
- Windows 98: Making the Transition
Target Student:
Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be fairly comfortable working in the Windows environment. No prior knowledge of databases or Access is assumed.
Performance-Based Objectives:
- Understand database concepts and terminology in Access 2000.
- 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.
Certification:
Access 2000: Level 1 is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Delivery Method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
What's Next:
Access 2000: Level 1 is the first course in this series. Access 2000: Level 2, the next course in this series, teaches students how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Students who want to learn advanced features can take the third course in this series, Access 2000: Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros. The final course in this series, Access 2000: Introduction to Application Design, teaches students to create custom applications.
Course duration:
1 Day(s)
Course outline:
Lesson 1: Overview of Access 2000
- Topic 1A: Introduction to Database Concepts and Terminology
- Topic 1B: Introduction to Access 2000
- Topic 1C: Database Planning and Design
Lesson 2: Creating Tables
- Topic 2A: Examining a Table
- Topic 2B: Creating a Table with the Table Wizard
- Topic 2C: Creating a Table in Design View
- Topic 2D: Types of Primary Keys
Lesson 3: Working with Tables
- Topic 3A: Modifying a Table Using Design View
- Topic 3B: Finding and Editing Records
- Topic 3C: Filtering and Sorting Records
Lesson 4: Creating and Using Select Queries
- Topic 4A: Creating a Select Query to View Specific
Fields
- Topic 4B: Specifying Criteria in a Query to View Specific
Records
- Topic 4C: Using Queries to Perform Calculations
- Topic 4D: Joining Tables in a Query
Lesson 5: Creating and Using Forms
- Topic 5A: Creating a Form with the Form Wizard
- Topic 5B: Modifying the Form Design
- Topic 5C: Using a Form to Locate and Organize Information
- Topic 5D: Multiple-table Forms
Lesson 6: Creating and Using Reports
- Topic 6A: Creating a Report with the Report Wizard
- Topic 6B: Creating a Report that Contains Totals
Lesson 7: Creating and Maintaining a Database
- Topic 7A: Creating a Database
- Topic 7B: Managing a Database and Its Objects
- Topic 7C: Database Maintenance
Hardware/Software Requirements:
You will need:
- A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium
133 or faster with 32 MB or more.)
- 600 MB of free hard-disk space. For optimal performance, we
recommend an additional 100 MB of free hard-disk space for user graphics and
temporary image caches.
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for installation purposes
- A 3.5"-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- VGA or higher-resolution monitor; Super VGA recommended. (The
EGA display adapter is not supported.)
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- An Internet connection with access to the World Wide Web.
The connection is necessary to complete some tasks and Web Tips throughout
the book. (Note: Internet access may require payment of a separate fee to
a service provider.)
- Microsoft Windows 95 (or later) operating system, Microsoft
Windows NT Workstation operating system version 4.0 with Service Pack 3 (or
later) installed. If you are running Windows NT, make sure that you have at
least 4 MB of free Registry space.
- A custom installation of Microsoft Office 2000 Premium Edition—see
the following section, “Class Requirements,” for additional instructions.
