Microsoft Access Training – Level 1

Testimonials

1. GETTING STARTED

Getting Familiar with the Access Screen +

1. Starting Access
2. Identifying parts of the Access screen
3. Working with the Ribbon & backstage view
4. Using the quick access toolbar
5. Creating a new blank database

Planning & Designing a Database +

1. Determining current & future needs
2. Organizing data & selecting fields names
3. Deciding data types for fields

Managing Data Base Files +

1. Opening & closing an existing database
2. Using the navigation Pane
3. Working with database objects
4. Exiting Access

2. TABLES

Creating a Table in Datasheet View +

1. What is a table?
2. Creating a new table in datasheet view
3. Defining table fields
4. Assigning field names & data types
5. Using the quick add feature
6. Entering, editing, or deleting records
7. Setting field sizes & using best fit
8. Navigating through records
9. Saving a table

Changing Views +

1. Switching between design & datasheet view

Creating a Table in Design View +

1. Adding fields
2. Selecting data types & entering description
3. Defining a field as a primary key
4. Renaming, rearranging, or deleting fields
5. Using the lookup wizard

Modifying Field Properties +

1. Setting field size & formatting
2. Using the input mask

Sorting Records +

1. Sorting records in ascending or descending order
2. Sorting records using multiple criteria

Searching Records +

1. Finding & replacing records

Printing +

1. Printing & previewing a table
2. Printing records
3. Changing margins & page orientation

3. TABLE RELATIONSHIPS

Managing Relationships +

1. Understanding relationships
2. Setting primary keys & foreign keys
3. Creating table relationships
4. Types of relationships
5. Viewing related tables
6. Specifying referential integrity
7. Printing database relationships
8. Editing or deleting relationships
9. Displaying related records in a sub-datasheet

4. CHECKING SPELLING & GETTING HELP

Spelling Check +

1. Using the spelling check

Getting Help +

1. Searching help or using content help

5. QUERIES

Creating a Query by Using the Wizard +

1. What is a Query?
2. Using the simple query wizard
3. Selecting the table source
4. Selecting fields
5. Saving the query

Creating a Query in Design View +

1. Adding tables to the design query window
2. Selecting fields & establishing query criteria
3. Creating a multiple related tables query
4. Sorting fields in a query
5. Saving the query

Controlling Queries Output +

1. Opening & switching queries to design view
2. Adding, rearranging or deleting fields
3. Sorting the query output
4. Filtering the query output with one or multiple criteria
5. Hiding fields
6. Changing column headings in a query

Filtering Data +

1. Filtering records by selection or by form

6. FORMS

Creating Forms by Using the Form Wizard +

1. What is a form?
2. Creating a form using the form wizard
3. Saving or renaming a form
4. Sorting records using a form
5. Entering, editing or deleting records using a form
6. Creating a form from related tables
7. Moving within or between records
8. Printing forms

Creating Forms in Design View +

1. Switching views: Form, layout, & design view
2. Showing or hiding the field list
3. Adding or deleting controls
4. Resizing, formatting, or aligning controls
5. Moving controls & labels
6. Displaying form properties
7. Using fields to add controls
8. Adding a form header & footer

7. REPORTS

Report Views +

1. Report view
2. Print preview
3. Layout view
4. Design view

Creating Reports by Using the Report Wizard +

1. What is a report?
2. Creating reports based on queries
3. Preparing a report based on two or more tables
4. Modifying reports

Creating a Report in Design View +

1. Using fields to add controls
2. Moving & Resizing controls
3. Adding & formatting controls
4. Changing the report theme
5. Adding headers & footers

Printing Reports +

1. Setting page margins & changing page orientation
2. Printing & previewing reports