Topics Search

Creating tables, queries, reports and forms

Creating tables, queries, reports and forms
Views: 100
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:

More topics

 

Introduction, Working with Tables, Queries, Reports and Forms

Preview
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
 

Recommended Method of Importing New Tables

Preview
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?
 

Download in MS Word file format (.doc)

Preview
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.
 

Splitting DB; Keeping the Forms, Queries, Reports in BE

Preview
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

Preview
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

Preview
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

Preview
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)

Preview
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

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

Microsoft Access Tutorial

Preview
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