Microsoft Access Tutorial - FunctionX - Introduction - - Creating A Database - - Tables Design - - Introduction To Microsoft Access Objects - - Controlling The User's Input - - Relationships - Subdatasheets - - Forms Design Overview - - Exploring And Analyzing Data - - Query Design And Exploration - - Forms Properties - - Calculated Fields - - Advanced Queries - - Exploring Forms Controls - - Designing And Improving A Report - - Importing From And Exporting Data To Other Applications - - Macros - - Switchboard - - Introduction to VBA - - Shortcuts - A Complete Database Created With The Keyboard - Introduction To A Microsoft Access Database 1 - Introduction: A database is a collection of information organized as to make it easy to view it, search it, retrieve the right detail, and collect the necessary facts in an easier, timely, and effortless manner as possible.
Microsoft Access Tutorial - FunctionX An organized database is composed of inter-related parts. Since you define these parts, you also organize them in a manner that helps some parts of your database to supply specific information to others. In one part, you would cover one category of data, such as people's personal information (name, date of birth, salary, hobbies, etc), in another you would cover what they buy in a store.
Microsoft Access Tutorial - FunctionX A column is a field representing one particular category of information about the records in the table. For example, it would hold the names of all actors in a particular movie, another column would hold the titles of different movies in the video store.
Microsoft Access Tutorial - FunctionX A form can combine data that is part of one or more tables or queries. Forms are the window interfaces that you usually will ask your users will access when editing data in your database.
Microsoft Access Tutorial - FunctionX Modules: Modules are pieces of code used to impose particular behaviors to your application to make it better. They are written in Microsoft Visual Basic. Modules are more flexible and extensive than macros, although they are usually written for various and particular circumstances. One example is to print a receipt after a customer has bought paint in a store.
Microsoft Access Tutorial - FunctionX 2 - Creating a Database from a Template: Microsoft Access ships with a few sample databases that you can use or learn from (don't hold this against me but this is an area where MS Access 97 is better than MS Access 2000). To experiment with one, we will create a database using one of the templates.
Microsoft Access Tutorial - FunctionX 5 - Setting Some Startup Options: To make sure that Microsoft Access always first goes to your favorite folder whenever you are creating or saving a database, you change the options in the Tools menu.
Microsoft Access Tutorial - FunctionX 4. Click the Summary property sheet. Change the summary sheet to look as follows (besides the Author and Manager, you can change any item(s) to whatever you like): 5. Explore the other property sheets and examine what they have to offer. The Statistics tab gives you statistics about your database and its summary access. The Contents tab shows a list of the components that are part of your database. The Custom tab shows, and allows you to customize, the field named associated with your database. When you have finished working with the database Properties, click OK (if you click Cancel, any change you made will be discarded).