exportdata12345asdf

Gregory Matthew

gregematthew@gmail.com

9034525758

I contacted your office earlier this week, but have not heard from anyone yet. If someone could let me know how this works, I would like to schedule a time to discuss my Access project with you. Also, I would like to find out if MS Access will work with what I am trying to do. Thank you.

1446682889.1780

Anthony

ajacomp@comcast.net

2155504306

his is what happens. Usinf Access 2003 on XP or Windows 7 it works perfect, if I add records then send the backend to Windows 8 or 10, the records do not appear, Also if I add records in Windows 8 / 10 then send to XP they do not appear. check attributes and they look good.

1446567606.7901

James Letterneau

james.letterneau@meggitt.com

949-276-0376

We have approximately 110 test reports in Microsoft Access format that need to be updated. Occasionally we'll need to update the report header/footer information on all the reports in the same way, but the current report format doesn't actually use a header/footer template. We are looking to "standardize" as much of the common information on these reports to a header/footer template, so that we can make an update in a single location and have it apply broadly.

All the reports are unique, so part of the effort will be to determine which information can be grouped into the header/footer content. We'll have at least two separate formats (one portrait, on landscape), but there may be a possibility for more as required.

Once the header/footer template is created, the next step will be to reformat the reports to look as close as possible to their current state. This will likely result in needed to shift some report fields around.

Note: Some of the reports have two or more pages.

1446474666.1817

Christopher Wallander

cwallander@saundersseismic.com

949 646 0034

Looking to improve our current, spreadsheet based, payroll reporting function for remote employees.

1446224215.0123

Mike Chavanne

mike@linenworld.com

716-972-0024

I have a very robust Access Database (that we still run in Access 2000) that I would like to review the following:

1) Updating to more current version
2) Changes to some fields & data entry points
3) Currently, have a basic ASP function, but would like it to be more robust.

Thanks
I tried to attach MDE version, but would not upload.

1446148608.6752

Marc Adler

marc.adler@itsolutions-inc.com

215-886-7166

Hello,

I have a local client (Philadelphia) in need of some tweaks to their Access database. The database manages time sheets. We are a FileMaker Pro and ASP.NET shop so don't have the necessary skills. I would like to either sub you guys or have you go direct. They have an end of November timeline for changes to an existing database. I can provide more details.


Phone Extension 119.

1446144543.0395

David Scharf

dscharf@mchsi.com

I have over 10 years of MS Access and SQL Server skills and experience. I'm interested in the possibilities of joining your team and helping clients reach their goals. I have great communication skills and look forward to hearing back from you. Thanks.

1446048651.9614

Tom Fritz

tfritz@stanjohnsonco.com

8473479988

I sell commercial real estate and would like to be able to track all properties that are bought and sold on a daily basis. I would like to be able to sort the results and then filter them. Then I would like to be able to check a box and export only the results I want to a customized report with my name and logo on it. See attached for what I drew up.

1445626092.7644

Jeffrey Merovitz

jeff@telepointcomm.com

856-627-7100

We just upgraded from Office 2003 to Office 2010. Certain programming that used the SOAP Toolkit in 2003 is not working in 2010. We need to rewrite a module that doesn't use the SOAP Toolkit. Is that something that you can do.

1445616005.4640

Gemini Kline

gkline@demcouncil.org

310-841-0643

Hi,

We'd like help with MS Access and integrating it with Outlook contacts

1445560208.9697

Alonzo Nesbit

ozzo1999@yahoo.com

803 429 0875

Summary, as requested:

Need an Access database (2010) that will allow trainers to submit "Class" information on a Form that will poplulate associated Tables (see attached database) and a Report that shows "Class" evaluation question averages per student, per question, per Class and a total average for the Class (see attached Report template). I need to scroll up and down the Form via the mouse scroll wheel (not limited to the scroll bar on the right-hand side). I also need to be able to add Courses. I would also like to be either on a call or sharing my screen during the development process to ensure the devloper and I are on the same page, as far as what is needed and how to use the database once it is developed. Sending other attachments since I only see one opportunity per Free Quote request (Browse).

1445443036.8364

Alonzo Nesbit

ozzo1999@yahoo.com

803 429 0875

Summary, as requested:

Need an Access database (2010) that will allow trainers to submit "Class" information on a Form that will poplulate associated Tables (see attached database) and a Report that shows "Class" evaluation question averages per student, per question, per Class and a total average for the Class (see attached Report template). I need to scroll up and down the Form via the mouse scroll wheel (not limited to the scroll bar on the right-hand side). I also need to be able to add Courses. I would also like to be either on a call or sharing my screen during the development process to ensure the devloper and I are on the same page, as far as what is needed and how to use the database once it is developed. Sending other attachments since I only see one opportunity per Free Quote request (Browse).

1445441306.9451

Alonzo Nesbit

ozzo1999@yahoo.com

803 429 0875

Summary, as requested:

Need an Access database (2010) that will allow trainers to submit "Class" information on a Form that will poplulate associated Tables (see attached database) and a Report that shows "Class" evaluation question averages per student, per question, per Class and a total average for the Class (see attached Report template). I need to scroll up and down the Form via the mouse scroll wheel (not limited to the scroll bar on the right-hand side). I also need to be able to add Courses. I would also like to be either on a call or sharing my screen during the development process to ensure the devloper and I are on the same page, as far as what is needed and how to use the database once it is developed. Sending other attachments since I only see one opportunity per Free Quote request (Browse).

Thank you!

1445441248.5209

Alonzo Nesbit

ozzo1999@yahoo.com

803 429 0875

Need a Training database to house Courses, Classes, Instructors and Training Evals for classes. Already have tables setup but cannot get form to enter data to work properly or get Eval rating averages and total averages. Need help sooner rather than later. Would prefer sharing screen and working with consultant.

Thank you!

1445431442.6439

Phyllis Thomas

thomaspa@njms.rutgers.edu

973- 972-6886

I would like to know if you can help me with a (ELMS) Employee Leave Monitoring System database in Access. I have the database on my computer, but it is from 2013.

Thank you,
Phyllis Thomas

1445010988.8573

Ryan Zilker

ryan.zilker@co-opfs.org

909-786-3482

We need help building a product launch tracking system.

1444862438.4162

Pam Pavela

pampavela@outlook.com

951 847-4459

Hi Mike, Here is my ACCESS database I was telling you about. It is for a silent auction that is happening tomorrow.
Problems: I can't get relationships to work. The Donors, Bidders, and Categories tables should be a one-to-many relationship with the Items table with referential integrity. I think this lack of relationships are throwing everything else off. I can't open my Bid Sheet unless I go in via design view. I was having problems with the way the Donor table was acting, so I removed the Donner field from the Bidder Sheet. I have now placed it back on the Bidder Sheet, but know it may not be correct - I just wanted you to see where it goes. None of my reports work except for the Alpha Item List and Items by Display Number. However, when I enter a display number in the Items by Display Number table, it does not show up in the report.
If you think you can resolve my problem within a couple of hours, great. Otherwise, I may have to start all over because I need to print bid sheets by noon. Thank you!!!

1444411008.5122

Key DePonte

key@bnfhomeinc.com

9093908188

We would like to create something like Order hive - orderhive.com

1444169074.7402

Phillip Steel

voteforgunrights@yahoo.com

720-333-6338

I upgrded to access 2016 and now my company logo does not appear on my reports in print preview. What is wrong?

1444082687.5476

Jerry Weinstein

jerryw@ceramaterials.com

518-701-6722

I hope this finds you well.

I am looking for a quote & guidance for our company in handling our customer data & orders through Access.

Our main goal is to capture every customer to be able to quickly find their orders and autogenerate an Invoice, PO and packing lists. Then down the road have something that would interface with webstore, Amazon & Ebay orders, etc--capturing every customer, knowing how much they ordered, etc

So it is most important to capture customers & create invoices and po processing.

Creating & maintaining skus are a secondary item. We have around 50% of what we sell stock & 50% specialty made to order.

We wanted some options on how to approach this and if possible, pricing for setting this up.

We are currently at 1500 orders per year—which is about 125 invoices & 180 PO's & packing lists per month. 20-50 core customers and the rest new & smaller customers.

We are currently using an Excel based spread sheet with excel based Invoice, PO & packing list forms.



Here are additional items that we would like:

1) Want a master spreadsheet to account for

Date of order
Date of billing
Date of payment
Invoice #
Customer name, company name, address, phone, email
Customer where to send invoice (email or mail address)
Third party shipping name & address (must be an option)
Customer purchase order #
Customer payment method (credit card, N30, N45, etc.)
Our purchase order #'s (up to 4 PO's per invoice) for our suppliers (drop shipping)
Supplier name, company name, address, phone, email
Packing lists (up to 4 per invoice)- no supplier names or costs listed. For supplier to use in blind shipping.
Supplier name, address, contact person, phone #, email
Item quantity
Item cost
Item total cost per line item (unit cost x quantity)
Promised delivery date (or # weeks for delivery)
Special instructions for each purchase order
Item price
Item total price per line item (unit price x quantity)
Gross profit (Total price - total cost per line item)
Shipping cost
Shipping price
Shipping profit
How shipping & company used (UPS, Fed Ex, truck, etc) (optional)
Tracking or pro # of the shipments (optional)
Bank fees or other fees
Commisions for 8 reps (10% of item total price per line item) (subtracted from total)
Total line item profit
Notes on order-


Note that currently, our master spreadsheet, all invoices, PO's & packing lists are Excel based forms. However, the data from the spreadsheet does not transpose onto the invoices & PO's. We need to retype all the info 2 to 3 times.

After entering (or calling up from memory) all the above line items on the spreadsheet, then it would be ideal to have the following done:

2) Invoices created for that customer with all line items & prices- invoice must be available for changing. Any third party shipping our customers want must be added somewhere on the invoice. This happens often, especially with reps.

3) Purchase orders for each supplier created with costs & how to pay the supplier- PO's must be available for changing for special instructions.

4) Packing lists created for each supplier with no costs or supplier names on this form & how we are paid by the customer- packing lists available for changing.

5) Invoices, packing lists & PO's automatically converted to PDF's and stored when all data is completed.

6) Ability to search past orders & company information & have it come up as a list- we can do this now with Excel.

7) Readily useable sales and marketing data for trends, e-mail campaigns, sales catalog/cards/flyers, dormant customer analysis, and calling campaigns

8) Improved customer care/shipment tracking/responsiveness / follow up- built in calander notifying when an order is late for shipping by a supplier or late for payment to us by a customer.

9) Interfacing with web store fronts such as ebay, amazon and alibaba- this is secondary step.

10) Ideally, all data stored on Google or cloud for access by up to 5 computers simultaneously in real time. We are doing this now on Google for free with the excel files.

11) Phone interface (Vonage) would be nice so make calls from data base memory

12) Accounting and taxation for each transaction. Right now, we do not account for taxes anywhere.


This is a starting point.

As discussed, total orders per year around 1500, going up around 30% per year projection.


Please call to discuss.


Thanks,



Jerry Weinstein



CeraMaterials

226 Route 209

Port Jervis, NY 12771

(518) 701-6722 Main

(845) 293-9067 Cell

(718) 569-6475 Fax


www.ceramaterials.com

1444080063.0950

Sr. Richard Carmel

smrc@stmhcs.org

518-537-5000

Hi,
I have a MS Access 2010 Database which I have used for several years. I need to create an append query that will move records of Sisters who have died from one table to another table. I have been able to do this find up until recently when I had to add a Mission History Table and related subform to my original table of Sisters. Is there someone who can come to my workplace and assist me with this. It will involve creating an append query that will move all the records from one table to another. Please contact me as soon as possible. Thank you. Sr. Richard Carmel, St. Teresa's Motherhouse 600 Woods Road, Germantown, NY 12526

1443813745.4934

Robert Wilken

rwfundsloans@gmail.com

619-890-9825

I need help getting my data base to work properly, I have 2 customized templates one for investors and one for borrowers with multiple tables I need to relate to each other.

What would it cost to get the 2 template working correctly?

1443733939.6512

Ronald Dyson

rdyson1005@gmail.com

603-898-9429

Cannot save the current record in an access form. I used to use DoCmd RunCommand Saverecord which no longer exists.. Now I use "Me.Dirty = False" but I'm getting an error.

1443731958.5541

Zella Jones

zella@marketxmarket.com

917-686-8385

I have a client with a terrible database. What we need is a good Access set-up that can be accessed remotely by key personnel. I can provide the necessary fields and breakdowns. Will need to export to List serve and then update periodically.

Client can do input of cleaned up list, what we need is the right set-up. Need a quote or perhaps a conversation.

1443558660.1370

Gary

gshurland@miirckoconnell.com

7742426255

Need help ASAP in moving access database with several tables being used in different word 2010 mail merge documents. Database has to be moved to another path but link is broken when moved.
Thanks

1443537049.1506

Jim Swett

jim@printsourceny.com

518-899-5070

Please take a look at the attached PDF identifying bugs that I need fixed in my ACcess program.

1443185148.1991

Michael Stafford

MichaelLStafford@msn.com

412 735 3709

Michael Stafford
113 Tree Farm Road
Pittsburgh, PA 15238
September 21, 2015



Human Resource Representative,


I am looking for either a full time or contract position as a Microsoft Access Database Developer. After graduation from the University of Pittsburgh, I worked as a Microsoft Access Developer for almost five years at Highmark Health Services. At Highmark I primarily used VBA and SQL. I then studied Oracle Database Design at Kaplan University. I studied topics such as Stored Procedures, Functions, Triggers, and Packages in PL/SQL and T-SQL. I am dedicated, hardworking, and very reliable. I look forward to talking to you about employment.

Sincerely,


Michael Stafford

412 735 3709
MichaelLStafford@msn.com

1442872353.1146

Tina Cassidy

tina.cassidy@protherainc.com

775-850-8800

Would like a free quote to create an access database to do Tag inventory. Please see attached requirements.

1442608821.3703

Lady Tinor

ltinor@cobalt-group.ca

250-301-5239

I am in the process of developing a database and would like your help to ensure data normalization and assist with developing the forms; as well as setting up some user rights.

So far, I have designed the tables and assigned the relationships - which I have attached to this email.

Please contact me at your earliest convenience to discuss the details of this projects.

Thanks,

Lady Tinor
Business Systems Analyst
Cobalt Group
250-301-5239
ltinor@cobalt-group.ca

1442607399.9014

Damon Jackson

damon.jackson1@mdlz.com

4196976601

Would like to speak with a programmer about making modifications to an access database.

1442584706.9724

Martin Ende

mjende@express-scripts.com

314-522-5877

Need quote

1442500146.0209

Bill Cunliffe

bcunliffe@elevationllc.net

7048772732

I have a small database that needs creating. It is used to track a pipeline of deals that a team of analysts are covering. I'd be interested in learning more about your services.

1442495412.0916

Kristofer Olafsson

kolafsson@radwell.com

6092889393

Access 2003 file that need to be upgraded to 2010. It also does not compile anymore, it's been modified from a 97 version years ago. The file is a single file with linked tables on a SQL server. the file itself is around 700mb. Maybe discuss converting some pages or functions to webpages if possible?

1442425929.6955

Wayne Nowland

wnowland@bradley-parker.com

631-650-4007

We have a old version of an Access that needs some changes and updating and the original programmer is no longer available.

1442413408.4789

Anthony Frankina

anthony.frankina@esterline.com

661 775-1144

we have a rudimentary database but does not have reporting, search, tasks or communication we need

1442405162.7533

Gina Roper

gmr59.consult@gmail.com

I have several years of experiencing developing databases utilizing MS Access and VBA as well as SQL.

How can I become a consultant for your company?

Thanks,

Gina Roper

1442382603.1251

Payne McIntosh

Payne5@aol.com

5617982566

I have a program designed in Access 2007 on an Microsoft XP operating system. I've encountered a Runtime Error 6 Overflow when trying to print a report. We've used this program for 15+ years and are having this problem for the first time. The man who designed it for us has since passed away. Is this a problem you may be able to help with.

1442343597.5928

Jeremy Powell

jeremy.powell@martinmarietta.com

2142078326

This is the backend portion of the previous message. Both attachments have been renamed from .mdb to .txt to avoid attachment blocking.

1442245032.0234

Jeremy Powell

jeremy.powell@martinmarietta.com

2142078326

Hello,

I have an older version of an MS Access application that I'd like to convert to the latest version. I've attached the front end. There is also a backend.

Thank you,

Jeremy

1442244941.1268

Alejandro Gomez

AGOMEZ@UOTTAWA.CA

6135625800

Hello,
I need a basic system to track information from 4 sources (cls lists), with alarms, dates for deadlines, dates for specific tasks and equipment loan (check in - check out). I had a student develop something in Access that is full of bugs and it is driving me crazy!
Please let me know if Access is the tool I need and how much it costs to develop something like this.
Thank you,
Alejandro

1442241741.5699

Matthew Giardina

matthew@giardian.net

832-302-8538

I am creating an Access Database for my company and need some help finishing a couple of forms.

1442089267.5182

Michael Dailey

mdailey@craftaframe.com

360-718-2586

I am trying to link a database on Google Drive to my Access 2002 program. I successfully link to all of the files in the database but when I open a table (any table) I get the message ODBC failed. Can you fix? How much?

1441991871.9886

Tessa Peshek

tpeshek@promisehabitat.com

352-551-0481

We have an asset tracking database program in Access and we need to enter current maintenance information into our forms for each piece of equipment we own. However, after 8 records (forms), the lines (grid-like) are not appearing in the maintenance work area window on the form, and the information is not syncing up when entered into the maintenance table or main asset table. Do you have an idea how to make those grid lines appear so that we can continue to update our data?

It may help for you to know that when we started with our Access program the form template that was already programmed only contained examples of data through 7 forms.

Also, I had a question about the "relationships" between fields on the Access program and why it will not let me delete certain fields that came with the original form template? An error message pops up saying that we need to remove the field from its relationship with other fields before we can delete that column.

And lastly, is there a way to delete a primary key or is it forever permanent?

1441898413.9640

gabriele

gabext2@yahoo.com

(941)380-9255

I saw a sample template that I think would work for our business- Marine Construction. But need to be able to modify the amount of text that can be put into the quotes and invoices. Also would like to be able to adjust the customer page and add fields.
Lastly, if there was a way to input job information into quickbooks that would be cool too.
I created a database over 14 years ago with lotus and it is still working. We run all our contracts and customers on it. But I dont think it will last much longer and looking for a replacement. Can send you pics of my database and the sample access I was looking at.

1441722217.4054

Steve Imhoff

contact@ncontroldriving.com

480-857-3055

Hi,

I just emailed and wanted to let you know our availability.
We will be happy to speak to you tomorrow, 9/4/15. You may ask for Monica if I am not available.
Thank you.
Steve

1441324313.2357

Steve Imhoff

contact@ncontroldriving.com

480-857-3055

Hi,

We have an MS Access program that was built for us in 2012. It has the capability to perform our daily duties for our small driving school from sending courtesy reminders, confirmations, reports. We need help to update the program and fixing a glitches.
Thank you. I will look forward to hearing from you.

Steve Imhoff

1441323448.1265

Shawn Yates

shawn@msofficeexperts.com

801-806-0730

test

1441123301.4614

Jithin Mathew

jithin@izource.com

Final Test.: Shawn let me know if this is coming correctly 🙂

1441123203.8992

Jithin Mathew

jithin@Izource.com

Again testing

1441122984.7077

jithin mathew

jithin@izource.com

test

1441122844.3967

Jithin

jithin@izource.com

testing

1441122714.7892

Mohamed ali

mali@formnetinc.net

I would like a customer database similar to the example on the website. I would like for it to have the following:

1. CRM component where I can put customer details that we do business with
2. New quote entry, status, update (linked to customer table)
3. Input part details into different groups of parts (i.e. pin, axle, sleeve and components - 4 groups' total)

This relational database will be able to help our small company quote products.
It will use simple part characteristics to call out a list of parts we have that match the dimensions (part OD, ID, length, thickness, material, etc.)

1441120531.6890

ANGIE

ABROWNMILLER@SCHUSTERCO.COM

7125465124

I built an Access Web app. Entries and parameter queries work great BUT I've added the query as a view so the end user can run on own and download info as needed. When I launch the app and sign on as end user it doesn't prompt the user to enter parameters and the query fails.

Does Web App support this? Have tried a few macros, but still failed - "parameters not supplied..."

1440704298.5184

Kalli Anderson

kanderson@bdclabs.com

303-456-4665

We are looking for a quote for a custom database to run our day to day operations, please call for more information.

1440624277.5702

Amy Morris

amy@cr-industriesinc.com

303-296-6612

I'm looking for someone to answer Access questions. An Example is that i hired someone to do a database for me. She uses PC but i use a Mac so i have to use it thru Paralles. When i downloaded the database, each page is so big i can't see it and i can't not figure out how to zoom down. Also it has forms and subforms and the subforms page is only showing the table not the actual form. When i go to design view i can see what it should look like. I'm not sure how to switch it over. So i'm looking to get questions like this answered ASAP, and i'll probably have many of them, and then maybe be billed monthly. I guess i might need someone that is familiar with a Mac as well. Is this something that you could do for me?

1440603178.0419

Anacris Quezada

anacris_quezada@mikenconstruction.com

909-256-8000

We had a custom database created that works directly with QB to manage our collections/receivables. We recently had to create a new QB file and upgrade to the 2015 version which caused errors with the access database. I am looking for a quote to repair the current program or a quote to create a new one similar or better than what we were using.

1440542783.4786

Gary Polinsky

gpolinsky@prismmedicalltd.com

4123379439

Hello,

I want help with a commissions database I have developed. My two main challenges are:
1) Automate the refresh of linked tables. I want to pass a month and year parameter to a stored procedure in a SQL Server database.
2) Improve the performance of reports. A key report is about 175 pages and takes 15-20 minutes to run. I want to modify the design, indexes or use other methods to reduce the report run time.

Gary

1440465262.4545

Nancy T Horner

nancy@waterfrontmanagementgroup.com

501-622-9191 501-525-5822

spoke to Mike - Attention: Mike

1440450260.4264

Gregg M. Bainbridge

gregg.bainbridge@xerox.com

585-231-8893

Regarding Access 2010

bar code 3 of 9 does not seem to work at all?

This is a win7 operating system issue, Had no issues when the operating system was XP.

I think this is an Access problem as I did a bar code serial number in NOTE PAD, printed and it scanned. Did the same thing from Access, and it will not scan?

I need to get the Win7 Access to work with the bar code to meet the companies software requirements as XP is not supported any longer. Be nice if there is a software upgrade that I can down load. Thank you..

1440427023.8005

Dave Camilleri

camillerid@lpp-inc.com

810-667-4240

We need an access database built for our company. Please call to discuss.

810-667-4240 X 1592

1440004291.7396

Mandy Habermehl

mandy.habermehl@sunlife.com

Hello
Im looking to have a customizable form to work within Sharepoint 2010 for our Department. This form would need work with Sharepoint, and be able to be created by one user, and be able to be edited by that person, as well as others (they collaborate on each form)

The reason I wanted to use Microsoft access was because I need to have a Parent/child form relationship, and tab style view to keep replicated information tidy.

I have attached the form that we created in Sharepoint so you can see what Im trying to do - the problem with this form is that it is super clunky, only allows us to put in 15 tactic sections (they all repeat), and is not able to spit out a PDF or word document of the information once in.

Our timeline is very aggressive, and we need this form a week ago 🙂 We would require someone to be able to provide this to us with a very quick turn around. All the information, and fields and information in those fields seen on the PDF is ready to go.

Please let me know if something like this is possible, and what an estimate of costs would be as well as a delivery date.
thank you

Mandy Habermehl

1439836354.5871

Ryan Corbet

ryan.r.corbet@bankofamerica.com

404-501-2053

Hello,

I work as a Senior Quality Analyst for Bank of America Collections Services. I am interested in finding a company that can provide Microsoft Access classes on site to a group of 10-15 people. The initial classes would be entry level. Are these the type of services your company could provide?

I'm looking for a course of this nature

Course Content

Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help in Microsoft Access

Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic C: Create Lookups

Lesson 3: Querying a Database
Topic A: Join Data from Different Tables in a Query
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query

Lesson 4: Designing Forms
Topic A: Create a Form
Topic B: Modify the Design of a Form
Topic C: View and Edit Data Using an Access Form

Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print

Lesson 6: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships

Lesson 7: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Create Action Queries
Topic C: Create Unmatched and Duplicate Queries
Topic D: Summarize Data

Lesson 8: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge
View outline in Word

1439585705.2109

Russell Duncan

vipmovie@aol.com

972-333-7470

Interested in bringing my Access 2003 applications up to date and making some modifications to the application to reflect changes in my market.

Not sure where to start or if you are the right people but I'm starting with you.

Need some input from you as to the next steps.

1439584521.8772

Craig Reisinger

creisinger@telltek.com

303 726-4603

I will receive csv files from my customers that I will need to pull into tables from which queries can be run. Tables will have compound keys of 2 or 3 fields. I do not think I will need more than 5 or 6 tables each of which will contain an estimated 50 fields (these are ballpark numbers).

I would like to know if I can work with your team to determine the most efficient table structures and keys, normalization of the data, develop the queries, and probably have you design forms for table updates.

Sample table (fields only) structures attached. This is very basic data, table, and query activities. Can you estimate how long it would take to develop these tables with the most effective key structure, create the table maintenance forms, and provide basic queries filtering on 2 or 3 fields?

Thank you.

1439520417.0533

Bob Boice

bboice@henneman.com

217-359-1514

Hello,

We are in need of a Microsoft Access resource to help us update a report and potentially fix what appears to be some minor issues in an existing Access database. We are hoping to find someone who can start immediately and possibly complete the work by mid next week. Is this something your company may be able to assist with?

Thank you.

1439475179.4009

Test EAC

test@test.com

Test from Contact Us

1439460576.7819

Test EAC

test@test.com

Test From Main RAQ Form

1439460510.9453

JIthin

jithin.mathew@oscillateinfo.co.in

9910995775

RAQ testing message

1439411880.8889

Kilie Erickson

kiliee@ptsworldwide.net

815-498-1930

I am looking for a small custom database that is web based and can have multiple users. I need help with the set up and the conversion on what is now being held in excel.

1439240084.3172

Steve Fetters

sfetters@accu.com

614-568-2107

Here is a design document for the possible development project that one of our clients has asked us to develop. The client is in need of getting this turned around quickly so how soon can you get us an estimate?

Thanks,
Steve

Steve Fetters
Director of Business Consulting
AccuNet, Inc.
Office Direct: 614.568.2107 |Main: 614.899.9900 | Cell: 614.867.6086
sfetters@accu.com | www.accu.com

1438956431.4795

Danielle Cannella

danielle_cannella@pall.com

Hello,

I am based in Michigan City, Indiana at a manufacturing plant. I am looking to complete a shared and secure Access database for data entry as well as extraction.

Kind regards,

Danielle

1438883949.4701

Tony DiBlasi

tdiblasi@occh.org

(614) 224-8446

Seeking a vendor to assist with the development of an Access database to inventory building components / track warranty info / predict useful life of these components / generate some simple reports. Can explain in more detail when we talk. We do have an outline of a requirements document to facilitate the development process, but have a limited budget. Let's talk as soon as possible! Thanks.

1438879516.4581

Kim Hafermalz

director@lapinecommunitykitchen.org

541-536-1312

Attn Mike:

I would like a free quote on developing a database for our nonprofit in Central Oregon.

It was good to talk to you this afternoon.

Warmest regards,

Kim Hafermalz

1438726929.7120

Maan Kheirbeik

askmaan@gmail.com

Programmer Analyst search job in programming

1438652827.5506

Frederick Doxbeck

fdoxbeck@gmail.com

716-696-0556

we have forms on excell used in our company and i want to get them into access and shared on a common drive so that multiple people can get at them and update them. We have IT that can get them on the server but we dont have anyone that knows access, can you help?

Fred

1438369807.1765

kevin

kevin@westernquality.ca

7807205162

hi there. we have an online database we have been using for our company for over 10 yrs now and are looking for support for updates and also programming, we currently have an inhouse programmer who has been with us long term but we need support for him as well.

1438276901.7767

John Gajdecki

jgajdecki@gmail.com

778 838 8003

Attention MIKE : Following up on our phone call of Wednesday, July 29 2015.


Usual number of users.

10 users in 1 location
50 users in 4 locations
500 users in 10 locations



Can we have multiple front ends to a single set of tables in SharePoint.

- make it 100 % impossible for artists to see budgets
- artist interface can be dark, co ordinators can be light
- build individual apps to handle small parts of the entire database



- responsive site possible - .net program



Can a schedule table in AOS drive a calendar that is outside



Can we prevent users from downloading the Access database file from Sharepoint



What cool functions in SharePoint an we incorporate into the user experience -

- link access to a calendar visible on home page

- chat function so artists can communicate

- document library linked so we can open it in AOS (Access on SharePoint)



Document library

- Can buttons in AOS make changes to document library

- Can we push a button in AOS and play a quicktime or mp4 from the document library



PDf reports needed.

- needs a way to filter and sort



Can we work off line, so we can be in the middle of no where, make updates and have them sync later ?



We want to license it to companies who are very security conscious. What are my security options ?

1438205398.5001

Bob Woodss

epwrn@aol.com

201-218-7254

I am converting access97 for my business applications to 2007 and eventually 2013.. 98% of the work is fine but running code from 97 modules is giving problems and errors. I am working at home to avoid distractions.and that number is 201-265-7030. My business number is 201-265-7778. I am the founder of the 40 year old business and am semi retired and the firm is presently being run by my son and daughter. As I was the one there from inception, I am most familiar with the databases. i would like to discuss the one problem we have to generate multible spreadsheets from code in a module that performs well from 97 but does not work in 2007 when converteded
Look foward to speaking with someone from your firm.
Bob Woods C&E Lockbox Services

1438017706.7969

mackenzie myles

mackmyles@live.ca

4167023577

Hi there,

I have a database that consists of; Investors, Funds, and Payments.

Each investor can be in many funds, and each fund is made up of many payments.

I need a database where I can add new investors, new funds and new payments anytime.

Example: Person1 can be in fund1 fund2 and fund3, and they made different payments to each fund.

Finnaly I need a form in which, when i search for a specific investor, it displays all the funds they are in, and each funds payments. It needs to be scalable, because I will eventually have 20+ funds.

I want my form to look similar to the "Main" form in my current database.

1437924002.3748

Mackenzie Myles

mackmyles@live.ca

4167023577

Hi there, I have a current database that I created from a bunch of excess documents.
Because they were imported from excel, i ran into problems because the database was not normalized, and i'm not adept enough at access to do this.

My database consists of:

Investors
Funds
Payments

Each Investor has contact information
Each Investor is part of many funds
Each Fund has many payments
Each payment consists of a date and a number
New funds are added constantly

*I want a form that can display each investor, which funds they are in, and they're payments for each fund.*

Note: I have no problem re-adding all the information again if that help. That way you can create a new blank database instead of dealing with my mess. Also, that way I have the form "Main" Set-up is the ideal form I want

1437859562.1602

TOMAS LOZANO

tlozano@nbty.com

714 934 3110

I'm looking to program an Access database to track our site's employee training. We are a manufacturing facility which employs ~275 associates at all levels and different business functions.

1437752804.7438

Perry T

perry-ceycantrans@rogers.com

647 892 5680

We are a small Canadian Freight Forwarding Company specializing in Shipping Personal Effects around the Globe and Commercial Cargo as well. At present we have an Access 2003 System and desire to upgrade it using Access 2013. We may require it to be integrated to an accounting software such as QuickBooks. Could you kindly let me have your Free Quote for this Project - Regards - Perry

1437699418.2158

Randy Shafer

randy@mailright.com

(916)842-6661

Looking for a Support Center call logging program. Have seen a few in MS Access that may be able to be tweaked to fit our needs

1437672663.2690

Bernadette Mitchell

Bernadette.Mitchell2@axa-advisors.com

973 615 2448

I'm trying to merge two EXCEL files using Microsoft access and I need some support I will need written instructions afterwards and someone to walk me through the process

1437584706.9865

Kathleen OGrady

KOGrady@beneficialcom.com

9417802983

Thank you for speaking to me. I hope I'm attaching 2 files, one is the database and the other is a copy of our basic structure.

In the database you will see an Entities table and a Relationship table.

What I am trying to achieve is to create a query that will allow me to input one entity (A), get a list of what entities A owns (B) and then the sub entities that are owned by the B companies down to the person level or, in the reverse up to the Limited Partnership level

I don't know if I'm going about this correctly or if I'm setting up the database of entities incorrectly.

The word document gives you a graphic idea of the structure of a typical development. For my current task, I need to produce experience listings for each entity within the chart.

I hope this explains my problem. Please contact me for more details

Kathleen O'Grady
941 780 2983

1437513184.7782

Amy

amy.qbs@gmail.com

310-975-9164

We are looking for someone to help us create two new databases precisely like 2 that we currently use for a charter high school. We had to let our IT person go and so we are unsure how to reset to new databases for the upcoming school year. We would need this done asap. Thanks so much!

1437494590.6933

Kathleen OGrady

KOGrady@beneficialcom.com

9417802983

I have a database query problem that I just can't figure out. Need help to know if it is designed wrong or if I just need a better query

1437491834.5613

Bill Dumond

bill.dumond@adm.com

612-340-5902

When using your services, is there a contract, and does it include a confidentiality clause? I need to make sure that the information your programmer would have access too by viewing our existing database is protected.

1437485861.2655

Mark Grissom

mdgmpa@gmail.com

615-396-7837

I have a database that I would like to have quoted. It would be desktop and tablet based with upload to webbased or direct from web based depending on available resources at the time of consultation. The project would be capturing processes and would be used to capture data for a future library. The results would be captured and disclosed in a report with task to do list and recommendations. would be work for hire as intellectual property.

1437363441.7479

Kevin Boydston

director@gkcltc.org

9134416100

we have an old access data base that was built by a amateur. using "Access for Dummies" and the "Access Bible" book. Our version of access is 2003 and we need help in properly designing for what we do , various reports forms gooies Etc.

1437061596.9512

Kristy Morgan

morgankristy66@gmail.com

0000000000

We are happy to announce our new "Performance Based SEO Program". We will only charge you when we will get real results for you in search engines. If you don't rank, you don't pay. Please reply to get more details.

1437049860.5226

Aubrey Ambinder

aubrey.ambinder@sgcib.com

(212) 278-6838

Hello! I am an Event Planning Specialist for Societe Generale Corporate & Investment Banking. Our team has been using the same database (made by someone years ago who had coding experience) for many years. We now want to create the same database in access, without linking any of the old information. I am hoping to get a quote from you guys and discuss more. I cannot send the file yet as it contains confidential information, and will need to get this signed off by our IT department. Please feel free to reach out at any time. Thanks!

1436988823.0976

Craig Conrad

craig.conrad@ahss.org

813 615-7200

We need an Access DB help to take a shared spreadsheet and turn it into a DB. The use of a single file by many people has obvious problems. We need the DB set up, some basic input screens and reports.

813 615-7200 ext 51059

1436980746.3441

DAvid Nuell

nuell@nicholsenvironmental.com

403-452-1820

I have a massive flat excel spreadsheet that I want to customize and I think Access would be able to help. I would be interested in talking to someone to see if we can retain you to complete this task.

1436896418.3478

Amberly Dawn Aiken

amberlyaiken85@gmail.com

772-999-8466

I was referred to you guy's by an employee named terry for access employment at the front desk employment I;m a very hard worker I went to kieser college for 2 years for a medical assistant and I helped my mom for the pass 16 years she is permanatly in a wheel chair and can not move I had to give her med's and take care of all her medical need's so im a good worker and thank you very much thank you sencirly Amberly Dawn Aiken

1436803423.3780

Bradley West

brad.west@shiloh.com

615-441-5010

Looking to get a quote to build an access database capable of handling material dispsotion. I've attached a text file with some suggestions from my team on how the database should work, .

1436565904.1565

Chris Rile

christopher.rile@nrg.com

7028065619

I would like some help finishing a database program because I'm getting in a little over my head. you can read about it at a forum I posted it to http://www.vbaexpress.com/forum/showthread.php?53153-Implement-outline-numbering-using-a-continuous-form-beginner I need a little more done than just that, and other aspects may pop later on, on the project, as well.

1436562921.7760

Steven

testmailsteven@gmail.com

This is a practice email for troubleshooting.

1436562033.9115

Jithin Mathew

jithin001@gmail.com

1234567890

test

1436554681.2204

Jithin Mathew

jithin001@gmail.com

0987654321

rdxfchvhbjlk

1436554286.1565

Jithin Mathew

jithin001@gmail.com

0987654321

testing gmail fwdr

1436553395.4154

Jithin Mathew

jithin001@gmail.com

0987654321

routing forwarder Test

1436553053.8804

Jithin Mathew

jithin@noedge.in

1234567890

aSRYDIGOIOP

1436552722.2727

Jithin

jtihin001@gmail.com

1234567890

forwarder test

1436552392.9657

Jim Shirley

JShirleyd1@pershingcounty.net

775273 2105

I think that just submitted a request for a quote with improper contact info....The info herein is correct.

1436552104.4585

Scott Whitlatch

test@123.com

098765432

xxcbnm,.

1436552104.4502

Jithin Mathew

jithin001@gmail.com

0987654321

sdfghjkl;'

1436552029.9043

Jim Shirley

JShirleyd1@pershingcounty.net

7752732613

I would like to create a database projection that would be an online application. It would have interview questions similar which would assist individuals filling out form documents. It would be similar to a flow chart, where depending on the answers, additional questions will or will not be needed. I have all the form documents in a Word format, with indicated places for the data. This may be a multi-phase implemented program. Or if grant funding is sufficient, we could do it all at once. The documents are divorce pleadings. The options progress with various issues: Children/no children, Retirement account/no account, etc..,.,.. I would like to see a series of questions that ask for the data and then input the data into the forms and allow them to be printed out.

1436551948.6037

jtihin

jithin001@gmail.com

0987654321

sdfghjkl

1436551890.5361

Jithin Mathew

jithin001@gmail.com

8287595775

testing final

1436551512.2123

Jithin Mathew

jithin001@gmail.com

0987654321

jithin test

1436551342.2050

Jithin Mathew

jithin001@gmail.com

123456789

asdfgh

1436546372.5668

Jithin Mathew

jithin001@gmail.com

9400206150

testing 123

1436546265.3453

rob

robt541@live.com

test

1436544830.8837

jithin mathew

jithin001@gmail.com

sdfgjkh

1436544575.6677