Introduction to MS-Access
Access
Learn how to create an Access database and work with tables, forms, queries, and reports.
|
|
||||||||||
Training
Provided by Computers Etc Software Training Center
- M asked: - How can I learn ms acces through internet without spend money ( I mean free)? - is there any links that I learn from it in free? thanks
- H asked: do you have upcoming classes in Access?
- M asked: Is there a charge
- K asked: Interested in more info on signing up for the class in San Diego, CA.
- N asked: I use microsoft access queries to run metrics, group data and relate tables to each other. I need a san diego class that focus on using access for metrics. subtoting to distinct character, counting the number of occurances in a given range. I have learned how to import, link and sub tot on one character, but then I have to download to excel and manually get the raw data Can you help?
- P asked: I am interested in taking an Intro to Access class.
- K asked: would like training of intor through advanced MS Access.
- M asked: Your course shows a pre-req of basic knowledge in Access. Exactly how much knowledge is expected of the student to make sure they understand the course you're offering? Is there a more basic course you offer in conjunction with this course?
- K asked: am requesting information on how to sign up for a access & excel class and where the class would be held. This training is for my current employment.
- A asked: Hello, I'm wondering if this training is held in San Diego? Also what would be the size of the class? Will there be opportunity to call or follow-up with the trainer?
- A asked: I am an event planner. I have friends in the field who use Access as their main database and I have Access available to me at my place of employment, but it is not currently in use. Currently, FileMaker Pro is in use. I would like to learn about setting up an Access database for event planning - tracking registration for conferences, tracking reg. payments, tracking hotels (rooms, meeting rooms, catering and AV), etc. Also, I would like to know about the possibilities for online registration and linking to Access. Phone extension .
- S asked: importance of ms word
- A asked: Would like pricing and how long this would take to do the training online.
- K asked: Is this training available in my area (Columbus, OH)? When can I begin this training class?
- R asked: I am seeking a one day seminar off site on MS Access.
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.
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.
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)...
