Introduction to MS-Access
Access
Training
Provided by Computers Etc Software Training Center
Learn how to create an Access database and work with tables, forms, queries, and reports.
|
|
||||||||||||
Introduction to MS-Access
ACCESS BASICS:
Create, edit, save, and print information in a simple one-table database.
CREATE & EDIT TABLES:
Use Design View to create and edit tables. Add, format, move, and delete fields. Enter, edit, and delete data in Datasheet View. Adjust width of columns and change font/font size of text. Add Default Values, Lookup fields, and Input Masks to speed up data entry.
CREATE & EDIT FORMS:
Create forms based on tables. Enter and edit data and forms. Change background color of form, as well as move and resize fields.
SORT AND FILTER DATA:
Use Find & Replace to locate and/or change data, use Quick Sort to sort data alphabetically, use Filter by Selection to search for specific data in tables.
CREATE QUERIES:
Sort and filter data using different criteria such as name, amount, and date. Use multiple criteria to narrow a search, use wildcards, sort by range of dates or amounts, etc.
REPORTS:
Use Report Wizard to create professional looking reports based on tables and queries. Edit reports in Design View.
PREREQUISITES: Introduction to Windows or comparable experience. Course handout covers versions 95-2003. Students will use version 2003 in class.
Create, edit, save, and print information in a simple one-table database.
CREATE & EDIT TABLES:
Use Design View to create and edit tables. Add, format, move, and delete fields. Enter, edit, and delete data in Datasheet View. Adjust width of columns and change font/font size of text. Add Default Values, Lookup fields, and Input Masks to speed up data entry.
CREATE & EDIT FORMS:
Create forms based on tables. Enter and edit data and forms. Change background color of form, as well as move and resize fields.
SORT AND FILTER DATA:
Use Find & Replace to locate and/or change data, use Quick Sort to sort data alphabetically, use Filter by Selection to search for specific data in tables.
CREATE QUERIES:
Sort and filter data using different criteria such as name, amount, and date. Use multiple criteria to narrow a search, use wildcards, sort by range of dates or amounts, etc.
REPORTS:
Use Report Wizard to create professional looking reports based on tables and queries. Edit reports in Design View.
PREREQUISITES: Introduction to Windows or comparable experience. Course handout covers versions 95-2003. Students will use version 2003 in class.
About The Training Provider: Computers Etc Software Training Center
Computers Etc Software Training Center - Since 1992 we have provided hands-on computer training to over 10,000 San Diego students from all walks of life. We offer basic and advanced training in Access, AutoCAD, Excel, FrontPage, HTML, PageMaker, PhotoShop, PowerPoint, Publisher, QuickBooks, Word, and other popular Windows-based programs.
We offer day, evening, and weekend classes. Certificates of Completion (suitable for framing)...
