|
|
| Course Description | ||
| Students will learn the basic skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports. | ||
| Course Content | Prerequisites |
|
| Lesson 1: Overview of Access Intoduction to Database Concepts and Terminology Introduction to Access 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 Modifying a Table Using Design View Finding and Editing Records Filtering and Sorting Records Lesson 4: Creating and Using Select Queries Creating a Select Query to View Specific Fields Specifying Criteria in a Query to View Specific Records Using Queries to Perform Calculations Joining Tables in a Query Lesson 5: Creating and Using Forms Creating a Form With the Form Wizard Modifying the Form Design Using a Form to Locate and Organize Information Multiple-Table Forms Lesson 6: Creating and Using Reports Creating a Report With the Report Wizard Creating a Report That Contains Totals Lesson 7: Creating and Maintaining a Database Creating a Database Managing a Database and Its Objects Database Maintenance |
Computers for Beginners | |
| or equivalent knowledge. | ||
| Course Duration | ||
| 7.5 hours | ||
| Study Methods Available | ||
| aIndividual Tuition | ||
| aGroup Training | ||
| x Distance Learning | ||
| Follow-on Courses | ||
| Access Level 2 | ||
| All Courses | ||
| Click here to see all our courses | ||
