Access 2000

What is a database? Database basics Database tables, records and fields Data types Primary key field Creating a database Adding objects to your database Creating a table Setting field properties and setting the key Saving a table Modifying table structures Adding and deleting fields Resizing and re-arranging fields Datasheet view Entering and displaying data Entering table data Formatting data Editing data Navigating large tables Simple printing Using forms to enter and edit data Navigating forms Editing forms Retrieving data using data filters Filter by selection Filter by form Queries Query design view Creating a query Working with complex queries Reports AutoReports Report wizards Grouping report summaries Sort and summary order Report layout and style	Tutorials & resources
	Bay City Public Schools Tutorials that are really for the ultimate newbie to Access.
	FunctionX "We have also included the sample databases that shipped with Microsoft Access 97 but that were not found in MS Access 2000". Highly recommended.
	Florida Gulf Coast University "An innovator in providing distance learning degrees" brings you free Access tutorials.
	Microsoft Download a free 14 page tutorial, instructor presentation and lab file
	The Access Web API's, bugs, date/time, forms, general, modules, queries, reports, resources, strings and tables
	.
	Hints and Tips
	Resources for Microsoft Access Hints, tips, tables, queries and How to accomplish a task. Highly recommended.
	Dell Hints and tips sorted by category. Nice! Also features a How to section
	Granite Consulting Microsoft Access Add-in Tips, Hints and Gotchas
	.
	Bugs in Access
	Granite Consulting
	Granite Consulting: Conversion issues
	Hammerdata
	.
	Need to Know
	The 10 commandments of Microsoft Access

A database is an organised collection of related data that you can easily retrieve and use. A database management system is a program, like Access, that enables you to create, organise and manage your data stored in databases.

A database consists of tables, records and fields. Microsoft Access is a relational database which means it relates data from multiple tables instead of requiring you to duplicate data in more than one location. Microsoft Access database files end with a .mdb extension which you can double-click to open.

A table is a collection of data about a specific topic, much like a file folder in a filing cabinet. Your filing cabinet can contain many folders, likewise a database can contain many tables.

Fields in the database must be assigned a data type. Every item within a field must be of the same data type. A table can contain many data types:

Text	Consists of letters, numbers and special characters. Cannot be used to do calculations.
Memo	Can hold extremely large amount of text, including paragraphs
Number	Holds numbers and values in this field are used for calculations
Date/Time	Hold date and time values in various formats
Currency	Holds a currency symbol and keeps amounts rounded to the proper decimal value
AutoNumber	Holds sequential numbers - each record in the table will be given a different number that follows on the previous number, e.g. the Account Nr field in the above image.
Yes/No	Holds a Yes or No value and is usually a field that asks a question, such as Account Settled?
OLE object	Holds an embedded object which refers to objects from another program that you can insert into your database, e.g. a graph you created in Excel or a flowchart you created in Visio.
Hyperlink	Holds a link to a website or a file on a network

A Primary key field uniquely identifies a record. This is a field that contains no duplicate entries. You can assign a field as the primary key field or you can use the AutoNumber field as the primary key field.