How Is Data Retrieved From a Microsoft Access Database?
Finding Records in a Table
- One way to view data in Access is to open a table, which typically is where the main records in a database are stored. When the table is open, the records can be sorted, or a user can use the search-and-find function to pinpoint a particular record.
Creating a Query
- If users want to view a series of records, such as all those accounts created in September, they can create a query, which is basically a slice of a table. The query function allows users to specify keywords, a date range, location, and more.
Running a Report
- Reports are useful when data must be presented to others, such as a monthly accounts-receivable report. They can show a slice of a data table much like a query can, but can be graphically enhanced. Microsoft also offers Access report templates on its website.
Retrieving Data Programmatically
- It is also possible to retrieve data from Access programmatically, such as using Ado.net or Visual Basic .Net. Microsoft's support forum lists several articles that give step-by-step instructions.
Tags Linux Unix Apache BSD Debian Oracle Open Source Websphere Email Servers Cisco Samba BEA Weblogic technology Microsoft Access Excel ffice Powerpoint Word Oracle
Related Posts "Technology"
7/11/2019 1:30:00 PM
7/11/2019 3:27:00 AM
7/11/2019 2:21:00 AM
You might also like on "Technology"
7/8/2019 4:52:00 PM