Microsoft Access Tutorial
Microsoft Access Tutorial
Information and training on Access Databases with articles, video tutorials and other resources
The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access's administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool and Access Security module to name but a few.
If you have wondered where you start to learn about Microsoft Access the quickest and simplest way, then welcome as I will step you through and guide you to learning Access the easy way!
Access beginners sometimes find this application overwhelming as there are a lot of objects and components to an Access Database. I am going to start by de-mystifying some of these objects and introduce you to Access Terminology first and foremost.
Getting to grips with some of the Access terminology will serve as a useful glossary for learning and mastering this application and any supporting resources you may use.
So what's a database? A database is a collection of information that has been organised so that the information is easy to access and display in different ways. Databases are used everywhere: at work, in the home, in schools, and leisure facilities. Examples of a database would be a telephone directory, a mailing catalogue, or even a CD music library.
Within Access, a database simply refers to a collection of different data sets known as Tables which are potentially related and therefore joined together.
The process of relating and joining tables together is what makes Access a Relational Database Management System (RDBMS) and on the whole provides more flexible reporting and richer functionality within this application.
Heard about the Primary Key? An Access field in a table can be assigned a primary key and is highly recommended. This field acts as the responsible field when joining to other related tables. It's a field that must be unique, mandatory and it prevents any duplicate values being stored.
Recordsets also known as dynasets simply refer to the results of a collection of records from one or more tables normally produced by a query.
What's a Query then? Probably, this is the most important object from the human point of view. Access Queries are the answers to your questions! When you want to run a report, you don't want to produce all records each time. Instead, you will narrow down the search by setting criteria (asking that question) to produce the recordset.
At this point, I have now covered the essentials regarding the data processing terms and some of the objects. Together, all this adds up to what is generally referred as the 'Back-End' of the database system.
Next, I'm going to quickly run through the 'Front-End' part of the database system starting with creating user-friendly screens known as Forms.
A Form is a document layer that points to either a table or query providing recordsets that users can view and manage. Remember, you don't want to work in the 'backroom' or 'cupboard' of a database so you create a Form instead.
A Report is simply a rich formatted report layout based on either a table or query and is read only (print preview mode). The rich set of tools makes this object the obvious choice for document presentation and therefore does not require any additional software.
When you are designing objects, you will come across types of Controls which is another word for a component in a document namely Labels, Text Boxes, Combo Boxes and other types of components. Each Control will have many Properties that define the attributes or characteristics of a Control and when mixed together, change the look, feel and behaviour of that Control from basic formatting, setting an Access field to creating high level links and expressions.
The final item to mention and to conclude the Access terminology article is a more technical design term which pops up from time to time known as Database Normalisation.
When creating an Access RDBMS system, the process of Normalisation should be understood so that you take advantage of the rules in place and create a solid and well structured database.
Now, you should feel a little more comfortable with the basic Access terminology so as and when you use Access help files you will have some idea of the definitions.
About the Author
Ben Beitler is a qualified IT trainer and developer specialising in Microsoft Access and Microsoft Excel applications for over 15 years.
Visit my websites: www.about-access-databases.com and www.access-database.com for more free information!
C# and Access Database tutorial?
Does anyone know where I can find a tutorial on using C# and Microsoft Access?
I can find a lot on how to connect to one, but not how to search the data, display, change, etc...
Any help would be appreciated.
Actually, all you need to know is how to connect to MsAccess databases and you're good to go.
How to select,insert,update,delete records on your tables is done thru MsAccess' SQL commands. You then use C# (or any other programming language) to manipulate those data on your program.
Since you already have searched the net, I would recommend you to go back at it, thoroughly analyze the code, and understand each line of it.
Even if we give you links on where to go, it may still not be enough to educate you.
Before you learned how to walk, you had to roll, crawl, and bump your head a couple of times right?
Experiment! Break it! Learn from it!
Good luck!
Microsoft Access Tutorial
Microsoft Access Tutorial 101.1 by 599CD
Tutorials download
Special free tutorial resources on various IT topics like Php, ASP, HTML etc TutorialsDownload.com offer a beginner's guide to the new users with a detailed and advanced knowledge of the web technologies. The tutorials are the guidelines to learn more about web technologies and become professional
Get Free HD Quality and Industry Standard Video & Text Tutorials . our tutorials covers a wide range of Technologies & packages such as c , c++ , HTML , php , java, .net Adobe Photoshop , Illustrator, Dream weaver, Adobe Flash , Adobe Premiere pro and more . All presented in a free video tutorial format. Our tutorial video collection is designed to help beginners and those who are wishing to learn new software & Technologies to become Efficient & those wanting to advance their skill set. We are here for every who loves to learn New Technologies or packages.logon to www.tutorialsdownload.com
for more tutorials and daily news letters with tutorials . We use to Organize Online Competitions to help you analyze your Skills and A chance to win FREE goodies and Prizes. Don't forget to Checkout our Event Section for Latest Events & Competitions.
Microsoft .Net is actually a software component that runs on windows operating system.Earlier.Net was originally called as term NGWS (Next generation Windows Services), which was been actually used for the Microsoft's plans for producing an internet based platform for next generation window services. .NET is the brand name used for a set of technologies as well proprietary Microsoft frameworks mainly founded in XML web services standards. Microsoft introduced .NET with the intention of bridging of the gap providing interoperability between the applications.
Java was conceived in 1991 by James Gosling of Sun Microsystems. This language was initially called "Oak" but was renamed "Java" in 1995. Much of Java characters are inherited from C and C++. The motivation behind the creation of java was the need for a platform independent language. Over the years Java has been enhanced and several versions are released.
The Java programming language consists of a Java compiler (javac), the Java virtual machine(JVM), Java runtime environment (JRE) and the Java class libraries. Java compiler translates Java into byte-code; JVM understands this byte-code, interprets it and runs the program. JRE consists of JVM and the class libraries.
C++ is an object oriented programming language which implements "data abstraction" using a concept called "classes", along with other features. Parts of the C++ program are easily reusable and extensible; existing code is easily modifiable without actually changing the code. C++ adds a concept "operator overloading" not seen in other OOP languages which make the creation of libraries cleaner. C++ maintains the features of C, yet has features which simplify memory management. Some of the features of C++ allow low-level access to memory but also contain high level features.
The C language was developed in 1972 by Dennis Richie at Bell Telephone laboratories, primarily as a systems programming language. Richie's primary goals were to produce a minimalist language that was easy to compile, allowed efficient access to memory, produced efficient code, and did not need extensive run-time support. It was designed to encourage machine and platform independent programming. C's efficiency and flexibility ended up in the rewriting of most of the UNIX operating system using C. Also C's excellent portability allowed UNIX to be recompiled on different types of computers.
Many versions of C were released in the coming years. In 1999, the ANSI committee released a new version of C called C 99. It adopted many features which had been implemented on C++.
About the Author
Microsoft Access Tutorial
