|
Provided by: Last Minute Training Access Introduction - Level 1Access |
 |
Training
Provided by Last Minute Training
This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.
|
|
||||||||||
Access Introduction - Level 1
Unit 1 : Database concepts
Topic A: 0 Database concepts and terminology
A-1: Using database terminology
Topic B: 0 Exploring the Access environment
B-1: Starting and examining the Access window
B-2: Opening a database
B-3: Examining the database window
B-4: Examining a database table
Topic C: 0 Planning and designing databases
C-1: Planning a database
C-2: Exploring database relationships
Topic D: 0 Getting help
D-1: Using the Ask a Question box
D-2: Using the Office Assistant
Topic E: 0 Closing a database and Access
E-1: Closing a database and Access
Unit 2 : Access basics
Topic A: 0 Exploring tables and forms
A-1: Discussing views
A-2: Examining a table in Datasheet view
A-3: Navigating in a table in Datasheet view
A-4: Examining a table in Design view
A-5: Identifying the primary key
A-6: Navigating in a form
A-7: Examining a form in Design view
Topic B: 0 Examining queries
B-1: Planning a query
B-2: Examining a query in Design view
B-3: Running the query and viewing the results
Topic C: 0 Exploring reports
C-1: Examining a report
C-2: Examining a report in Design view
Unit 3 : Creating databases
Topic A: 0 Creating a database
A-1: Verifying object names
A-2: Creating a database by using the Database Wizard
A-3: Creating a blank database
Topic B: 0 Using the Table Wizard
B-1: Creating a table and setting a primary key using the Table Wizard
Topic C: 0 Working in Design View
C-1: Creating a table in Design view
C-2: Adding text fields to a table
C-3: Adding fields of other data types
C-4: Entering field descriptions
C-5: Adding a Memo field
C-6: Setting the primary key
C-7: Saving the design and viewing the table
C-8: Adding a record
Unit 4 : Working with fields and records
Topic A: 0 Changing the design of a table
A-1: Examining field names
A-2: Changing the name of a field
A-3: Deleting and inserting fields
A-4: Moving a field
A-5: Setting field properties
Topic B: 0 Adding and deleting records
B-1: Adding a new record
B-2: Deleting a record
Topic C: 0 Finding and editing records
C-1: Finding and replacing a value
C-2: Undoing changes
C-3: Using spelling checker
Topic D: 0 Sorting and filtering records
D-1: Sorting records by a single field
D-2: Sorting records by multiple fields
D-3: Filtering records
Unit 5 : Querying tables
Topic A: 0 Creating and using queries
A-1: Creating a simple query by using the Simple Query Wizard
A-2: Creating a simple query in Design view
A-3: Sorting query results
A-4: Filtering query results
A-5: Saving a query
Topic B: 0 Modifying query results and queries
B-1: Editing query results
B-2: Modifying a query by adding more fields
B-3: Modifying a query by removing fields
B-4: Using comparison operators
B-5: Using the OR condition
B-6: Using the AND condition
B-7: Using the * wildcard
B-8: Finding records with empty fields
Topic C: 0 Using calculations in queries
C-1: Using calculations in a query
C-2: Totaling a group of records
C-3: Calculating values with the Avg and Count functions
Unit 6 : Creating and using forms
Topic A: 0 Creating forms by using AutoForm
A-1: Creating a form by using AutoForm
A-2: Navigating in a form by using the navigation bar
A-3: Using a form for data entry
Topic B: 0 Using the Form Wizard
B-1: Creating a form by using the Form Wizard
Topic C: 0 Using Design view
C-1: Creating a form in Design view
C-2: Adding a title to a form
C-3: Adding controls
C-4: Modifying properties
Topic D: 0 Finding, sorting, and filtering records
D-1: Using a form to find records
D-2: Using a form to sort records
D-3: Using a form to filter records
Unit 7 : Creating and using reports
Topic A: 0 Using the Report Wizard and queries
A-1: Using the Report Wizard to create a report
A-2: Create a report by using a query
Topic B: 0 Creating, modifying, and printing reports
B-1: Modifying the appearance of a report by using Design view
B-2: Grouping information in a report
B-3: Adding summary fields by using the Report Wizard
B-4: Modifying the layout and style of a report
B-5: Changing field properties
B-6: Printing a report
Unit 8 : Importing, exporting, and linking objects
Topic A: 0 Importing Access objects
A-1: Importing an object from a database
A-2: Importing multiple objects
Topic B: 0 Exporting Access objects
B-1: Exporting objects
Topic C: 0 Exporting and importing XML documents
C-1: Exporting and importing XML documents
Topic D: 0 Linking Access objects
D-1: Linking objects
D-2: Updating a link
Appendix A : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
Topic A: 0 Database concepts and terminology
A-1: Using database terminology
Topic B: 0 Exploring the Access environment
B-1: Starting and examining the Access window
B-2: Opening a database
B-3: Examining the database window
B-4: Examining a database table
Topic C: 0 Planning and designing databases
C-1: Planning a database
C-2: Exploring database relationships
Topic D: 0 Getting help
D-1: Using the Ask a Question box
D-2: Using the Office Assistant
Topic E: 0 Closing a database and Access
E-1: Closing a database and Access
Unit 2 : Access basics
Topic A: 0 Exploring tables and forms
A-1: Discussing views
A-2: Examining a table in Datasheet view
A-3: Navigating in a table in Datasheet view
A-4: Examining a table in Design view
A-5: Identifying the primary key
A-6: Navigating in a form
A-7: Examining a form in Design view
Topic B: 0 Examining queries
B-1: Planning a query
B-2: Examining a query in Design view
B-3: Running the query and viewing the results
Topic C: 0 Exploring reports
C-1: Examining a report
C-2: Examining a report in Design view
Unit 3 : Creating databases
Topic A: 0 Creating a database
A-1: Verifying object names
A-2: Creating a database by using the Database Wizard
A-3: Creating a blank database
Topic B: 0 Using the Table Wizard
B-1: Creating a table and setting a primary key using the Table Wizard
Topic C: 0 Working in Design View
C-1: Creating a table in Design view
C-2: Adding text fields to a table
C-3: Adding fields of other data types
C-4: Entering field descriptions
C-5: Adding a Memo field
C-6: Setting the primary key
C-7: Saving the design and viewing the table
C-8: Adding a record
Unit 4 : Working with fields and records
Topic A: 0 Changing the design of a table
A-1: Examining field names
A-2: Changing the name of a field
A-3: Deleting and inserting fields
A-4: Moving a field
A-5: Setting field properties
Topic B: 0 Adding and deleting records
B-1: Adding a new record
B-2: Deleting a record
Topic C: 0 Finding and editing records
C-1: Finding and replacing a value
C-2: Undoing changes
C-3: Using spelling checker
Topic D: 0 Sorting and filtering records
D-1: Sorting records by a single field
D-2: Sorting records by multiple fields
D-3: Filtering records
Unit 5 : Querying tables
Topic A: 0 Creating and using queries
A-1: Creating a simple query by using the Simple Query Wizard
A-2: Creating a simple query in Design view
A-3: Sorting query results
A-4: Filtering query results
A-5: Saving a query
Topic B: 0 Modifying query results and queries
B-1: Editing query results
B-2: Modifying a query by adding more fields
B-3: Modifying a query by removing fields
B-4: Using comparison operators
B-5: Using the OR condition
B-6: Using the AND condition
B-7: Using the * wildcard
B-8: Finding records with empty fields
Topic C: 0 Using calculations in queries
C-1: Using calculations in a query
C-2: Totaling a group of records
C-3: Calculating values with the Avg and Count functions
Unit 6 : Creating and using forms
Topic A: 0 Creating forms by using AutoForm
A-1: Creating a form by using AutoForm
A-2: Navigating in a form by using the navigation bar
A-3: Using a form for data entry
Topic B: 0 Using the Form Wizard
B-1: Creating a form by using the Form Wizard
Topic C: 0 Using Design view
C-1: Creating a form in Design view
C-2: Adding a title to a form
C-3: Adding controls
C-4: Modifying properties
Topic D: 0 Finding, sorting, and filtering records
D-1: Using a form to find records
D-2: Using a form to sort records
D-3: Using a form to filter records
Unit 7 : Creating and using reports
Topic A: 0 Using the Report Wizard and queries
A-1: Using the Report Wizard to create a report
A-2: Create a report by using a query
Topic B: 0 Creating, modifying, and printing reports
B-1: Modifying the appearance of a report by using Design view
B-2: Grouping information in a report
B-3: Adding summary fields by using the Report Wizard
B-4: Modifying the layout and style of a report
B-5: Changing field properties
B-6: Printing a report
Unit 8 : Importing, exporting, and linking objects
Topic A: 0 Importing Access objects
A-1: Importing an object from a database
A-2: Importing multiple objects
Topic B: 0 Exporting Access objects
B-1: Exporting objects
Topic C: 0 Exporting and importing XML documents
C-1: Exporting and importing XML documents
Topic D: 0 Linking Access objects
D-1: Linking objects
D-2: Updating a link
Appendix A : MOUS exam objectives map
Topic A: 0 Core exam objectives
Topic B: 0 Expert exam objectives
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
