Creating tables, queries, reports and forms

This lesson contains instructions for using Microsoft Access 2007 Includes instructions and exercises for creating tables, queries, reports and forms.
The .zip file contains all of the documents necessary to complete the exercises outlined in the instructions.
http://support.uiwtx.edu/MediaTraining/PDF&Powerpoints/Access/ForAccess.zip

Sponsored Links:

Related Topics

Introduction, Working with Tables, Queries, Reports and Forms
Introduction (Menu bars, buttons, toolbars, moving around Access),Designing Databases, Creating Tables, Creating and Using Forms, Working with Tables
Working with Table Information (Adding, Editing, Deleting, Sorting and Finding Records), Creating Select Queries (Selecting Tables and Fields), Working with Select Queries (Adding, Deleting, Inserting and Moving Fields, Wildcard characters, Multiple Criteria), Creating and Using Reports, Enhancing Forms and Reports


Download in MS Word file format (.doc)
This tutorial has been designed to give an introduction to some of the basic features of MS Access. The tutorial will cover the following topics:
Creating a database; Creating tables; Changing the Field Properties in the tables; Adding Lookup Tables; Creating relationships; Adding Passwords to the database; Creating simple forms using the Form Wizard; Adding graphics and creating customized forms; Creating forms using multiple tables; Creating reports using the report wizard; Formatting reports; Creating Switchboards.


Recommended Method of Importing New Tables
I have a database with 2 tables that will need to be periodically refreshed with data from an MS Excel spreadsheet. There are various reports, forms, and queries that are currently using data from these tables.

My thought was to import the new tables and have a macro delete the old version of each table and then rename the newly imported table to the same name. The macroworks, but it appears the queries and forms "break" when the original table is deleted.

Is there a way to preserve the reports, forms, and queries and still import new tables using the same names?


Splitting DB; Keeping the Forms, Queries, Reports in BE
I am about to split the database I deployed recently. I was wondering if I could still keep the forms, queries, and reports in the back-end database, even if users will open these objects in the front-end.

Will my decision cause any troubles in the future? It is easier for me to update all the tables, queries, forms, and reports if the DB is just a single file, rather than if the DB is already split.


Splitting DB; Keeping the Forms, Queries, Reports in BE
I am about to split the database I deployed recently. I was wondering if I could still keep the forms, queries, and reports in the back-end database, even if users will open these objects in the front-end.

Will my decision cause any troubles in the future? It is easier for me to update all the tables, queries, forms, and reports if the DB is just a single file, rather than if the DB is already split.

Hope to get a reply.


Write, Update and Deleting Reports
Reports are printed documents showing information from the database. Like forms, reports can be based on tables or queries. However, unlike forms, reports are for output only. Obviously, since they are output to the printer, reports cannot accept input from the user.


update Access software not data
I have created a small, 5-table Access database for a community center; 10-15 forms and queries, 2 reports, 5 tables. I want to deliver updates to the forms, queries, and reports, BUT NOT THE TABLES, now that I have delivered the software to the user.

If I try to save off the tables, update the whole database, then copy the tables back, Access won't let me due to the relationships that I established. how can I do this?


What are these objects? (Tables, Queries, Forms)
When you create a database, Access offers you Tables, Queries, Forms, Reports, Macros, and Modules. Here's a quick overview of what these are and when to use them.


Forms and Reports
Just wanted to ask what's best:
Forms for tables
Reports for queries
OR
Reports for tables
Forms for queries


Microsoft Access Tutorial
Article Index: Queries, Creating A Database, Tables, Queries, Forms, Reports, Data Access Pages, Controlling The User's Input, Subdatasheets,
Designing Forms, Exploring And Analyzing Data, Tables Looks, Design And Exploration, Forms Design Propertie, Controlling Data Output, Controls,
Design And Improvements, Importing And Exporting Data, Macros, Switchboards


Ensuring Everything Works...?
I am nearly finished creating my first database and I not feeling 100% about it. It is not a database I will be using, so I am afraid some forms, reports, etc. may stop working. I have a number of tables, queries, and forms. I did manage to get everything to link, but I think I may have too many tables and forms. Are there ways to find out whether everything is put together properly other than trial and error? Silly question I know, but I don't want to hand it off when I feel it may not be completely ready


Access Tutorial : dealing with Tables, Queries, Forms and Reports.
We'll use Microsoft Access 2000, one of the major microcomputer-based DBMSs on the market. We will only scratch the surface of what Access can do, but hopefully this tutorial will whet your appetite to learn more about it or another DBMS. We will be dealing only with Tables, Queries, Forms and Reports.


Creating and Running a Report
Reports are similar to queries in that they retrieve data from one or more tables and display the records. Unlike queries, however, reports add formatting to the output including fonts, colors, backgrounds and other features. Reports are often printed out on paper rather than just viewed on the screen. In this section, we cover how to create simple reports using the Report wizard.


Microsoft Access 2003 (comprehenisve)
A complete tutorial on Access 2003. It includes 12 units which includes reports, forms, action queries, crosstab queries, summary queries, relationships, creating and modification of data tables, and more.


Microsoft Access 2000
Quick Start - Tables and Forms; Introduction to Queries; Parameter Queries; Introduction to Reports; Exporting from a Report to Word; Merging Access Data with Word Documents; Calculations using Field Data; Creating Field Totals (Avg, Sum, etc); Queries Based on Fields; Defining Relationships Between Tables; Setting Relationships Between Existing Tables; Compacting your Database


access 2007 queries & report forms
I am new to working with access 2007, but I do have experience working sql and report generation tools. My general question is I have an access 2007 database that I need to update tables and run some reports.
Thus, can you tell me:
1. Is there like a databsae schema that I can look at to see how all the tables are related to each other? If so, can you tell me how to see these tables?
2. Is there a way for me to what queries, forms, etc. are used to run some reports


connecting forms to queries
and I've been asked to analyze the structure of a database. In the Access Objects pane, I have a list of tables, queries, forms, reports, and one macro. I would like to know how to figure out which forms are connected to which queries. I figure that when the user hits submit on a form, it must execute some query which places the data filled into the form into a table. Is this right


Create Tables In Access 2010 Using SQL Commands
Access provide many ways to create tables and queries.Through SQL commands, you can also create tables, queries, forms, and reports. SQL stands for Structured Query Language which is being used extensively for creating, handling and manipulating RDBMS structure. Its syntax is very easy to comprehend but becomes complex when you need to handle colossal database. In this post we will be creating a simple query with SQL commands, which eventually creates a simple table.


2010 and 2007 Access Queries, Forms & Reports
I'm putting together a church membership database. The Access version on the computer at church is 2007. The one I have at home is 2010. The design of the tables are finished, and the church secretary has already started inputting data, while I'm working on queries, forms and reports.

I know not to upload a copy of my trial table into what she's doing, but how can I copy and paste queries, forms and reports onto a DVD and upload them into her version? Access shows "save database" and "save object".

Are queries, forms and reports considered objects, or should I simply use copy and paste from a DVD? This is my first attempt at using MS Access.


2010 and 2007 Access Queries, Forms & Reports
I'm putting together a church membership database. The Access version on the computer at church is 2007. The one I have at home is 2010. The design of the tables are finished, and the church secretary has already started inputting data, while I'm working on queries, forms and reports. I know not to upload a copy of my trial table into what she's doing, but how can I copy and paste queries, forms and reports onto a DVD and upload them into her version? Access shows "save database" and "save object". Are queries, forms and reports considered objects, or should I simply use copy and paste from a DVD? Thanks in advance. This is my first attempt at using MS Access.