click to enlarge
Database tables are the basic structural elements of any database. Get online help in creating tables from:
Microsoft Access Online: Create a Table. Learn how to create a table, add fields to a table, and how to set a table’s primary key as well as field and table properties.
Creating Microsoft Access Tables. This is lesson 2 of Denise Etheridge's Microsoft Access tutorial.
Working with Forms
click to enlarge
Forms are user-friendly database objects that help us enter, change and view the data in our tables. Try these links for a quick walkthrough:
Microsoft Office on Line: Create a Form by Using a Form Wizard
Create a Form by Using a Blank form
Creating Microsoft Access Forms - This is Lesson 6 to o Denise Etheridge's Access Tutorial.
click to enlarge
Add queries to your toolkit of MS Access 2007 database management. Here are some resources for database query tutorials:
From Microsoft Office Online:
Introduction to Queries
Select Data by Using a Query
Run a Query
Watch this: Make a query ask for input
Creating Microsoft Access Queries - This is Lesson 5 to Denise Etheridge's Access Tutorial.
Creating and Viewing Database Reports
MS Access 2007 has streamlined its reports creating engine. Its new Layout view takes much of the previous clunky interface out of creating reports. From creating a simple report to extensive manipulation of the report layout, these online links are very helpful indeed.
From Microsoft Office Online:
Create a Simple Report - This tutorial shows a variety of ways to create a simple report in Microsoft Access 2007. The new user will find a wealth of information and instruction in this tutorial.
YouTube: Access 2007 Demo - Use Control Layouts on Forms and Report. Take a look at this video to get an idea of the new report layout interface in MS Access 2007.
click to enlarge
