|
|
ICB Consulting, Inc. Good with computers, but even better at helping people. |
|
Microsoft Access 2010 Level 1 Training Class This is a one day, introductory training class on Microsoft Access. It is an instructor-led, classroom style course. We do not assume you have any experience with Microsoft Access or databases in general. 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. Lesson 1: Overview of Access Topic 1A: Introduction to Database Concepts and Terminology Topic 1B: Introduction to Access 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
|
|
Copyright: ICB Consulting, Inc. | About Us | Contact Us |