Computer Technology

Name______

  1. Please go to the Gateway home page, scroll down, left side-click on APS One Place
  1. Next, click on the Atomic Learning icon.
  1. Login information-- Username: student372Password: student
  1. Fill in the blanks:
  1. Complete all of the tutorials below. Please check each lesson when complete.

Access 2007 – Intro / Check When Complete / Length
1. / / Starting Access and creating a desktop shortcut / 1:23
2. / / Using the Getting Started screen / 1:58
3. / / Opening an existing database or recently used database / 1:33
4. / / Exploring the Microsoft Office button / 2:24
5. / / Using and customizing the Quick Access toolbar / 2:09
6. / / Understanding the Ribbon / 2:18
7. / / Using the Navigation pane and Shutter bar to display and manage database objects / 2:30
8. / / Closing a database and exiting Access / 1:08
9. / / Using the Access Help window / 3:12
10. / / Searching for a topic in Access Help / 2:37
11. / / Creating a PDF / 2:43
1. / / Temporarily enabling a database that is not trusted / 1:35
2. / / Viewing and understanding the Trust Center / 2:56
3. / / Defining trusted locations / 1:35
1. / / Beginning a new database / 0:57
2. / / Creating a new database based on an existing database / 1:50
3. / / Create a database from a template / 1:53
4. / / Finding database templates online / 2:26
1. / / Creating a table in Design view / 2:35
2. / / Creating a table by typing / 2:38
3. / / Creating a table using a Table template / 1:54
4. / / Adding fields to a table from the Field Template task pane / 2:18
5. / / Assigning a Primary key / 1:52
6. / / Assigning a Primary key to more than one field / 2:01
7. / / Inserting and deleting a field / 1:55
8. / / Navigating a table / 2:07
1. / / Finding data in a table / 3:05
2. / / Replacing data in a table / 2:18
3. / / Entering data using AutoCorrect / 2:28
4. / / Adding your own AutoCorrect values / 2:02
5. / / Using spell check / 2:26
6. / / Hiding and unhiding columns / 1:00
7. / / Freezing and unfreezing columns / 1:45
8. / / Renaming a field / 1:51
9. / / Copying a field / 1:07
10. / / Changing row height and column width / 2:31
11. / / Filtering records in a table / 2:11
12. / / Filtering records by form / 1:54
1. / / Creating a simple form / 1:52
2. / / Working in Layout view pt. 1 / 2:43
3. / / Working in Layout view pt. 2 / 2:34
4. / / Creating a form using the Form wizard / 1:56
5. / / Creating a form from scratch / 2:55
6. / / Adding a field to a form / 1:34
7. / / Working in Design view / 2:47
8. / / Using a form to add, modify, and delete records / 2:19
9. / / Displaying a form and its Data Sheet simultaneously / 2:50
1. / / Creating a Detail query / 2:22
2. / / Creating a Summary query / 2:32
3. / / Creating a query in Design view / 2:23
4. / / Creating a Multiple Table query / 2:41
5. / / Adding criteria to a query / 2:01
6. / / Using logical operators in queries / 1:59
7. / / Sorting query results / 1:48
8. / / Finding the top values in a query / 1:07
1. / / Creating a report using the Report wizard / 3:01
2. / / Creating a one-click report / 1:03
3. / / Modifying a report in Layout view / 3:03
4. / / Creating a report in Design view / 2:56
5. / / Adding a page header and footer / 3:09
6. / / Adding a report header and footer / 2:20