Basic_Concepts_Databases_3rd_Part

Basic_Concepts_Databases_3rd_Part - Databases Using MS...

Info iconThis preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
Virginia Tech (copyright A.A. Trani) Databases Using MS Access Part III Drs. A. A. Trani and D. Gallagher Dept. of Civil and Environmental Engineering
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani) Importing Data into Access l Can import data from many sources (like Excel or text files)
Background image of page 2
Virginia Tech (copyright A.A. Trani) Importing Data into Access l As you import data, you can specify the data types for each field of the data to import
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani) Importing Data into Access l Selecting the Primary Key of the data (I am letting Access define a new column for me)
Background image of page 4
Virginia Tech (copyright A.A. Trani) Importing Data into Access l Imported Virginia Airports Excel file Design View Data View
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani) Importing the Runways Excel File l Import a second file containing runways at the Virginia Airports Data View
Background image of page 6
Virginia Tech (copyright A.A. Trani) Imported Runway File l Imported Virginia Airports Runway Excel file Design View Data View
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani) Exporting Data Out of Access l Once we have done wonderful things we our database, we need to produce useful reports or perhaps export data to other applications such as at Matlab, Excel or JMP (a Statistical software) l The choices to produce data out are: l Access reports l Access export data capability
Background image of page 8
Virginia Tech (copyright A.A. Trani) Access Reports Useful to print hard copies of your database elements Can generate professional-looking reports for printing Can be used to communicate with other non- Access users Can be used to debug or validate your database 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani) Access Reports - The Basics Useful to print hard copies of your database elements Can generate professional-looking reports for printing Can be used to communicate with other non- Access users Can be used to debug or validate your database Reports are Access objects and they can be customized 10
Background image of page 10
Virginia Tech (copyright A.A. Trani) Access provides ready-made formats to produce a simple one click report This is simple but lacks customization 11 1. Create Tab 2. Report Icon Access Reports - One Click Report
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Virginia Tech (copyright A.A. Trani)
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 44

Basic_Concepts_Databases_3rd_Part - Databases Using MS...

This preview shows document pages 1 - 13. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online